Question 1

The first commercial RDBMS is:

Accepted Answer

A)  INGRESS
B)  DB2
C)  ORACLE
D)  None of these. A

Question 2

Which of the following can be used to get those items that fall within a range?

Accepted Answer

A)  IN
B)  BETWEEN
C)  DISTINCT
D)  LIKE C

Question 3

Which of the following constitutes a basic set of operations for manipulating relational data?

Accepted Answer

A)  Predicate calculus
B)  Relational algebra
C)  Relational calculus
D)  None of the above B

Question 4

How many tables can be joined to create a view?

Accepted Answer

A)  1
B)  2
C)  Database dependent
D)  None of these

Question 5

Which of the following is not a relational algebraic operation that is developed specifically for the relational databases?

Accepted Answer

A)  SELECT
B)  UNION
C)  JOIN
D)  PROJECT

Question 6

For some relations, changing the data can have undesirable consequences called:

Accepted Answer

A)  referential integrity constraints.
B)  modification anomalies.
C)  normal forms.
D)  transitive dependencies.

Question 7

Which of the following is the result of a select statement?

Accepted Answer

A)  Trigger
B)  Index
C)  Table
D)  None of these

Question 8

The different classes of relations created by the technique for preventing modification anomalies are called:

Accepted Answer

A)  normal forms.
B)  referential integrity constraints.
C)  functional dependencies.
D)  None of the above is correct.

Question 9

One solution to the multivalued dependency constraint problem is to: split the relation into two relations, each with a single theme.

Accepted Answer

A)  change the theme.
B)  create a new theme.
C)  add a composite key.
D)  none

Question 10

The primary key is selected from the:

Accepted Answer

A)  composite keys.
B)  determinants.
C)  candidate keys.
D)  foreign keys.

Question 11

Which of the following is not a relational algebraic operation that is not form the set theory?

Accepted Answer

A)  UNION
B)  INTERSECTION
C)  CARTESIAN PRODUCT
D)  SELECT

Question 12

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

Accepted Answer

A)  transitive dependency.
B)  insertion anomaly.
C)  referential integrity constraint.
D)  normal form.

Question 13

Which of the following operations need the participating relations to be union compatible?

Accepted Answer

A)  UNION
B)  INTERSECTION
C)  DIFFERENCE
D)  All of the above

Question 14

Who developed SEQUEL?

Accepted Answer

A)  Dr. E.F. Codd
B)  Chris Date
C)  Chamberlin

Question 15

What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 20 rows respectively?

Accepted Answer

A)  5
B)  20
C)  25
D)  100

Question 16

What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?

Accepted Answer

A)  5
B)  12
C)  35
D)  None of the above

Question 17

A relation is considered a:

Accepted Answer

A)  Column.
B)  one-dimensional table.
C)  two-dimensional table.
D)  three-dimensional table.

Question 18

Which is the symbol used to denote the SELECT operation?

Accepted Answer

A)  Sigma
B)  Rho
C)  Pi
D)  None of the above

Question 19

Which of the following is not a DCL statement?

Accepted Answer

A)  Rollback
B)  Grant
C)  Revoke
D)  None of these

Question 20

Which of the following is used to get all the columns of a table ?

Accepted Answer

A)  *
B)  @
C)  %
D)  #

Exam 4: Database Management System: Relational Model and Operations