71) Cross Product is a:

Unary Operator

Ternary Operator

Binary Operator

Not an operator

Answer is:

Binary Operator

Databases MCQ with Answers

For more MCQ's Click Here

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:

m+n

(m+n)/2

2(m+n)

Answer is:

mn

74) The natural join is equal to :

Cartesian Product

Combination of Union and Cartesian product

Combination of selection and Cartesian product

Combination of projection and Cartesian product

Answer is:

Combination of selection and Cartesian product

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

View is derived from other tables.

View is a virtual table.

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

View never contains derived columns.

Answer is:

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

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

Parent-Child relationship between the tables that connect them.

Many to many relationship between the tables that connect them.

Network model between the tables that connect them.

None of the above.

Answer is:

Parent-Child relationship between the tables that connect them.

Databases MCQ with Answers

For more MCQ's Click Here

71) Cross Product is a:

Binary Operator

Databases MCQ with Answers

Related Databases MCQ with Answers

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:

mn

74) The natural join is equal to :

Combination of selection and Cartesian product

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

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

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

Parent-Child relationship between the tables that connect them.

Databases MCQ with Answers