Which normal form requires that all attributes in a table contain only atomic, indivisible values, and prohibits multi-valued attributes? MCQ with Answer and Explanation

Which normal form requires that all attributes in a table contain only atomic, indivisible values, and prohibits multi-valued attributes?
A. Second Normal Form (2NF)
B. First Normal Form (1NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: Option B
Solution (By JKSSB Mock Tests)
A relation is in First Normal Form (1NF) if and only if the domain of every attribute contains only atomic (indivisible) values, and no repeating groups exist.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which normal form enforces that no non-prime attribute depends on a subset of a candidate key?
A. 3NF
B. 1NF
C. 2NF
D. BCNF

Correct Answer: Option C


Explanation:
2NF eliminates partial dependencies, i.e., non-prime attributes dependent on part of any candidate key.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What type of anomaly occurs when deleting a row inadvertently destroys other independent, valuable historical facts from the database?
A. Projection Anomaly
B. Deletion Anomaly
C. Selection Anomaly
D. Insertion Anomaly

Correct Answer: Option B


Explanation:
A Deletion Anomaly occurs when the deletion of a specific data record unintentionally deletes other distinct, unrelated information that should have been preserved.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is the purpose of the SAVEPOINT statement?
A. To start a new transaction
B. To permanently save changes
C. To create a point within a transaction to which you can later roll back
D. To release locks

Correct Answer: Option C


Explanation:
SAVEPOINT creates a named point within a transaction, allowing partial rollback to that point without affecting the entire transaction.

This question belongs to: Computer Database Management System (DBMS)