TomoLink
CompaniesInfosysDatabase ManagementNormalization & Functional Dependencies
DBMS
Normalization & Functional Dependencies

Normalization & Functional Dependencies

dbmsnormalization1nf
1 sections
dbms, normalization

MCQ — Normalization

Q1Easy

1NF (First Normal Form) requires that:

Q2Medium

2NF eliminates:

Q3Medium

3NF eliminates:

Q4Hard

BCNF differs from 3NF in that:

Q5Medium

Which normal form deals with multi-valued dependencies?

Q6Medium

Denormalization is performed primarily to:

Q7Hard

Given R(A, B, C, D) with FDs: A → B, B → C, C → D. The highest normal form satisfied (assuming A is primary key) is:

Q8Medium

A relation with only two attributes is always in:

Q9Medium

Which is NOT an advantage of normalization?

Q10Hard

Closure of a set of attributes {A}+ over FDs {A→B, B→C, AC→D} is:

Dbms Normalization Functional Dependencies | Infosys Dbms | TomoLink