Question 1

All of the data involved in a one-to-one binary relationship could be combined in one relation.

Accepted Answer

A) True 
 B)False  True

Question 2

A foreign key ____.

Accepted Answer

A)  must have the same column name(s) as the primary key from which it is derived 
B)  must not have the same column name(s) as the primary key from which it is derived 
C)  must have the same domain of values as the primary key from which it is derived 
D)  must not have the same domain of values as the primary key from which it is derived 
E)  must have a domain of values that is different from any other in the database 
A)  must have the same column name(s) as the primary key from which it is derived 
B)  must not have the same column name(s) as the primary key from which it is derived 
C)  must have the same domain of values as the primary key from which it is derived 
D)  must not have the same domain of values as the primary key from which it is derived 
E)  must have a domain of values that is different from any other in the database C

Question 3

Which of the following relational algebra commands or combination of commands is capable of retrieving a single cell value from the integrated result of two relations?

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

Question 4

An attribute(s) that functions as the primary key of relation A and as a foreign key in relation B of a relational database ____.

Accepted Answer

A)  must have unique values in both relations 
B)  must have unique values in relation A 
C)  must have unique values in relation B 
D)  must not have unique values in either relation 
E)  must have unique values in one relation if it has unique values in the other 
A)  must have unique values in both relations 
B)  must have unique values in relation A 
C)  must have unique values in relation B 
D)  must not have unique values in either relation 
E)  must have unique values in one relation if it has unique values in the other

Question 5

In a one-to-many binary relationship, the primary key from the "many side" of the relationship is inserted as a foreign key in the "one side" of the relationship.

Accepted Answer

A) True 
 B)False

Question 6

In relational database management, data integration takes place at the time that a relational query is processed.

Accepted Answer

A) True 
 B)False

Question 7

The relational Project operator retrieves one or more rows from a relation.

Accepted Answer

A) True 
 B)False

Question 8

A candidate key that is not chosen as a relation's primary key is called an alternate key.

Accepted Answer

A) True 
 B)False

Question 9

Doctors and patients are in a binary one-to-many relationship as:
 Doctor     Patient  To accomplish this in a relational database _____.

Accepted Answer

A)  The primary key of the DOCTOR relation is placed as a foreign key in the PATIENT relation. 
B)  The primary key of the PATIENT relation is placed as a foreign key in the DOCTOR relation. 
C)  Either of choice a or b will work. 
D)  Neither of choice a or b will work. 
E)  Nothing extra has to be done to accomplish this in a relational database. 
A)  The primary key of the DOCTOR relation is placed as a foreign key in the PATIENT relation. 
B)  The primary key of the PATIENT relation is placed as a foreign key in the DOCTOR relation. 
C)  Either of choice a or b will work. 
D)  Neither of choice a or b will work. 
E)  Nothing extra has to be done to accomplish this in a relational database.

Question 10

Today, relational DBMSs have limited commercial use in niche areas only.

Accepted Answer

A) True 
 B)False

Question 11

Storing a binary many-to-many relationship in a relational database ____.

Accepted Answer

A)  requires the insertion of a foreign key in one of the two relations representing the entities in the many-to-many relationship 
B)  requires the insertion of foreign keys in both of the relations representing the entities in the many-to-many relationship 
C)  does not require the addition of any additional relations 
D)  requires the addition of one additional relation 
E)  requires the addition of two additional relations 
A)  requires the insertion of a foreign key in one of the two relations representing the entities in the many-to-many relationship 
B)  requires the insertion of foreign keys in both of the relations representing the entities in the many-to-many relationship 
C)  does not require the addition of any additional relations 
D)  requires the addition of one additional relation 
E)  requires the addition of two additional relations

Question 12

An attribute(s) that acts as a foreign key in a relation ____.

Accepted Answer

A)  must be the entire primary key of that relation 
B)  cannot be part of the primary key of that relation 
C)  may be part of the primary key of that relation 
D)  must also be a foreign key in another relation of the database 
E)  None of the above. 
A)  must be the entire primary key of that relation 
B)  cannot be part of the primary key of that relation 
C)  may be part of the primary key of that relation 
D)  must also be a foreign key in another relation of the database 
E)  None of the above.

Question 13

Storing a many-to-many relationship in a relational database would require the creation of an additional relation even if there was no intersection data.

Accepted Answer

A) True 
 B)False

Question 14

The values of the primary key of a relation ____.

Accepted Answer

A)  cannot be unique 
B)  may be unique or non-unique 
C)  must be unique 
D)  must consist of a single attribute 
E)  None of the above. 
A)  cannot be unique 
B)  may be unique or non-unique 
C)  must be unique 
D)  must consist of a single attribute 
E)  None of the above.

Question 15

The two primary keys representing the entities in the many-to-many relationship will always serve as the primary key in the additional relation representing the many-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is true about the join fields used in a relational Join command?

Accepted Answer

A)  They must have the same attribute names. 
B)  They must have the same domain of values. 
C)  They must both be foreign keys. 
D)  All of the above. 
E)  None of the above. 
A)  They must have the same attribute names. 
B)  They must have the same domain of values. 
C)  They must both be foreign keys. 
D)  All of the above. 
E)  None of the above.

Question 17

A relational DBMS is capable of automating the cross-relation data extraction process in such a way that it appears that the data in the relation is integrated ____.

Accepted Answer

A)  by a relational Select command 
B)  by a relational Project command 
C)  by the combination of relational Select and Project commands 
D)  while also remaining redundant 
E)  while also remaining nonredundant 
A)  by a relational Select command 
B)  by a relational Project command 
C)  by the combination of relational Select and Project commands 
D)  while also remaining redundant 
E)  while also remaining nonredundant

Question 18

The relational Join operation accomplishes data integration in a relational database.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following relational algebra commands or combination of commands is capable of retrieving one or more columns 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 20

In a relation ____.

Accepted Answer

A)  several rows can be identical 
B)  the columns must be arranged in a single, particular order 
C)  the rows must be arranged in a single, particular order 
D)  a single row/column position, called a cell, can have multiple values 
E)  None of the above. 
A)  several rows can be identical 
B)  the columns must be arranged in a single, particular order 
C)  the rows must be arranged in a single, particular order 
D)  a single row/column position, called a cell, can have multiple values 
E)  None of the above.

All of the data involved in a one-to-one binary relationship could be combined in one relation.

A foreign key ____.

Which of the following relational algebra commands or combination of commands is capable of retrieving a single cell value from the integrated result of two relations?

An attribute(s) that functions as the primary key of relation A and as a foreign key in relation B of a relational database ____.

In a one-to-many binary relationship, the primary key from the "many side" of the relationship is inserted as a foreign key in the "one side" of the relationship.

In relational database management, data integration takes place at the time that a relational query is processed.

The relational Project operator retrieves one or more rows from a relation.

A candidate key that is not chosen as a relation's primary key is called an alternate key.

Doctors and patients are in a binary one-to-many relationship as: Doctor Patient To accomplish this in a relational database _____.

Today, relational DBMSs have limited commercial use in niche areas only.

Storing a binary many-to-many relationship in a relational database ____.

An attribute(s) that acts as a foreign key in a relation ____.

Storing a many-to-many relationship in a relational database would require the creation of an additional relation even if there was no intersection data.

The values of the primary key of a relation ____.

The two primary keys representing the entities in the many-to-many relationship will always serve as the primary key in the additional relation representing the many-to-many relationship.

Which of the following is true about the join fields used in a relational Join command?

A relational DBMS is capable of automating the cross-relation data extraction process in such a way that it appears that the data in the relation is integrated ____.

The relational Join operation accomplishes data integration in a relational database.

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

In a relation ____.

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

All of the data involved in a one-to-one binary relationship could be combined in one relation.

A foreign key ____.

Which of the following relational algebra commands or combination of commands is capable of retrieving a single cell value from the integrated result of two relations?

An attribute(s) that functions as the primary key of relation A and as a foreign key in relation B of a relational database ____.

In a one-to-many binary relationship, the primary key from the "many side" of the relationship is inserted as a foreign key in the "one side" of the relationship.

In relational database management, data integration takes place at the time that a relational query is processed.

The relational Project operator retrieves one or more rows from a relation.

A candidate key that is not chosen as a relation's primary key is called an alternate key.

Doctors and patients are in a binary one-to-many relationship as: Doctor Patient To accomplish this in a relational database _____.

Today, relational DBMSs have limited commercial use in niche areas only.

Storing a binary many-to-many relationship in a relational database ____.

An attribute(s) that acts as a foreign key in a relation ____.

Storing a many-to-many relationship in a relational database would require the creation of an additional relation even if there was no intersection data.

The values of the primary key of a relation ____.

The two primary keys representing the entities in the many-to-many relationship will always serve as the primary key in the additional relation representing the many-to-many relationship.

Which of the following is true about the join fields used in a relational Join command?

A relational DBMS is capable of automating the cross-relation data extraction process in such a way that it appears that the data in the relation is integrated ____.

The relational Join operation accomplishes data integration in a relational database.

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

In a relation ____.

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