SQL MCQ - Normalization

11. Consider a relation R(A, B, C, D) with the following functional dependencies:
A -> (B, C, D), (A, D) -> (B, C) and (C, D) -> (A, B). Identify the candidate key(s).

A. {A}
B. {A}, {C, D}
C. {A}, {C, D}, {A, D}
D. {C, D}

View Answer

12. Which functional dependency types is/are not present in following dependencies?
StaffNo, BranchNo -> StaffName, BranchName, Position, DOB
StaffNo -> StaffName, Position, DOB
BranchNo -> BranchName

A. Full functional dependency
B. Partial functional dependency
C. Transitive functional dependency
D. Both B and C

View Answer

13. A relation is in 2NF if:

A. All the values of non-key attributes are dependent fully on the candidate key.
B. Any non-key attribute that are dependent on only part of the candidate key should be moved to another relation where the partial key is the actual full key.
C. It must be already in the 1NF.
D. All of the above.

View Answer

14. Consider the relation Sale(Date, Customer, Product, Vendor, VendorCity, SalesRep)
{Date, Customer, Product} is the composite candidate key and the following functional dependencies are also given:
Vendor -> VendorCity, Product -> Vendor
What is the highest normal form of the sale relation?

A. 0NF
B. 1NF
C. 2NF
D. 3NF

View Answer

15. Which of the following statement(s) is/are true about OLAP?

A. OLAP involves long running slow transactions that read lot of data
B. OLAP requires complex joins to aggregate data from multiple tables
C. OLAP requires data to be in De-Normalized form for optimal processing
D. Both A and C

View Answer

16. Choose the correct processing technique for the given statements.
Update project details of an employee

D. None of the above

View Answer

17.  4NF is designed to cope with :

A. Transitive dependency
B. Join dependency
C. Multi valued dependency
D. None of these

View Answer

18. A BCNF is :

A. loss less join and dependency preserving
B. loss less join but not dependency preserving
C. not loss less join but dependency preserving
D. None of these

View Answer

19.  Third normal form is based on the concept of _________

A. Closure Dependency
B. Transitive Dependency
C. Normal Dependency
D. Functional Dependency

View Answer

20. R(A,B,C,D) is a relation, Which of the following does not have a lossless join dependency preserving BCNF decomposition

A. A->B, B->CD
B. A->B, B->C,C->D
C. AB->C, C->AD

View Answer

Also check :


* You must be logged in to add comment.