Discussion :: DBMS MCQs
- Tables in second normal form (2NF):
A.
Eliminate all hidden dependencies
|
B.
Eliminate the possibility of a insertion anomalies
|
C.
Have a composite key
|
D.
Have all non key fields depend on the whole primary key
|
Answer : Option A
Explanation :
Eliminate all hidden dependencies
The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.
Be The First To Comment