Normalization Questions

MCQ bookmark_border

31.

Consider the above conditions. Which of the following relation holds?

A

Course id

B

Title

C

Dept name

D

Cannot be determined

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

32.

The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is

A

BCNF algorithm

B

2NF algorithm

C

3NF synthesis algorithm

D

1NF algorithm

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

33.

The functional dependency can be tested easily on the materialized view, using the constraints ____________.

A

Primary key

B

Null

C

Unique

D

Both Null and Unique

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

34.

Which normal form is considered adequate for normal relational database design?

A

2NF

B

5NF

C

4NF

D

3NF

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

35.

Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

A

Zero

B

More than zero but less than that of an equivalent 3NF decomposition

C

Proportional to the size of F+

D

Indeterminate

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

36.

in terms of normalization, this table is in

A

1NF

B

2NF

C

3NF

D

None of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

37.

The relation schema R is

A

in BCNF

B

in 3NF, but not in BCNF

C

in 2NF, but not in 3NF

D

not in 2NF

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

38.

The normal form which satisfies multivalued dependencies and which is in BCNF is

A

4 NF

B

3 NF

C

2 NF

D

All of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

39.

generating dependencies?

A

Functional dependency

B

Equality

C

Multivalued dependencies

D

Non

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

40.

The main task carried out in the __________ is to remove repeating attributes to separate tables.

A

First Normal Form

B

Second Normal Form

C

Third Normal Form

D

Fourth Normal Form

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion