Question 1

Which of the following is not a step in the database design process?

Accepted Answer

A)  Create tables and columns from entities and attributes
B)  Select primary keys
C)  Represent relationships
D)  Create constraints and triggers
E)  All of the above are steps in the database design process.

Question 2

One of the important properties of a column is whether or not it is ________.

Accepted Answer

A)  found in more than one entity
B)  required
C)  character or numeric
D)  subject to normalization
E)  subject to denormalization

Question 3

In many-to-many relationships in a relational database design,________.

Accepted Answer

A)  the key of the child is placed as a foreign key into the parent
B)  the key of the parent is placed as a foreign key into the child
C)  the keys of both tables are placed in a third table
D)  the keys of both tables are joined into a composite key
E)  C and D E

Question 4

In relational database design,ID-dependent entities are used to ________.

Accepted Answer

A)  represent N:M relationships
B)  handle associative relationships
C)  handle multivalued attributes
D)  handle archetype/instance relationships
E)  All of the above.

Question 5

Data types are consistent across all DBMS products.

Accepted Answer

A) True 
 B)False

Question 6

The binary constraint MUST COVER indicates that ________.

Accepted Answer

A)  a specific binary relationship must be included in a ternary relationship
B)  a table includes values that must occur in a binary relationship
C)  a table includes values that must occur in a ternary relationship
D)  a binary relationship includes value combinations that must occur in a binary relationship
E)  a binary relationship includes a set of value combinations that must all occur in a ternary relationship

Question 7

A referential integrity constraint policy that insures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database is called cascading deletes.

Accepted Answer

A) True 
 B)False

Question 8

To represent an M:N relationship in a relational database design,in essence it is reduced to two 1:N relationships.

Accepted Answer

A) True 
 B)False  True

Question 9

A data constraint is a limitation on data values.

Accepted Answer

A) True 
 B)False

Question 10

To represent an IS-A relationship in a relational database design,the IS-A relationship must be converted into a HAS-A relationship.

Accepted Answer

A) True 
 B)False

Question 11

When placing a foreign key for a 1:1 relationship,the key of either table can be used as the foreign key in the other table.

Accepted Answer

A) True 
 B)False

Question 12

Association tables sometimes connect more than two entities.

Accepted Answer

A) True 
 B)False  True

Question 13

A surrogate key should be considered when ________.

Accepted Answer

A)  a relationship is M:N
B)  a composite key is required
C)  the key contains a lengthy text field
D)  the key contains a number
E)  an index needs to be created

Question 14

The values of a surrogate key have no meaning to the users.

Accepted Answer

A) True 
 B)False

Question 15

The binary constraint MUST NOT indicates that ________.

Accepted Answer

A)  a specific binary relationship must not be included in a ternary relationship
B)  a table includes values that must not occur in a binary relationship
C)  a table includes values that must not occur in a ternary relationship
D)  a binary relationship includes value combinations that must not occur in a binary relationship
E)  a binary relationship includes value combinations that must not occur in a ternary relationship

Question 16

When representing a one-to-many relationship in a relational database design,________.

Accepted Answer

A)  the parent is always on the one side of the "one-to-many" relationship
B)  the child is always on the one side of the "one-to-many" relationship
C)  either parent or child can be on the one side of the "one-to-many" relationship,and the choice is arbitrary
D)  either parent or child can be on the one side of the "one-to-many" relationship,and special criteria indicate which table should be on the one side
E)  None of the above is correct.

Question 17

Which of the following is not true of recursive relationships?

Accepted Answer

A)  When the recursive relationship is M:N,an intersection table is created.
B)  The rows of a single table can play two different roles.
C)  The techniques for representing the tables are the same as for non-recursive relationships except the rows are in the same table.
D)  Recursive relationships can be 1:1,1:N,or M:N relationships.
E)  Even when the relationship is 1:N,a new table must be defined to represent the relationship.

Question 18

In a relational database design,all relationships are expressed by ________.

Accepted Answer

A)  creating a primary key
B)  creating a foreign key
C)  creating a supertype
D)  creating a subtype
E)  creating a line between entities

Question 19

A surrogate key should be considered when the key contains a lengthy text field.

Accepted Answer

A) True 
 B)False

Question 20

An intersection table can have additional attributes besides the keys of its parent tables.

Accepted Answer

A) True 
 B)False

Exam 6: Transforming Data Models Into Database Designs

Which of the following is not a step in the database design process?

Correct AnswerverifiedShow Answer

One of the important properties of a column is whether or not it is ________.

Correct AnswerverifiedShow Answer

In many-to-many relationships in a relational database design,________.

Correct AnswerverifiedE

In relational database design,ID-dependent entities are used to ________.

Correct AnswerverifiedShow Answer

Data types are consistent across all DBMS products.

Correct AnswerverifiedShow Answer

The binary constraint MUST COVER indicates that ________.

Correct AnswerverifiedShow Answer

A referential integrity constraint policy that insures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database is called cascading deletes.

Correct AnswerverifiedShow Answer

To represent an M:N relationship in a relational database design,in essence it is reduced to two 1:N relationships.

Correct AnswerverifiedTrue

A data constraint is a limitation on data values.

Correct AnswerverifiedShow Answer

To represent an IS-A relationship in a relational database design,the IS-A relationship must be converted into a HAS-A relationship.

Correct AnswerverifiedShow Answer

When placing a foreign key for a 1:1 relationship,the key of either table can be used as the foreign key in the other table.

Correct AnswerverifiedShow Answer

Association tables sometimes connect more than two entities.

Correct AnswerverifiedTrue

A surrogate key should be considered when ________.

Correct AnswerverifiedShow Answer

The values of a surrogate key have no meaning to the users.

Correct AnswerverifiedShow Answer

The binary constraint MUST NOT indicates that ________.

Correct AnswerverifiedShow Answer

When representing a one-to-many relationship in a relational database design,________.

Correct AnswerverifiedShow Answer

Which of the following is not true of recursive relationships?

Correct AnswerverifiedShow Answer

In a relational database design,all relationships are expressed by ________.

Correct AnswerverifiedShow Answer

A surrogate key should be considered when the key contains a lengthy text field.

Correct AnswerverifiedShow Answer

An intersection table can have additional attributes besides the keys of its parent tables.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
E

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified