A foreign key is used to implement relationships between tables.
Select an option to see the answer and solution.
Database · all questionsData Models into Database Designs
Data Models into Database Designs
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
The terms alternate key and candidate key mean the same thing.
Select an option to see the answer and solution.
In 1:N relationships, which entity becomes the parent entity is arbitrary.
Select an option to see the answer and solution.
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
Select an option to see the answer and solution.
In a 1:1 relationship, the primary key placement is arbitrary.
Select an option to see the answer and solution.
When the parent entity is required, a new child row can always be inserted.
Select an option to see the answer and solution.
All primary keys are required.
Select an option to see the answer and solution.
Intersection tables are ID-dependent on both their parent tables.
Select an option to see the answer and solution.
For every relationship, there are six possible sets of minimum cardinalities.
Select an option to see the answer and solution.
An intersection table is required to represent M:N relationships.
Select an option to see the answer and solution.
The DBMS allows surrogate keys to be changed.
Select an option to see the answer and solution.
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
Select an option to see the answer and solution.
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
Select an option to see the answer and solution.
Surrogate keys have much meaning for users.
Select an option to see the answer and solution.
When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
Select an option to see the answer and solution.
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
Select an option to see the answer and solution.
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
Select an option to see the answer and solution.
When the parent entity is required, a new parent row can always be inserted.
Select an option to see the answer and solution.
For every relationship, there are six possible referential integrity actions.
Select an option to see the answer and solution.
An ideal primary key is short, numeric and seldom changing.
Select an option to see the answer and solution.