Question 1

Which of the following relational algebra commands or combination of commands is capable of retrieving a single cell value from a relation?

Accepted Answer

A)  Select. 
B)  Project. 
C)  Join. 
D)  Select and Project. 
E)  Select, Project, and Join. 
A)  Select. 
B)  Project. 
C)  Join. 
D)  Select and Project. 
E)  Select, Project, and Join.

Question 2

The relational data model was first described in a paper by Dr. E. F. Codd in ____.

Accepted Answer

A)  1965 
B)  1970 
C)  1975 
D)  1980 
E)  1985 
A)  1965 
B)  1970 
C)  1975 
D)  1980 
E)  1985

Question 3

Performance issues delayed the introduction of relational database management systems as viable commercial products.

Accepted Answer

A) True 
 B)False

Question 4

In a relational Join operation, the join attributes must have the same attribute names.

Accepted Answer

A) True 
 B)False

Question 5

All of the following are true about storing a one-to-one binary relationship in a relational database, except _____.

Accepted Answer

A)  an additional relation must be added to the database 
B)  two additional relations must be added to the database 
C)  the primary key of one of the relations in placed in the other relation as a foreign key 
D)  the two relations involved in the one-to-one relationship can be combined into one relation 
E)  a particular value of the primary key of one relation is associated with exactly one value of the primary key of the other relation (or possibly with none) 
A)  an additional relation must be added to the database 
B)  two additional relations must be added to the database 
C)  the primary key of one of the relations in placed in the other relation as a foreign key 
D)  the two relations involved in the one-to-one relationship can be combined into one relation 
E)  a particular value of the primary key of one relation is associated with exactly one value of the primary key of the other relation (or possibly with none)

Question 6

A foreign key must have unique values in the relation in which it is a foreign key.

Accepted Answer

A) True 
 B)False

Question 7

A relation's primary key field can have non-unique values.

Accepted Answer

A) True 
 B)False

Question 8

Storing a many-to-many relationship in a relational database requires the creation of an additional relation.

Accepted Answer

A) True 
 B)False

Question 9

Depending on the circumstances, it is possible that a foreign key is part of the primary key of the relation in which it is a foreign key.

Accepted Answer

A) True 
 B)False

Question 10

An attribute or combination of attributes that is a foreign key in one relation of a database must be ____ another relation in the database.

Accepted Answer

A)  the primary key of 
B)  a secondary key of 
C)  an alternate key of 
D)  a non-unique attribute or combination of attributes of 
E)  None of the above. 
A)  the primary key of 
B)  a secondary key of 
C)  an alternate key of 
D)  a non-unique attribute or combination of attributes of 
E)  None of the above.

Question 11

All of the following events and factors in the early 1980s led to the introduction of relational database management, except ____.

Accepted Answer

A)  the introduction of personal computers 
B)  the fact that hierarchical and network DBMSs were too complex for the PC environment 
C)  the need for a DBMS approach that would make the database design process simpler than that of the hierarchical and network approaches 
D)  improvements in relational DBMS performance 
E)  improvements in mainframe computer performance 
A)  the introduction of personal computers 
B)  the fact that hierarchical and network DBMSs were too complex for the PC environment 
C)  the need for a DBMS approach that would make the database design process simpler than that of the hierarchical and network approaches 
D)  improvements in relational DBMS performance 
E)  improvements in mainframe computer performance

Question 12

The combination of a relational Select and a relational Project operation can return a single data value.

Accepted Answer

A) True 
 B)False

Question 13

In an equijoin, one of the two identical join columns in the result is eliminated.

Accepted Answer

A) True 
 B)False

Question 14

No two rows of a relation are identical.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following relational algebra commands or combination of commands is capable of retrieving one or more rows of a relation?

Accepted Answer

A)  Select. 
B)  Project. 
C)  Join. 
D)  Select and Project. 
E)  Select, Project, and Join. 
A)  Select. 
B)  Project. 
C)  Join. 
D)  Select and Project. 
E)  Select, Project, and Join.

Question 16

In a relational Join operation, the join attributes must have the same domain of values.

Accepted Answer

A) True 
 B)False

Question 17

In relational database terminology, the terms row and relation are synonymous.

Accepted Answer

A) True 
 B)False

Which of the following relational algebra commands or combination of commands is capable of retrieving a single cell value from a relation?

The relational data model was first described in a paper by Dr. E. F. Codd in ____.

Performance issues delayed the introduction of relational database management systems as viable commercial products.

In a relational Join operation, the join attributes must have the same attribute names.

All of the following are true about storing a one-to-one binary relationship in a relational database, except _____.

A foreign key must have unique values in the relation in which it is a foreign key.

A relation's primary key field can have non-unique values.

Storing a many-to-many relationship in a relational database requires the creation of an additional relation.

Depending on the circumstances, it is possible that a foreign key is part of the primary key of the relation in which it is a foreign key.

An attribute or combination of attributes that is a foreign key in one relation of a database must be ____ another relation in the database.

All of the following events and factors in the early 1980s led to the introduction of relational database management, except ____.

The combination of a relational Select and a relational Project operation can return a single data value.

In an equijoin, one of the two identical join columns in the result is eliminated.

No two rows of a relation are identical.

Which of the following relational algebra commands or combination of commands is capable of retrieving one or more rows of a relation?

In a relational Join operation, the join attributes must have the same domain of values.

In relational database terminology, the terms row and relation are synonymous.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters

Exam 5: The Relational Database Model: Introduction

Which of the following relational algebra commands or combination of commands is capable of retrieving a single cell value from a relation?

The relational data model was first described in a paper by Dr. E. F. Codd in ____.

Performance issues delayed the introduction of relational database management systems as viable commercial products.

In a relational Join operation, the join attributes must have the same attribute names.

All of the following are true about storing a one-to-one binary relationship in a relational database, except _____.

A foreign key must have unique values in the relation in which it is a foreign key.

A relation's primary key field can have non-unique values.

Storing a many-to-many relationship in a relational database requires the creation of an additional relation.

Depending on the circumstances, it is possible that a foreign key is part of the primary key of the relation in which it is a foreign key.

An attribute or combination of attributes that is a foreign key in one relation of a database must be ____ another relation in the database.

All of the following events and factors in the early 1980s led to the introduction of relational database management, except ____.

The combination of a relational Select and a relational Project operation can return a single data value.

In an equijoin, one of the two identical join columns in the result is eliminated.

No two rows of a relation are identical.

Which of the following relational algebra commands or combination of commands is capable of retrieving one or more rows of a relation?

In a relational Join operation, the join attributes must have the same domain of values.

In relational database terminology, the terms row and relation are synonymous.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters