Databases MCQ with Answers

Databases MCQ with Answers

1) A relation empdt1 is defined with attributes empdt1(empcode, name, street, city, state,pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

Answer is:

2 NF and hence also in 1 NF

Explanation:

.

2) A table has fields F1, F2 , F3 , F4, F5 with the following functional dependencies
Fi —> F3,
F2 —> F4
(FI,F2) —> F5
In terms of normalization, this table is in

Answer is:

1 NF

3) Amongst the ACID properties of a transaction, the 'Durability' property requires. that the changes made to the database by a successful transaction persist

Answer is:

Always, even if there is a failure of any kind

4) In a schema with attributes A, B, C, D and E following set of functional dependencies are given
A --> B
A -->C
CD —>E
B --> D
E—> A
Which of the following functional dependencies is the implied by the above set.

Answer is:

BD --> CD

5) Let R(A, B, C, D) be a relational schema with the following functional dependencies A —> B, B --> C ,

Answer is:

Gives a lossless join, and is dependency preserving.