A table is in Third Normal Form (3NF) if it is in 2NF and has absolutely no non-prime attributes that exhibit what type of dependency? MCQ with Answer and Explanation
A table is in Third Normal Form (3NF) if it is in 2NF and has absolutely no non-prime attributes that exhibit what type of dependency?
A. Transitive Dependency
B. Partial Dependency
C. Trivial Dependency
D. Join Dependency
Answer: Option A
Solution (By JKSSB Mock Tests)
Third Normal Form (3NF) requires a relation to be in 2NF with no transitive dependencies, meaning non-prime attributes cannot be determined by other non-prime attributes.
Explanation:
An Exclusive Lock (X-lock) blocks all other locks, ensuring that only the transaction holding the lock can modify or read the protected resource.
No comments yet. Be the first to start the discussion!