Data Models Into Database Designs MCQ
Test your knowledge with important Data Models Into Database Designs MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Data Models Into Database Designs MCQs on Bissoy. Bissoy App
-
An ideal primary key is short, numeric and seldom changing.
-
For every relationship, there are six possible referential integrity actions.
-
When the parent entity is required, a new parent row can always be inserted.
-
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
-
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
-
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.
-
Surrogate keys have much meaning for users.
-
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
-
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
-
The DBMS allows surrogate keys to be changed.
-
An intersection table is required to represent M:N relationships.
-
For every relationship, there are six possible sets of minimum cardinalities.
-
Intersection tables are ID-dependent on both their parent tables.
-
All primary keys are required.
-
When the parent entity is required, a new child row can always be inserted.
-
In a 1:1 relationship, the primary key placement is arbitrary.
-
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
-
In 1:N relationships, which entity becomes the parent entity is arbitrary.
-
The terms alternate key and candidate key mean the same thing.
-
A foreign key is used to implement relationships between tables.
-
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
-
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
-
For every relationship, how many possible sets of minimum cardinalities are there?
-
Each entity is represented as a(n):
-
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
-
Which is not true about surrogate keys?
-
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
-
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
-
The identifier of an entity will become the ________ of the new table.
-
Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?