Data Models Into Database Designs MCQs with Explanations

A domain constraint is the correct answer to “Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

the child table. is the correct answer to “In a 1:N relationship, the foreign key is placed in:”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

Null status is the correct answer to “Which of the following column properties specifies whether or not cells in a column must contain a data value”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

NOT NULL. is the correct answer to “A primary key should be defined as:”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

Data type is the correct answer to “Which of the following column properties would be used to specify that cells in a column must contain a monetary value”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

All of the above use ID dependent entities is the correct answer to “Which of the following situation requires the use of ID-dependent entities”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

a column containing the primary key of another table. is the correct answer to “A foreign key is:”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

A primary key is the correct answer to “Which of the following columns is(are) are required in a table”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

either table without specifying parent and child tables. is the correct answer to “In a 1:1 relationship, the foreign key is placed in:”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

Default value is the correct answer to “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”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

primary key is the correct answer to “The identifier of an entity will become the ________ of the new table.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

An intrarelation constraint is the correct answer to “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”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

surrogate key. is the correct answer to “A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

They have meaning to the user. is the correct answer to “Which is not true about surrogate keys”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

Six is the correct answer to “For every relationship, how many possible types of actions are there when enforcing minimum cardinalities”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

MUST COVER is the correct answer to “Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

table. is the correct answer to “Each entity is represented as a(n):”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

Four is the correct answer to “For every relationship, how many possible sets of minimum cardinalities are there”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

the primary key is the correct answer to “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.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

Data constraints is the correct answer to “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”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “A foreign key is used to implement relationships between tables.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “The terms alternate key and candidate key mean the same thing.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

False is the correct answer to “In 1:N relationships, which entity becomes the parent entity is arbitrary.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “In a 1:1 relationship, the primary key placement is arbitrary.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

False is the correct answer to “When the parent entity is required, a new child row can always be inserted.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “All primary keys are required.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “Intersection tables are ID-dependent on both their parent tables.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

False is the correct answer to “For every relationship, there are six possible sets of minimum cardinalities.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “An intersection table is required to represent M:N relationships.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

False is the correct answer to “The DBMS allows surrogate keys to be changed.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

False is the correct answer to “Cascading updates refers to child rows being automatically deleted when a parent row is deleted.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “When transforming an entity-relationship model into a relational database design, each entity is represented as a table.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

False is the correct answer to “Surrogate keys have much meaning for users.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “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.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

False is the correct answer to “(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “When the parent entity is required and the parent has a surrogate key, update actions can be ignored.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “When the parent entity is required, a new parent row can always be inserted.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “For every relationship, there are six possible referential integrity actions.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.

True is the correct answer to “An ideal primary key is short, numeric and seldom changing.”. This question is standard in competitive examination syllabi for Data Models Into Database Designs.