Normalization Questions

MCQ bookmark_border

21.

Which of the following is not Armstrong?s Axiom?

A

Reflexivity rule

B

Transitivity rule

C

Pseudotransitivity rule

D

Augmentation rule

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

22.

This type of decomposition is called

A

Lossless decomposition

B

Lossless

C

All of the mentioned

D

None of the mentioned

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

23.

This comes under

A

Lossy

B

Lossy decomposition

C

Lossless

D

Both Lossy and Lossy

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

24.

>B This can be combined as

A

A

B

A

C

B

D

None of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

25.

a)

A

2

B

7

C

10

D

12

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

26.

Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID?s?

A

Both I and II

B

I only

C

II only

D

Neither I nor I

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

27.

Which of the following is not a key?

A

A

B

E

C

B, C

D

D

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

28.

A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.

A

2NF

B

3NF

C

BCNF

D

1NF

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

29.

What are the desirable properties of a decomposition

A

Partition constraint

B

Dependency preservation

C

Redundancy

D

Security

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

30.

R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?

A

A

B

A

C

AB

D

A

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion