www.McqFinder.in

Home
MCQ
Search
Free Apps
Important
Study Groups
Contact Us
Policy

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

Databases MCQ with Answers

Databases MCQ with Answers

For more MCQ's Click Here

Related 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:

.

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

Databases MCQ with Answers

For more MCQ's Click Here