DBMS QUIZ

Let R =( A, B, C, D, E, F ) be a relation scheme with the following dependencies:
C→F,

E→A,

EC→D,

A→B.

Which of the following is a key of R?

• CD

• EC

• AE

• AC

Consider a schema R(A,B,C,D) and functional dependencies A->B and C->D
Then the decomposition of R into R1(AB) and R2(CD) is

• dependency preserving and lossless join

• lossless join but not dependency preserving

• dependency preserving but not lossless join

• not dependency preserving and not lossless join

Atomicity of domain of attribute is related to

• 1NF

• 2NF

• 3NF

• 4NF

Which Normal form deals with eliminating partial dependencies ?

• 1NF

• 2NF

• 3NF

• BCNF

What is purpose of normalization in database

• to make retrieval faster

• to make retrieval slower

• To reduce redundancy

• To increase data Duplication

A table is in 2NF if the table is in 1NF and what other condition is met?

• There are no functional dependencies.

• There are no attributes that are not functionally dependent on the relation's primary key.

• There are no null values in primary key fields.

• There are no repeating groups.

• A

• B

• C

• D

A relation R (A, B, C, D, E, F, G, H)and set of functional dependencies are 

CH → G, 

A → BC, 

B → CFH, 

E → A, 

F → EG