The Relational Database Model Questions

MCQ bookmark_border

21.

The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.

A

Referential relation

B

Referencing relation

C

Referenced relation

D

Referred relation

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

22.

A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

A

Referential

B

Referencing

C

Specific

D

Primary

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

23.

Using which language can a user request information from a database?

A

Query

B

Relational

C

Structural

D

Compiler

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

24.

Student(ID, name, dept name, tot_cred) In this query which attributes form the primary key?

A

Name

B

Dept

C

Tot_cred

D

ID

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

25.

Which one of the following is a procedural language?

A

Domain relational calculus

B

Tuple relational calculus

C

Relational algebra

D

Query language

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

26.

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

A

Select

B

Join

C

Union

D

Intersection

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

27.

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.

A

Join

B

Cartesian product

C

Intersection

D

Set difference

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

28.

The _______operation performs a set union of two

A

Union

B

Join

C

Product

D

Intersect

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

29.

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

A

Join

B

Projection

C

Select

D

Union

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

30.

The _______ operator takes the results of two queries and returns only rows that appear in both result sets.

A

Union

B

Intersect

C

Difference

D

Projection

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion