Discussion :: Oracle Database MCQs
- A table is in 3NF if it is in 2NF and if it has no ____________
|
A.
Functional Dependencies
|
|
B.
Transitive Dependencies
|
|
C.
Trivial Functional Dependency
|
|
D.
Multivalued Dependencies
|
Whatsapp
Facebook
Answer : Option B
Explanation :
For a relation to be in Third Normal Form, it must be in Second Normal form and the following must satisfy:No non-prime attribute is transitively dependent on prime key attribute For any non-trivial functional dependency, X - A, then eitherX is a superkey or,A is prime attribute.
Be The First To Comment