The Relational Database Model Questions

MCQ bookmark_border

41.

The _____________ is essentially used to search for patterns in target string.

A

Like Predicate

B

Null Predicate

C

In Predicate

D

Out Predicate

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

42.

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

A

Relational

B

Structural

C

Procedural

D

Fundamental

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

43.

Which of the following is a fundamental operation in relational algebra?

A

Set intersection

B

Natural join

C

Assignment

D

None of the mentioned

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

44.

Which of the following is used to denote the selection operation in relational algebra?

A

Pi (GREEK)

B

Sigma (GREEK)

C

Lambda (GREEK)

D

Omega (GREEK)

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

45.

For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.

A

Predicates, relation

B

Relation, Predicates

C

Operation, Predicates

D

Relation, Operation

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

46.

The ___________ operation, denoted by -, allows us to find tuples that are in one relation but are not in another.

A

Union

B

Set difference

C

Difference

D

Intersection

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

47.

Which is a unary operation:

A

Selection operation

B

Primitive operation

C

Projection operation

D

Generalized selection

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

48.

Which is a join condition contains an equality operator:

A

Equijoins

B

Cartesian

C

Natural

D

Left

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

49.

In precedence of set operators, the expression is evaluated from

A

Left to left

B

Left to right

C

Right to left

D

From user specification

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

50.

Which of the following is not outer join?

A

Left outer join

B

Right outer join

C

Full outer join

D

All of the mentioned

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion