Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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. 
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 3

What are MUST NOT and MUST COVER constraints?

Accepted Answer

Both MUST NOT and MUST COVER constraints

Question 4

When the key of one table is placed into a second table to represent a relationship,the key is called a "relational key" in the second table.

Accepted Answer

A) True 
 B)False

Question 5

In a 1:1 relationship,the foreign key is defined as an alternate key to make the DBMS enforce uniqueness.

Accepted Answer

A) True 
 B)False

Question 6

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. 
A) represent N:M relationships 
B) handle associative relationships 
C) handle multivalued attributes 
D) handle archetype/instance relationships 
E) All of the above.

Question 7

In a 1:N relationship,the term "parent" refers to the table on the "many" side of the relationship.

Accepted Answer

A) True 
 B)False

Question 8

It is easy to enforce the referential integrity actions for M-M relationships.

Accepted Answer

A) True 
 B)False

Question 9

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. 
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 10

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 
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

Question 11

A referential integrity constraint policy that guarantees that a row in a parent table always has a required entry in a child table ________.

Accepted Answer

A) is known as a minimum cardinality enforcement action 
B) needs to be documented by the database development team 
C) is enforced in most DBMS products 
D) A and B 
E) A,B and C 
A) is known as a minimum cardinality enforcement action 
B) needs to be documented by the database development team 
C) is enforced in most DBMS products 
D) A and B 
E) A,B and C

Question 12

The last step in creating a table is to verify table normalization.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not true about surrogate keys?

Accepted Answer

A) They are identifiers that are supplied by the system,not the users. 
B) They have no meaning to the users. 
C) They are nonunique within a table. 
D) They can be problematic when combining databases. 
E) The DBMS will not allow their values to be changed. 
A) They are identifiers that are supplied by the system,not the users. 
B) They have no meaning to the users. 
C) They are nonunique within a table. 
D) They can be problematic when combining databases. 
E) The DBMS will not allow their values to be changed.

Question 14

In representing a 1:N relationship in a relational database design,the key of the table representing the entity on the "many" side is placed as a foreign key in the table representing the entity on the "one" side of the relationship.

Accepted Answer

A) True 
 B)False

Question 15

A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.

Accepted Answer

A) incremental updates 
B) incremental deletes 
C) controlled key adjustments 
D) cascading updates 
E) cascading deletes 
A) incremental updates 
B) incremental deletes 
C) controlled key adjustments 
D) cascading updates 
E) cascading deletes

Question 16

A null value is an attribute value that has been set to zero.

Accepted Answer

A) True 
 B)False

Question 17

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

Accepted Answer

A) True 
 B)False

Question 18

The ideal primary key is short,numeric,and fixed.

Accepted Answer

A) True 
 B)False

Question 19

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 20

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

Accepted Answer

A) True 
 B)False

Exam 6: Transforming Data Models Into Database Designs

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

Which of the following is not true of recursive relationships?

What are MUST NOT and MUST COVER constraints?

When the key of one table is placed into a second table to represent a relationship,the key is called a "relational key" in the second table.

In a 1:1 relationship,the foreign key is defined as an alternate key to make the DBMS enforce uniqueness.

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

In a 1:N relationship,the term "parent" refers to the table on the "many" side of the relationship.

It is easy to enforce the referential integrity actions for M-M relationships.

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

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

A referential integrity constraint policy that guarantees that a row in a parent table always has a required entry in a child table ________.

The last step in creating a table is to verify table normalization.

Which of the following is not true about surrogate keys?

In representing a 1:N relationship in a relational database design,the key of the table representing the entity on the "many" side is placed as a foreign key in the table representing the entity on the "one" side of the relationship.

A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.

A null value is an attribute value that has been set to zero.

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

The ideal primary key is short,numeric,and fixed.

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.

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters