DBMS Normalization MCQs

Normalization MCQs : This section focuses on "Normalization". These Multiple Choice Questions (mcq) should be practiced to improve the SQL/DBMS skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.

1. A functional dependency is a relationship between or among

A. Entities
B. Rows
C. Attributes
D. Tables

View Answer

2. 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

3. Which functional dependency types is/are not present in the following dependencies?
Empno -> EName, Salary, Deptno, DName
DeptNo -> DName
EmpNo -> DName

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

View Answer

4. 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

5. The database design prevents some data from being stored due to _______.

A. Deletion anomalies
B. Insertion anomalies
C. Update anomalies
D. Selection anomalies

View Answer

6. 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

7. If one attribute is determinant of second, which in turn is determinant of third, then the relation cannot be:

A. Well-structured
B. 1NF
C. 2NF
D. 3NF

View Answer

8. 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

9. Which of the following statement(s) is/are FALSE about OLAP?

A. OLAP involves long running slow transactions that read lot of data
B. OLAP involves frequent insert, update and delete operations
C. OLAP requires data to be in De-Normalized form for optimal processing
D. Both B and C

View Answer

10. 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

11. Choose the correct processing technique for the given statements.
Identify correlation between salary structure and policies sold made by Insurance agents in an organization.

A. OLTP
B. OLAP
C. OLAM
D. None of the above

View Answer

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

A. OLTP
B. OLAP
C. OLAM
D. None of the above

View Answer

13. Choose the correct processing technique for the given statements.
Identify profit trends for different units of organization over years

A. OLTP
B. OLAP
C. OLAM
D. None of the above

View Answer

14.  4NF is designed to cope with :

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

View Answer

15. 5NF is designed to cope with :

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

View Answer

16. 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

17. Consider the schema R(S,T,U,V) and the dependencies S→T, T→U, U→V, V→S. Let R= {R1,R2} such that R1∩R2=Φ. Then the decomposition is :

A. not in 2NF
B. in 2NF but not in 3NF
C. in 3NF but not in 2NF
D. in both 2NF and 3NF

View Answer

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

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

View Answer

19. Third normal form is inadequate in situations where the relation :

A. has multiple candidate keys
B. has candidate keys that are composite
C. has overlapped candidate keys
D. none of the above

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
D. A->BCD

View Answer

---

Also check :

---

Discussion