DBMS Exam: Questions With Solutions (Rated A+)
The binary constraint MUST NOT indicates that ________. Right Ans - a
binary relationship includes value combinations that must not occur in a
ternary relationship
When transforming an ID-dependent E-R data model relationship into a
relational database design and the child entity is designed to use a surrogate
key, then ________. Right Ans - the relationship changes to a non-ID-
dependent relationship
In relational database design, ID-dependent entities are used to ________.
Right Ans - handle associative relationships
handle multivalued attributes
represent N:M relationships
handle archetype/instance relationships
Which of the following is not a step in the database design process? Right
Ans - Create constraints and triggers
The binary constraint MUST COVER indicates that ________. Right Ans - a
binary relationship includes a set of value combinations that must all occur in
a ternary relationship
The ideal primary key is ________. Right Ans - numeric
short
fixed
To represent a one-to-many relationship in a relational database design
________. Right Ans - the key of the parent is placed as a foreign key into the
child
The first step in transforming an extended E-R model into a relational
database design is to ________. Right Ans - create a table for each entity
The binary constraint MUST NOT indicates that ________. Right Ans - a
binary relationship includes value combinations that must not occur in a
ternary relationship
When transforming an ID-dependent E-R data model relationship into a
relational database design and the child entity is designed to use a surrogate
key, then ________. Right Ans - the relationship changes to a non-ID-
dependent relationship
In relational database design, ID-dependent entities are used to ________.
Right Ans - handle associative relationships
handle multivalued attributes
represent N:M relationships
handle archetype/instance relationships
Which of the following is not a step in the database design process? Right
Ans - Create constraints and triggers
The binary constraint MUST COVER indicates that ________. Right Ans - a
binary relationship includes a set of value combinations that must all occur in
a ternary relationship
The ideal primary key is ________. Right Ans - numeric
short
fixed
To represent a one-to-many relationship in a relational database design
________. Right Ans - the key of the parent is placed as a foreign key into the
child
The first step in transforming an extended E-R model into a relational
database design is to ________. Right Ans - create a table for each entity