Which rule state that 'no component of a primary key can accept a NULL value'? MCQ with Answer and Explanation

Which rule state that 'no component of a primary key can accept a NULL value'?
A. Referential Integrity Rule
B. Entity Integrity Rule
C. Security Integrity Rule
D. Domain Constraint Rule
Answer: Option B
Solution (By JKSSB Mock Tests)
The Entity Integrity Rule states that a primary key column cannot contain NULL values, ensuring each row can be explicitly identified.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What is the purpose of the SQL 'WITH' clause (Common Table Expression)?
A. To create a view
B. To define a temporary result set that can be referenced within a query
C. To delete data
D. To update data

Correct Answer: Option B


Explanation:
A Common Table Expression (CTE) provides a temporary named result set that can be used within a SELECT, INSERT, UPDATE, or DELETE statement.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is a foreign key in a database table?
A. A key that is always indexed
B. A column that references the primary key of another table
C. A key that allows null values
D. A key used to uniquely identify records in the same table

Correct Answer: Option B


Explanation:
A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between tables.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What does the letter 'D' stand for in the widely accepted ACID properties of database transactions?
A. Dependency
B. Data
C. Definition
D. Durability

Correct Answer: Option D


Explanation:
ACID stands for Atomicity, Consistency, Isolation, and Durability. Durability ensures that once a transaction commits, its changes survive system failures.

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