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
Ans : C
Explanation: A functional dependency is a relationship between or among Attributes
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
Ans : B
Explanation: Partial functional dependency types is/are not present in the following dependencies.
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
Ans : B
Explanation: The database design prevents some data from being stored due to Insertion anomalies.
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
Ans : D
Explanation: If one attribute is determinant of second, which in turn is determinant of third, then the relation cannot be 3NF.
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
Ans : B
Explanation: OLAP involves frequent insert, update and delete operations statement(s) is/are FALSE about OLAP.
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
Ans : A
Explanation: OLTP the correct processing technique for the given statements.
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
Ans : A
Explanation: OLTP the correct processing technique for the given statements.
8. 5NF is designed to cope with :
A. Transitive dependency
B. Join dependency
C. Multi valued dependency
D. None of these
View Answer
Ans : B
Explanation: 5NF is designed to cope with Join dependency
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
Ans : B
Explanation: Then the decomposition is in 2NF but not in 3NF.
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
Ans : D
Explanation: Third normal form is inadequate in situations where the relation is none of the above relation.
Also check :
Discussion