Deck 4: Database Management System: Relational Model and Operations

Question 1

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

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

Answer 1

normal forms.

Question 2

The primary key is selected from the:

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

Answer 2

candidate keys.

Question 3

In the relational model, relationships between relations or tables are created by using:

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

Answer 3

foreign keys.

Question 4

A relation is considered a:

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

Question 5

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

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

Question 6

If attribute A determines both attributes B and C, then it is also true that:

A)A ? B.
B)B ? A.
C)C ? A.
D)(B,C) ? A.

Question 7

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

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

Question 8

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):

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

Question 9

Who developed SEQUEL?

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

Question 10

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

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

Question 11

The first commercial RDBMS is:

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

Question 12

Which of the following is not a DCL statement?

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

Question 13

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

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

Question 14

Which of the following clause specifies the table or tables from where the data has to be retrieved?

A)Where
B)Table
C)From
D)None of these

Question 15

How many tables can be joined to create a view?

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

Question 16

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

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

Question 17

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

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

Question 18

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

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

Question 19

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

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

Question 20

Which is the symbol used to denote the SELECT operation?

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

Question 21

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

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

Question 22

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

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

Question 23

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

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