Which of the following statements does not apply to relational databases?

A)

Relational databases are simple to understand

B)

Tables are one of the basic components of relational databases

C)

Relational databases have a strong procedural orientation

D)

Relational databases have a strong mathematical foundation

2

In the relational database terminology, a table is synonymous with:

A)

A column

B)

A row

C)

An attribute

D)

A relation

3

A null value indicates:

A)

A numeric value with value 0

B)

The absence of a value

C)

A very small value

D)

An erroneous value

4

When the referential integrity rule is enforced, which one is usually not a valid action in response to the deletion of a row that contains a primary key value referenced elsewhere?

A)

Do not allow the deletion

B)

Accept the deletion without any other action

C)

Delete the related rows

D)

Set the foreign keys of related rows to null

5

A relational algebra operator applied to tables Ex and Dx produces the following result: (21.0K)

That operator is:

A)

An outer join operator

B)

The project operator

C)

The extended cross product operator

D)

The natural join operator

6

A relational algebra operator applied to tables Dx and Ex produces the following result: (10.0K)

That operator is:

A)

An outer join operator

B)

The project operator

C)

The extended cross product operator

D)

The natural join operator

7

A relational algebra operator applied to tables Dx and Ex produces the following result: (12.0K)

That operator is:

A)

An outer join operator

B)

The project operator

C)

The extended cross product operator

D)

The natural join operator

8

When an equi-join 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)

The smaller of M or N

D)

A number in the range 0 to M*N

9

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

10

The following pair of tables is union compatible:

A)

Dept1, Dept4

B)

Dept1, Dept3

C)

Dept3, Dept4

D)

All of the above

To learn more about the book this website supports, please visit its Information Center.