The Relational Database Model Questions

MCQ bookmark_border

31.

A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.

A

Schema diagram

B

Relational algebra

C

Database diagram

D

Schema flow

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

32.

The _________ provides a set of operations that take one or more relations as input and return a relation as an output.

A

Schematic representation

B

Relational algebra

C

Scheme diagram

D

Relation flow

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

33.

The union operation is represented by

A

?

B

U

D

*

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

34.

The intersection operator is used to get the _____ tuples.

A

Different

B

Common

C

All

D

Repeating

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

35.

The union operation automatically __________ unlike the select clause.

A

Adds tuples

B

Eliminates unique tuples

C

Adds common tuples

D

Eliminates duplicate

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

36.

If we want to retain all duplicates, we must write ________ in place of union.

A

Union all

B

Union some

C

Intersect all

D

Intersect some

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

37.

This query displays

A

Only tuples from second part

B

Only tuples from the first part which has the tuples from second part

C

Tuples from both the parts

D

Tuples from first part which do not have second part

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

38.

The number of attributes in relation is called as its

A

Cardinality

B

Degree

C

Tuples

D

Entity

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

39.

_____ clause is an additional filter that is applied to the result.

A

Select

B

Group-by

C

Having

D

Order by

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

40.

_________ joins are SQL server default

A

Outer

B

Inner

C

Equi

D

None of the mentioned

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion