Free Printable DBMS Module 3 - Relational Model

1.

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

2.

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

a)

UNION

b)

INTERSECTION

c)

CARTESIAN PRODUCT

d)

SELECT

3.

Which is the symbol used to denote the SELECT operation ?

a)

Sigma

b)

Rho

c)

Pi

d)

None of the above

4.

Which is the symbol used to denote the PROJECT operation ?

a)

Sigma

b)

Rho

c)

Pi

d)

None of the above

5.

Which is the symbol used to denote the RENAME operation ?

a)

Sigma

b)

Rho

c)

Pi

d)

None of the above

6.

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

a)

Union

b)

Intersection

c)

Difference

d)

All of the above

7.

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

a)

5

b)

20

c)

25

d)

100

8.

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

a)

5

b)

12

c)

35

d)

None of the above

9.

Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table ?

a)

SELECT

b)

PROJECT

c)

UNION

d)

JOIN

10.

Which of the following is true ?

a)

$A\ \cup\ B\ \ne\ B\ \cup\ A$

b)

$A\ \cap\left(\ B\ \cap\ C\ \ \right)\ \ \ \ne\ \left(A\ \cap\ B\right)\ \cap\ \ C$

c)

$A\ -\ B\ \ne\ B\ -\ A\$

d)

None of the above

11.

If two relations have 5 and 10 tuples respectively, then what will be the number of tuples in the CARTESIAN PRODUCT ?

a)

5

b)

10

c)

15

d)

50

12.

Which of the following is the symbol used to represent the CARTESIAN PRODUCT ?

a)

X

b)

U

c)

-

d)

x

DBMS Module 3 - Relational Model

Total questions: 12

Worksheet time: 9mins

Similar Resources on Wayground