Databases MCQ with Answers

Databases MCQ with Answers

72) An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true

Answer is:

A is not a candidate key

73) Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,then the maximum size of join is:

Answer is:

mn

74) The natural join is equal to :

Answer is:

Combination of selection and Cartesian product

75) Which one of the following is not true for a view:

Answer is:

A view definition is permanently stored as part of the database.

76) A primary key if combined with a foreign key creates

Answer is:

Parent-Child relationship between the tables that connect them.

12
13
14
15
16
17
18