www.ThinkITI.com

Home
MCQ
Search
Free Apps
Important
Study Groups
Contact Us
Policy

Home
MCQ
Objective Questions
Engineering
Computer Science
Computer Science Set-1
Databases
1

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

1 NF only

2 NF and hence also in 1 NF

3NF and hence also in 2NF and 1NF

BCNF and hence also in 3NF, 2NF and 1NF

Answer is:

2 NF and hence also in 1 NF

Explanation:

Databases MCQ with Answers

For more MCQ's Click Here

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

1 NF

2 NF

3 NF

None of these

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

Except in case of an operating system crash

Except in case of a disk crash

Except in case of a power failure

Always, even if there is a failure of any kind

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.

CD —> AC

BD --> CD

BC —> CD

AC —> BC

Answer is:

BD --> CD

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

Gives a lossless join, and is dependency preserving.

Gives a lossless join, but is not dependency preserving

Does not give a loss less join, but is depency preserving

Does not give a lossless join and is not depency preserving

Answer is:

Gives a lossless join, and is dependency preserving.

Databases MCQ with Answers

For more MCQ's Click Here

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

2 NF and hence also in 1 NF

Databases MCQ with Answers

Related Databases MCQ with Answers

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

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

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.

BD --> CD

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

Gives a lossless join, and is dependency preserving.

Databases MCQ with Answers

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

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.