Deck 3: The Relational Data Model

Question 1

The referential integrity rule prohibits foreign keys to have null values.

Answer 1

False
Explanation: Null values are permitted in foreign keys but are not common.

Question 2

Using the extended cross product operator on tables M and N,the numbers of rows in the result table can be computed as M + N,while the number of columns can be computed as M*N.

Answer 2

False
Explanation: The number of rows would be M*N, the number of columns would be M+N.

Question 3

In the project operation of relational algebra,when a subset of columns is retrieved and the resulting table contains duplicate rows,the project operator will automatically remove the duplicate rows.

Answer 3

True

Question 4

M-N relationships cannot be directly represented in the Relational Model,but rather must be represented by two 1-M relationships and a linking or associative table.

Question 5

In the case of a natural join,where one of the join columns is removed in the result table,it is important for future reference to be able to determine the particular column that will be removed.

Question 6

With regards to referential integrity constraints,a row is considered referenced if there are rows in a child table with foreign key values identical to the primary key value of the parent table.

Question 7

Unary relationships involve multiple tables and are common in database design.

Question 8

Candidate keys that are not primary keys are declared with the DISTINCT keyword in the CONSTRAINT clause of the CREATE TABLE statement.

Question 9

Because they are commonly occur,and contain columns that do not contribute to the uniqueness of a key,it is usually important to identify all possible minimal superkeys when designing a table.

Question 10

The natural join operator provides the ability to include nonmatching rows in the result table as well as matching rows.

Question 11

The extended cross product operator can only combine two tables that are union compatible.

Question 12

When using a full outer join between two tables having some common columns and some unique columns,columns from the first table that do not have corresponding columns in the second table would contain null values and columns from the second table that do not have corresponding columns in the first table would contain null values.

Question 13

An advantage of using a constraint name in the CONSTRAINT clause of the CREATE TABLE statement is that the constraint will be easy to identify when a violation occurs.

Question 14

The relational algebra operator restrict produces a subset of columns of the input table,while the operator project produces a subset of rows.

Question 15

Regarding delete and update actions on referenced rows,the CREATE TABLE statement allows you to restrict or cascade the action,but does not allow to specify a new value for the foreign key of the related rows.

Question 16

In a relational database,each table has a heading or definition part and a body or content part.

Question 17

In an outer join operation,the join condition is equality,one of the join columns is discarded in the result table,and the join columns have the same unqualified name.

Question 18

Each operator of relational algebra transforms one or more tables into a new table.

Question 19

A disadvantage of using the extended cross product operator by itself is that it often generates excessive data consisting of many rows of meaningless combinations.

Question 20

The referential integrity rule ensures that people,things and events are uniquely identified in a database.

Question 21

To be union compatible,each table must have the same number of columns,and there must be positional correspondence between the columns with regards to the data types.

Question 22

$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptno } & \text { Empsalary } & \text { Emptitle } \\\hline\end{array}$
Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline\end{array}$
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.

$Table~Project\\\begin{array}{|l|l|l|}\hline \text { Projno } & \text { Projname } & \text { Projmgr } \\\hline\end{array}$
The table Projstaff indicates the staff assigned to various Projects.

$Table~Project\\\begin{array}{|l|l|l|l|l|}\hline \text { Prstno } & \text { Prstempno } & \text { Prsthours } & \text { Prstdate } & \text { Prstasgtno } \\\hline\end{array}$
The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate
keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.

-Which of the following columns or combination of columns may not be a candidate key of the table Projstaff?

A) Prstno, Prstempno
B) Prstasgtno
C) Prstno, Prstempno, Prsthours
D) Prstno, Prstasgtno

Question 23

$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptno } & \text { Empsalary } & \text { Emptitle } \\\hline\end{array}$
Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline\end{array}$
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.

$Table~Project\\\begin{array}{|l|l|l|}\hline \text { Projno } & \text { Projname } & \text { Projmgr } \\\hline\end{array}$
The table Projstaff indicates the staff assigned to various Projects.

$Table~Project\\\begin{array}{|l|l|l|l|l|}\hline \text { Prstno } & \text { Prstempno } & \text { Prsthours } & \text { Prstdate } & \text { Prstasgtno } \\\hline\end{array}$
The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate
keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.

-Which of the following columns of the table Department is a foreign key?

A) Deptno
B) Deptname
C) Deptcity
D) Deptmgr

Question 24

$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptno } & \text { Empsalary } & \text { Emptitle } \\\hline\end{array}$
Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline\end{array}$
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.

$Table~Project\\\begin{array}{|l|l|l|}\hline \text { Projno } & \text { Projname } & \text { Projmgr } \\\hline\end{array}$
The table Projstaff indicates the staff assigned to various Projects.

$Table~Project\\\begin{array}{|l|l|l|l|l|}\hline \text { Prstno } & \text { Prstempno } & \text { Prsthours } & \text { Prstdate } & \text { Prstasgtno } \\\hline\end{array}$
The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate
keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.

-To retrieve the projects in which any employee participates,the following operator would be used:

A) Outer join
B) Natural join
C) Divide
D) Extended cross product

Question 25

The following data are in the tables Employee (primary key: Empno) and Department (primary key: Deptno). The questions refer to row numbers of this table. The first row of each table is row #1. Empdeptno in table Employee is a foreign key that refers to Deptno in the table Department. Deptmgr in the table Department is a foreign key that refers to Empno in the table Employee.
$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptro } & \text { Empsalary } & \text { Emptitle } \\\hline 555 & \text { Keamy } & 200 & 7000 & \text { manager } \\\hline 666 & \text { Williams } & 100 & 8000 & \text { manager } \\\hline 777 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline 888 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline & \text { Johnson } & 300 & 4000 & \text { analyst } \\\hline 889 & \text { Dupont } & 400 & & \\\hline & \text { McCabe } & 400 & 6000 & \text { programmer } \\\hline 999 & \text { Lopez } & & 9000 & \text { manager } \\\hline\end{array}$

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

-The relationship connecting Employee to Department and expressing that an employee is the manager of a department (foreign key: Deptmgr)is:

A) 1-M from Employee to Department
B) 1-M from Department to Employee
C) M-N
D) Self-referencing

Question 26

A foreign key is indicated in SQL in part with the use of the following keywords in a CREATE statement:

A) UNIQUE
B) NOT NULL
C) PRIMARY KEY
D) REFERENCES

Question 27

$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptno } & \text { Empsalary } & \text { Emptitle } \\\hline\end{array}$
Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline\end{array}$
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.

$Table~Project\\\begin{array}{|l|l|l|}\hline \text { Projno } & \text { Projname } & \text { Projmgr } \\\hline\end{array}$
The table Projstaff indicates the staff assigned to various Projects.

$Table~Project\\\begin{array}{|l|l|l|l|l|}\hline \text { Prstno } & \text { Prstempno } & \text { Prsthours } & \text { Prstdate } & \text { Prstasgtno } \\\hline\end{array}$
The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate
keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.

-The _______ part of a table consists of the table name and the column names.The ______ body shows the rows of the table.

A) Body, heading
B) Heading, body
C) Heading, context store
D) Hyper data, body

Question 28

$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptno } & \text { Empsalary } & \text { Emptitle } \\\hline\end{array}$
Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline\end{array}$
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.

$Table~Project\\\begin{array}{|l|l|l|}\hline \text { Projno } & \text { Projname } & \text { Projmgr } \\\hline\end{array}$
The table Projstaff indicates the staff assigned to various Projects.

$Table~Project\\\begin{array}{|l|l|l|l|l|}\hline \text { Prstno } & \text { Prstempno } & \text { Prsthours } & \text { Prstdate } & \text { Prstasgtno } \\\hline\end{array}$
The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate
keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.

-If the combination Prstno,Prstempno is chosen as the primary key for table Projstaff,setting Prstno to null in some row would be:

A) A violation of the entity integrity rule
B) A violation of the referential integrity rule
C) A violation of the entity integrity rule and of the referential integrity rule
D) None of the above

Question 29

$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptno } & \text { Empsalary } & \text { Emptitle } \\\hline\end{array}$
Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline\end{array}$
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.

$Table~Project\\\begin{array}{|l|l|l|}\hline \text { Projno } & \text { Projname } & \text { Projmgr } \\\hline\end{array}$
The table Projstaff indicates the staff assigned to various Projects.

$Table~Project\\\begin{array}{|l|l|l|l|l|}\hline \text { Prstno } & \text { Prstempno } & \text { Prsthours } & \text { Prstdate } & \text { Prstasgtno } \\\hline\end{array}$
The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate
keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.

-The relationship connecting Employee to Project and expressing that an employee works on a project (Link table Projstaff)is:

A) 1-M from employee to project
B) 1-M from project to employee
C) M-N
D) Self-referencing

Question 30

One specialized use of the union,intersection and difference operators is to combine tables distributed over multiple locations.

Question 31

$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptno } & \text { Empsalary } & \text { Emptitle } \\\hline\end{array}$
Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline\end{array}$
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.

$Table~Project\\\begin{array}{|l|l|l|}\hline \text { Projno } & \text { Projname } & \text { Projmgr } \\\hline\end{array}$
The table Projstaff indicates the staff assigned to various Projects.

$Table~Project\\\begin{array}{|l|l|l|l|l|}\hline \text { Prstno } & \text { Prstempno } & \text { Prsthours } & \text { Prstdate } & \text { Prstasgtno } \\\hline\end{array}$
The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate
keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.

-To retrieve the projects in which all employees participate,the following operator would be used:

A) Outer join
B) Natural join
C) Divide
D) Extended cross product

Question 32

The following data are in the tables Employee (primary key: Empno) and Department (primary key: Deptno). The questions refer to row numbers of this table. The first row of each table is row #1. Empdeptno in table Employee is a foreign key that refers to Deptno in the table Department. Deptmgr in the table Department is a foreign key that refers to Empno in the table Employee.
$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptro } & \text { Empsalary } & \text { Emptitle } \\\hline 555 & \text { Keamy } & 200 & 7000 & \text { manager } \\\hline 666 & \text { Williams } & 100 & 8000 & \text { manager } \\\hline 777 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline 888 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline & \text { Johnson } & 300 & 4000 & \text { analyst } \\\hline 889 & \text { Dupont } & 400 & & \\\hline & \text { McCabe } & 400 & 6000 & \text { programmer } \\\hline 999 & \text { Lopez } & & 9000 & \text { manager } \\\hline\end{array}$

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

-Which of the following statements is true?

A) Rows #3 and #4 of table Employee, considered together, violate neither the entity integrity rule nor the referential integrity rule.
B) Rows #3 and #4 of table Employee, considered together, violate the entity integrity rule.
C) Rows #3 and #4 of table Employee, considered together, violate the referential integrity rule.
D) Rows #3 and #4 of table Employee, considered together, violate both the entity integrity rule and the referential integrity rule.

Question 33

A candidate key is indicated in SQL with the use of the following keywords in a CREATE statement:

A) UNIQUE
B) NOT NULL
C) PRIMARY KEY
D) REFERENCES

Question 34

To perform a difference operation on two tables,the tables do not have to be union compatible.

Question 35

An unknown value,or a value that does not apply to a given row of a table,is indicated by:

A) The value 0
B) The string of characters "null"
C) The null value
D) The string of characters "NA"

Question 36

Only a limited number of simple statistical functions can be used to summarize groups of rows in a query.

Question 37

The following data are in the tables Employee (primary key: Empno) and Department (primary key: Deptno). The questions refer to row numbers of this table. The first row of each table is row #1. Empdeptno in table Employee is a foreign key that refers to Deptno in the table Department. Deptmgr in the table Department is a foreign key that refers to Empno in the table Employee.
$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptro } & \text { Empsalary } & \text { Emptitle } \\\hline 555 & \text { Keamy } & 200 & 7000 & \text { manager } \\\hline 666 & \text { Williams } & 100 & 8000 & \text { manager } \\\hline 777 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline 888 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline & \text { Johnson } & 300 & 4000 & \text { analyst } \\\hline 889 & \text { Dupont } & 400 & & \\\hline & \text { McCabe } & 400 & 6000 & \text { programmer } \\\hline 999 & \text { Lopez } & & 9000 & \text { manager } \\\hline\end{array}$

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

-The relationship connecting Employee to Department and expressing that an employee belongs to a department (foreign key Empdeptno)is:

A) 1-M from Employee to Department
B) 1-M from Department to Employee
C) M-N
D) Self-referencing

Question 38

$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptno } & \text { Empsalary } & \text { Emptitle } \\\hline\end{array}$
Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline\end{array}$
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.

$Table~Project\\\begin{array}{|l|l|l|}\hline \text { Projno } & \text { Projname } & \text { Projmgr } \\\hline\end{array}$
The table Projstaff indicates the staff assigned to various Projects.

$Table~Project\\\begin{array}{|l|l|l|l|l|}\hline \text { Prstno } & \text { Prstempno } & \text { Prsthours } & \text { Prstdate } & \text { Prstasgtno } \\\hline\end{array}$
The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate
keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.

-Which of the following columns is not a foreign key?

A) Projno in table Project
B) Projmgr in table Project
C) Prstno in table Projstaff
D) Prstempno in table Projstaff

Question 39

A divide operator is used to retrieve rows in which the values of one column contain every value in another column.

Question 40

The primary key of a table is chosen among:

A) All attributes
B) All superkeys
C) All combinations of all attributes
D) All candidate keys

Question 41

A relationship in which a foreign key refers to the same table and represents an association among the members of the same set is known as a(n)__________________ relationship.

Question 42

The ____________________ rule states that each table must have a column or combination of columns with unique values.

Question 43

The tables Dept1 and Dept2 are as follows
$Table~Dept1\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

$Table~Dept2\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline 400 & \text { Sales } & \text { Reno } & 666 \\\hline\end{array}$

-A relational algebra operator applied to tables Dept1 and Dept2 produces the following result: $$\begin{array} { | l | l | l | l | } \hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$$ The operation is:

A) Dept1 UNION Dept2
B) Dept1 INTERSECT Dept2
C) Dept1 DIFFERENCE Dept2
D) Dept2 DIFFERENCE Dept1

Question 44

When more than one column in a table is needed to uniquely identify a row,this type of primary key is called a(n)________________ .

Question 45

A(n)__________________ is a connection between rows in two tables,which is shown by column values in one table that match column values in another table.

Question 46

The tables Dept1 and Dept2 are as follows
$Table~Dept1\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

$Table~Dept2\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline 400 & \text { Sales } & \text { Reno } & 666 \\\hline\end{array}$

-A relational algebra operator applied to tables Dept1 and Dept2 produces the following result: $$\begin{array} { | l | l | l | l | } \hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline 400 & \text { Sales } & \text { Reno } & 666 \\\hline\end{array}$$ The operation is:

A) Dept1 UNION Dept2
B) Dept1 INTERSECT Dept2
C) Dept1 DIFFERENCE Dept2
D) Dept2 DIFFERENCE Dept1

Question 47

The _______________ clause of the CREATE TABLE statement is used to define primary and foreign keys.

Question 48

In the record-oriented database terminology,a(n)_____________ is synonymous with a column.

Question 49

The tables Dept1 and Dept2 are as follows
$Table~Dept1\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

$Table~Dept2\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline 400 & \text { Sales } & \text { Reno } & 666 \\\hline\end{array}$

-A relational algebra operator applied to tables Dept1 and Dept2 produces the following result: $$\begin{array} { | l | l | l | l | } \hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline\end{array}$$ The operation is:

A) Dept1 UNION Dept2
B) Dept1 INTERSECT Dept2
C) Dept1 DIFFERENCE Dept2
D) Dept2 DIFFERENCE Dept1

Question 50

To ensure that a database contains valid connections,the _____________________ rule states that the values of columns in one table must match the values of columns in other tables.

Question 51

In the alternative terminology for relational databases,the ______________ -oriented terminology uses the terms file,record and field,and appeals to information systems professionals.

Question 52

For each column in a table,the ___________________ defines a set of values and permissible operations on those values.

Question 53

A relational algebra operator produces the following result on the table Department: $$\begin{array} { | l | l | l | l | } \hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$$ That operator is:

A) The restrict operator
B) The project operator
C) The extended cross product operator
D) A join operator

Question 54

The following data are in the tables Employee (primary key: Empno) and Department (primary key: Deptno). The questions refer to row numbers of this table. The first row of each table is row #1. Empdeptno in table Employee is a foreign key that refers to Deptno in the table Department. Deptmgr in the table Department is a foreign key that refers to Empno in the table Employee.
$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptro } & \text { Empsalary } & \text { Emptitle } \\\hline 555 & \text { Keamy } & 200 & 7000 & \text { manager } \\\hline 666 & \text { Williams } & 100 & 8000 & \text { manager } \\\hline 777 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline 888 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline & \text { Johnson } & 300 & 4000 & \text { analyst } \\\hline 889 & \text { Dupont } & 400 & & \\\hline & \text { McCabe } & 400 & 6000 & \text { programmer } \\\hline 999 & \text { Lopez } & & 9000 & \text { manager } \\\hline\end{array}$

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

-Which of the following statements is true?

A) Row #6 of table Employee violates neither the entity integrity rule nor the referential integrity rule.
B) Row #6 of table Employee violates the entity integrity rule.
C) Row #6 of table Employee violates the referential integrity rule.
D) Row #6 of table Employee violates both the entity integrity rule and the referential integrity rule.

Question 55

A relational algebra operator produces the following result on the table Department: $$\begin{array} { | l | l | l | } \hline \text { Deptno } & \text { Deptname } & \text { Deptcity } \\\hline 100 & \text { Logistics } & \text { Wichita } \\\hline 200 & \text { Finance } & \text { Boise } \\\hline 300 & \text { Marketing } & \text { Pierre } \\\hline\end{array}$$ That operator is:

A) The restrict operator
B) The project operator
C) The extended cross product operator
D) A join operator

Question 56

The Intersection of a table of N rows and of a table of M rows (M<=N)has the following number of rows:

A) M+N
B) A number in the range N to M+N
C) N
D) A number in the range 0 to M

Question 57

The following data are in the tables Employee (primary key: Empno) and Department (primary key: Deptno). The questions refer to row numbers of this table. The first row of each table is row #1. Empdeptno in table Employee is a foreign key that refers to Deptno in the table Department. Deptmgr in the table Department is a foreign key that refers to Empno in the table Employee.
$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptro } & \text { Empsalary } & \text { Emptitle } \\\hline 555 & \text { Keamy } & 200 & 7000 & \text { manager } \\\hline 666 & \text { Williams } & 100 & 8000 & \text { manager } \\\hline 777 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline 888 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline & \text { Johnson } & 300 & 4000 & \text { analyst } \\\hline 889 & \text { Dupont } & 400 & & \\\hline & \text { McCabe } & 400 & 6000 & \text { programmer } \\\hline 999 & \text { Lopez } & & 9000 & \text { manager } \\\hline\end{array}$

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

-The values shown in the table Department:

A) violate neither the entity integrity rule nor the referential integrity rule
B) violate the entity integrity rule
C) violate the referential integrity rule
D) violates both the entity integrity rule and the referential integrity rule

Question 58

The following data are in the tables Employee (primary key: Empno) and Department (primary key: Deptno). The questions refer to row numbers of this table. The first row of each table is row #1. Empdeptno in table Employee is a foreign key that refers to Deptno in the table Department. Deptmgr in the table Department is a foreign key that refers to Empno in the table Employee.
$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptro } & \text { Empsalary } & \text { Emptitle } \\\hline 555 & \text { Keamy } & 200 & 7000 & \text { manager } \\\hline 666 & \text { Williams } & 100 & 8000 & \text { manager } \\\hline 777 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline 888 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline & \text { Johnson } & 300 & 4000 & \text { analyst } \\\hline 889 & \text { Dupont } & 400 & & \\\hline & \text { McCabe } & 400 & 6000 & \text { programmer } \\\hline 999 & \text { Lopez } & & 9000 & \text { manager } \\\hline\end{array}$

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

-Which of the following statements is true?

A) Row #7 of table Employee violates neither the entity integrity rule nor the referential integrity rule.
B) Row #7 of table Employee violates the entity integrity rule.
C) Row #7 of table Employee violates the referential integrity rule.
D) Row #7 of table Employee violates both the entity integrity rule and the referential integrity rule.

Question 59

When the extended cross product operation is performed on a table of N rows and a table of M rows,the resulting table has the following number of rows:

A) M
B) N
C) M*N
D) The larger of M or N

Question 60

In the set-oriented database terminology,a(n)____________ is synonymous with a row.

Question 61

A(n)_________________ is an operator that includes in the result table the matching rows of the input tables and the nonmatching rows from the designated input table.

Question 62

A(n)_________________ is an operator that includes in the result table the matching rows of the input tables and the nonmatching rows from both input tables.

Question 63

A(n)_________________ set operator retrieves all rows in either input table.

Question 64

In relational algebra,the _________________ operator shows everything possible from two tables.

Question 65

The relational algebra operator that produces a subset of the columns of the input table is the _________________ operator.

Question 66

A(n)_________________ set operator retrieves just the common rows of both input tables.

Question 67

The _______________ operator produces a table in which the values of a column from one input table are associated with all the values from a column of a second input table.

Question 68

The relational algebra operator that retrieves a subset of the rows of the input table satisfying a given condition is the _________________ operator.

Question 69

A row in a child table having a foreign key value identical to the primary key value of the parent table is known as a(n)___________________ row.

Question 70

To prohibit actions on referenced rows to occur when a record is deleted,you would specify the clause __________________________ in the CREATE TABLE statement.

Question 71

To cause the same action to be performed on referenced rows when a record is updated,you would specify the clause _________________________ in the CREATE TABLE statement.

Question 72

When the join condition specifies that rows from two or more tables have an identical value in one or more columns,this join is called a(n)_________________ .

Question 73

A(n)_________________ set operator retrieves the rows that occur in the first input table but not in the second input table.

Question 74

The ________________ operator compresses a table by replacing groups of rows with individual rows containing calculated values.

Question 75

Count,min,max,average and sum are all ___________________ functions that can be used to summarize groups of rows of an input table.