To be in Second Normal Form (2NF), a relation must already satisfy First Normal Form (1NF) and must completely eliminate what type of dependency? MCQ with Answer and Explanation
To be in Second Normal Form (2NF), a relation must already satisfy First Normal Form (1NF) and must completely eliminate what type of dependency?
A. Transitive Dependency
B. Functional Dependency
C. Multivalued Dependency
D. Partial Dependency
Answer: Option D
Solution (By JKSSB Mock Tests)
Second Normal Form (2NF) requires that the table is in 1NF and that no non-prime attribute is partially dependent on any candidate key (meaning no partial dependency exists).
Explanation:
The EXISTS operator is used to test for the presence of any records in a subquery, returning TRUE as soon as a single matching row is encountered.
Explanation:
Isolation ensures that the execution of concurrent transactions does not interfere with one another, making them appear as if they are executing sequentially.
No comments yet. Be the first to start the discussion!