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
A. | 1 NF only |
B. | 2 NF and hence also in 1 NF |
C. | 3NF and hence also in 2NF and 1NF |
D. | BCNF and hence also in 3NF, 2NF and 1NF |
Option: B Explanation :
empdt1 {empcode, name, street, city, state, pincode) Click on Discuss to view users comments. |
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
A. | 1 NF |
B. | 2 NF |
C. | 3 NF |
D. | None of these |
Option: A Explanation :
Primary key (candidates key) for this relation is [F1] [F2] because [F1, F2] column contains [F1, F2, F3, F4, F5] Click on Discuss to view users comments. |
Amongst the ACID properties of a transaction, the 'Durability' property requires. that the changes made to the database by a successful transaction persist
A. | Except in case of an operating system crash |
B. | Except in case of a disk crash |
C. | Except in case of a power failure |
D. | Always, even if there is a failure of any kind |
Option: D Explanation : Click on Discuss to view users comments. |
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.
A. | CD —> AC |
B. | BD --> CD |
C. | BC —> CD |
D. | AC —> BC |
Option: B Explanation :
CD—>A {CD —>E;E —> A; E —>C} Click on Discuss to view users comments. Naeem Ahmad said: (9:37pm on Thursday 11th June 2015)
This question is no correct. This should be like this..which of the following FDs is not implied by the above set.In this answer will be B.
|
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
A. | In BCNF |
B. | in 3NF, but not in BCNF |
C. | In 2NF, but not in 3NF |
D. | Not in 2NF |
Option: D Explanation : Click on Discuss to view users comments. pushpa said: (6:50am on Saturday 31st March 2018)
bcoz it follows partial dependency,so it is not in 2 NF.
|
Syllabus covered in this section is-
This Section covers Data Warehousing Questions Answers .These questions can be used for the preparation of various competitive and academic exams like
Who can benefit
Various Search Terms used for this section are