Normalization Questions

MCQ bookmark_border

41.

Which of the normal form is based on multivalued dependencies?

A

First

B

Second

C

Third

D

Fourth

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

42.

Which forms has a relation that possesses data about an individual entity?

A

2NF

B

3NF

C

4NF

D

5NF

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

43.

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

A

A many

B

A multivalued attribute of an entity set

C

A one

D

Both A many

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

44.

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?

A

A many

B

A multivalued attribute of an entity set

C

A one

D

None of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

45.

In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

A

A many

B

A multivalued attribute of an entity set

C

A one

D

None of the mentioned

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

46.

Fifth Normal form is concerned with

A

Functional dependency

B

Multivalued dependency

C

Join dependency

D

Domain

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

47.

In 2NF

A

No functional dependencies

B

No multivalued dependencies

C

No partial FDs exist

D

No partial MVDs exist

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

48.

R design.

A

Database Design Process

B

E

C

Relational scheme

D

Functional dependencies

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

49.

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

A

A many

B

A multivalued attribute of an entity set

C

A one

D

Both A many

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

50.

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.

A

A many

B

A multivalued attribute of an entity set

C

A one

D

All of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion