17) Which-one of the following statements about normal forms is FALSE

BCNF is stricter than 3 NF

Lossless, dependency -preserving decomposition into 3 NF is always possible

Loss less, dependency - preserving decomposition into BCNF is always possible

Any relation with two attributes is BCNF

Answer is:

Loss less, dependency - preserving decomposition into BCNF is always possible

Databases MCQ with Answers

For more MCQ's Click Here

19) The following functional dependencies are given:
AB -> CD, AF —> D, DE --> F, C —> G, F —› E, G --> A
Which one of the following options is false?

{CF}+ = {ACDEFG}

{BG}± = {ABCDG}

{AE }+ = {ACDEFG}

{AC = {ACDFG}

Answer is:

{AE }+ = {ACDEFG}

20) Which one of the following statements is FALSE

Any relation with two attributes is in BCNF

A relation in which every key has only one attributes is in 2NF

A prime attribute can be transitively dependent on a key in 3 NF relation

A prime attribute can be transitively dependent on a key in a BCNF relation

Answer is:

A prime attribute can be transitively dependent on a key in a BCNF relation

21) Consider the following relational schemes for a library for a library database:
Book (Title, Author, Catalog_no, Publisher, Year, Price)
Collection (Title, Author, Catalog_no)
Which ofthe following functional dependencies:
I. Title Author —› Catalog no.
II. Catalog_no ---> Title Author Publisher Year
III. Publisher Title Year --> Price.
Assume {Author, Title) is the key for both schemes: Which of the following statements is true?

Both Book and collection are in BCNF

Both Book and collection are in 3NF only

Book is in 2NF and Collection is in 3NF

Both Book and Collection are in 2NF only

Answer is:

Book is in 2NF and Collection is in 3NF

22) Manager's salary details are hidden from the employee. This is

conceptual level data hiding

physical level data hiding

external level data hiding

none of these

Answer is:

conceptual level data hiding

Databases MCQ with Answers

For more MCQ's Click Here

17) Which-one of the following statements about normal forms is FALSE

Loss less, dependency - preserving decomposition into BCNF is always possible

Databases MCQ with Answers

Related Databases MCQ with Answers

19) The following functional dependencies are given: AB -> CD, AF —> D, DE --> F, C —> G, F —› E, G --> A Which one of the following options is false?

{AE }+ = {ACDEFG}

20) Which one of the following statements is FALSE

A prime attribute can be transitively dependent on a key in a BCNF relation

Book is in 2NF and Collection is in 3NF

22) Manager's salary details are hidden from the employee. This is

conceptual level data hiding

Databases MCQ with Answers

19) The following functional dependencies are given:
AB -> CD, AF —> D, DE --> F, C —> G, F —› E, G --> A
Which one of the following options is false?