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

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

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

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

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

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

8. 5NF is designed to cope with :

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

View Answer

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

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

---

Also check :

---

Discussion