The Relational Database Model Questions

MCQ bookmark_border

11.

The natural join is equal to :

A

Cartesian Product

B

Combination of Union and Cartesian product

C

Combination of selection and Cartesian product

D

Combination of projection and Cartesian product

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

12.

Natural join is equal to?

A

Cartesian Product

B

Combination of Union and Cartesian product

C

Combination of selection and Cartesian product

D

Combination of projection and Cartesian product

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

13.

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

A

Candidate key

B

Sub key

C

Super key

D

Foreign key

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

14.

Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

A

NAME

B

ID

C

CITY

D

CITY, ID

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

15.

The subset of a super key is a candidate key under what condition?

A

No proper subset is a super key

B

All subsets are super keys

C

Subset is a super key

D

Each subset is a super key

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

16.

A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

A

Rows

B

Key

C

Attribute

D

Fields

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

17.

Which one of the following attribute can be taken as a primary key?

A

Name

B

Street

C

Id

D

Department

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

18.

Which one of the following cannot be taken as a primary key?

A

Id

B

Register number

C

Dept_id

D

Street

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

19.

An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.

A

Candidate

B

Primary

C

Super

D

Sub

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

20.

The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called

A

Referential relation

B

Referencing relation

C

Referenced relation

D

Referred relation

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion