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

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
2

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

2 NF

3 NF

None of these

Answer is:

1 NF

Databases MCQ with Answers

For more MCQ's Click Here

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.

6) Let R(A, B, C, D, E, P, G) be a relational schema in which the following functional dependencies are known to hold:
AB —> CD,
DE —> P,
C --> E,
P --> C and B —> G .
The relational schema R is

In BCNF

in 3NF, but not in BCNF

In 2NF, but not in 3NF

Not in 2NF

Answer is:

Not in 2NF

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

Databases MCQ with Answers

Related Databases MCQ with Answers

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.

6) Let R(A, B, C, D, E, P, G) be a relational schema in which the following functional dependencies are known to hold: AB —> CD, DE —> P, C --> E, P --> C and B —> G . The relational schema R is

Not in 2NF

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.

6) Let R(A, B, C, D, E, P, G) be a relational schema in which the following functional dependencies are known to hold:
AB —> CD,
DE —> P,
C --> E,
P --> C and B —> G .
The relational schema R is