Database Test 3 Computer Subject
Database Test 3 Computer Subject
Question 41
Attributes may share a_____?
Attributes can share a domain, which defines the set of allowable values.
Not clear enough?
Question 42
Which of the following might be represented with a single valued attribute
A computer processor speed is a single value for a given entity, making it a single-valued attribute.
Not clear enough?
Question 43
If an entity can exist apart from one or more related entities it is said to be _____ independent.
Existence independence indicates that the entity can exist without relying on other entities.
Not clear enough?
Question 44
A Relationship is an association between_____?
Relationships associate entities with each other in a database.
Not clear enough?
Question 45
Data integrity constraints are used to _____?
Data integrity constraints help maintain high-quality data by enforcing rules on the values entered.
Not clear enough?
Question 46
Which of the following can be addressed by enforcing a referential integrity constraint?
Referential integrity ensures that related data exists before operations, such as a customer must exist before making a sale.
Not clear enough?
Question 47
_____ is a special type of integrity constraint that relates two relations and maintains consistency across the relations.
Referential integrity constraints maintain consistency between foreign keys in related tables.
Not clear enough?
Question 48
Drop table cannot be used to drop a table referenced by a _____ constraint.
A table referenced by a foreign key cannot be dropped without first removing the constraint.
Not clear enough?
Question 49
_____ is preferred method for enforcing Data integrity.
Constraints are the standard method to enforce data integrity at the database level.
Not clear enough?
Question 50
_____ express the number of entities to which another entity can be associated via a relationship set.
Mapping cardinality specifies how many instances of one entity type can be associated with another entity type.
Not clear enough?
You might like
2H₂ + O₂ → 2H₂O has ΔH = −571 kJ. How much heat is liberated if 12.0 g of hydrogen burns in excess oxygen?
An attribute in a relation is a foreign key if the _____ key from one relation is used as an attribute in that relation.
The measure of independence available to the individual business units that come together is the main difference between
In an examination there were 640 boys and 360 girls. 60% of boys and 80% of girls were successful. The percentage of failure was ?