Question 1

An enterprise key is a foreign key whose value is unique across all relations.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following anomalies result from a transitive dependency?

Accepted Answer

A)  Insertion 
B)  Modification 
C)  Deletion 
D)  All of the above 
A)  Insertion 
B)  Modification 
C)  Deletion 
D)  All of the above

Question 3

A(n)________ is an attribute that uniquely identifies each row in a relation.

Accepted Answer

The answer of A(n)________ is an attribute that uniquely identifies...

Question 4

The allowable range of values for a given attribute is part of the domain constraint.

Accepted Answer

A) True 
 B)False

Question 5

In the figure below,each employee has exactly one manager.

Accepted Answer

A) True 
 B)False

Question 6

Two or more attributes having different names but the same meaning are called:

Accepted Answer

A)  homonyms. 
B)  aliases. 
C)  synonyms. 
D)  alternate attributes. 
A)  homonyms. 
B)  aliases. 
C)  synonyms. 
D)  alternate attributes.

Question 7

The relational data model does at this time directly support subtype/supertype relationships.

Accepted Answer

A) True 
 B)False

Question 8

The normal form which deals with multivalued dependencies is called:

Accepted Answer

A)  Fifth normal form. 
B)  Fourth normal form. 
C)  Boyce-Codd normal form. 
D)  Sixth normal form. 
A)  Fifth normal form. 
B)  Fourth normal form. 
C)  Boyce-Codd normal form. 
D)  Sixth normal form.

Question 9

A relation that contains minimal redundancy and allows easy use is considered to be:

Accepted Answer

A)  clean. 
B)  simple. 
C)  complex. 
D)  well-structured. 
A)  clean. 
B)  simple. 
C)  complex. 
D)  well-structured.

Question 10

Sometimes,associative entities have ________ identifiers assigned to them.

Accepted Answer

The answer of Sometimes,associative entities have ________ identifiers assigned to...

Question 11

A candidate key is an attribute,or combination of attributes,that uniquely identifies a row in a relation.

Accepted Answer

A) True 
 B)False

Question 12

A nonkey attribute is also called a(n):

Accepted Answer

A)  column. 
B)  unimportant datum. 
C)  descriptor. 
D)  address. 
A)  column. 
B)  unimportant datum. 
C)  descriptor. 
D)  address.

Question 13

Anomalies do not generally arise out of transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 14

In the figure below,the primary key for "Order Line" is which type of key?

Accepted Answer

A)  Composite 
B)  Foreign 
C)  Standard 
D)  Grouped 
A)  Composite 
B)  Foreign 
C)  Standard 
D)  Grouped

Question 15

Data integrity consists of powerful operations to manipulate data stored in relations.

Accepted Answer

A) True 
 B)False

Question 16

When transforming a weak entity,one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.

Accepted Answer

A) True 
 B)False

Question 17

A primary key whose value is unique across all relations is called a(n):

Accepted Answer

A)  global primary key. 
B)  inter-table primary key. 
C)  enterprise key. 
D)  foreign global key. 
A)  global primary key. 
B)  inter-table primary key. 
C)  enterprise key. 
D)  foreign global key.

Question 18

A(n)________ is one that references the primary key values of the same relation.

Accepted Answer

recursive

Question 19

A(n)________ is a constraint between two attributes or two sets of attributes.

Accepted Answer

functional

Question 20

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Accepted Answer

A)  referential integrity constraint. 
B)  key match rule. 
C)  entity key group rule. 
D)  foreign/primary match rule. 
A)  referential integrity constraint. 
B)  key match rule. 
C)  entity key group rule. 
D)  foreign/primary match rule.

An enterprise key is a foreign key whose value is unique across all relations.

Which of the following anomalies result from a transitive dependency?

A(n)________ is an attribute that uniquely identifies each row in a relation.

The allowable range of values for a given attribute is part of the domain constraint.

In the figure below,each employee has exactly one manager.

Two or more attributes having different names but the same meaning are called:

The relational data model does at this time directly support subtype/supertype relationships.

The normal form which deals with multivalued dependencies is called:

A relation that contains minimal redundancy and allows easy use is considered to be:

Sometimes,associative entities have ________ identifiers assigned to them.

A candidate key is an attribute,or combination of attributes,that uniquely identifies a row in a relation.

A nonkey attribute is also called a(n):

Anomalies do not generally arise out of transitive dependencies.

In the figure below,the primary key for "Order Line" is which type of key?

Data integrity consists of powerful operations to manipulate data stored in relations.

When transforming a weak entity,one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.

A primary key whose value is unique across all relations is called a(n):

A(n)________ is one that references the primary key values of the same relation.

A(n)________ is a constraint between two attributes or two sets of attributes.

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 4: Logical Database Design and the Relational Model

An enterprise key is a foreign key whose value is unique across all relations.

Which of the following anomalies result from a transitive dependency?

A(n)________ is an attribute that uniquely identifies each row in a relation.

The allowable range of values for a given attribute is part of the domain constraint.

In the figure below,each employee has exactly one manager.

Two or more attributes having different names but the same meaning are called:

The relational data model does at this time directly support subtype/supertype relationships.

The normal form which deals with multivalued dependencies is called:

A relation that contains minimal redundancy and allows easy use is considered to be:

Sometimes,associative entities have ________ identifiers assigned to them.

A candidate key is an attribute,or combination of attributes,that uniquely identifies a row in a relation.

A nonkey attribute is also called a(n):

Anomalies do not generally arise out of transitive dependencies.

In the figure below,the primary key for "Order Line" is which type of key?

Data integrity consists of powerful operations to manipulate data stored in relations.

When transforming a weak entity,one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.

A primary key whose value is unique across all relations is called a(n):

A(n)________ is one that references the primary key values of the same relation.

A(n)________ is a constraint between two attributes or two sets of attributes.

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters