The Relational Database Model Questions

MCQ bookmark_border

1.

Relational calculus is a

A

Procedural language.

B

Non- Procedural language.

C

Data definition language.

D

High level language.

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

2.

Cartesian product in relational algebra is

A

a Unary operator.

B

a Binary operator.

C

a Ternary operator.

D

not defined.

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

3.

In a relational model, relations are termed as

A

Tuples

B

Attributes

C

Tables

D

Rows

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

4.

An entity set that does not have sufficient attributes to form a primary key is a

A

strong entity set.

B

weak entity set.

C

simple entity set.

D

primary entity set.

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

5.

A relational database developer refers to a record as

A

a criteria.

B

a relation.

C

a tuple.

D

an attribute.

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

6.

The relational model feature is that there

A

is no need for primary key data.

B

is much more data independence than some other database models.

C

are explicit relationships among records.

D

are tables with many dimensions.

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

7.

Relational Algebra is

A

Data Definition Language .

B

Meta Language

C

Procedural query Language

D

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

8.

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

A

PROJECTION

B

SELECTION

C

UNION

D

JOIN

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

9.

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

A

UNION

B

INTERSECTION

C

DIFFERENCEqq

D

All of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

10.

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

A

Predicate calculus

B

Relational calculus

C

Relational algebra

D

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion