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. Security Integrity Rule
C. Domain Constraint Rule
D. Entity Integrity Rule
Answer: Option D
Solution (By JKExamLibrary)
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
Which concept represents a temporary workspace in memory used by database engines to fetch, manipulate, and navigate through query rows one at a time?
A. Cursor
B. View
C. Index
D. Trigger

Correct Answer: Option A


Explanation:
A Cursor is a database control structure that allows an application or script to traverse over the records of a query result set row by row.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which SQL wildcard character is used to match exactly one single character when using the LIKE operator?
A. Question mark (?)
B. Percentage sign (%)
C. Asterisk (*)
D. Underscore (*)

Correct Answer: Option D


Explanation:
In SQL pattern matching with the LIKE operator, the underscore (*) represents exactly one single character, while the percent sign (%) matches zero or more characters.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a valid way to join three tables in SQL?
A. SELECT * FROM table1, table2, table3 WHERE condition1 AND condition2;
B. SELECT * FROM table1 JOIN table2 ON condition1 JOIN table3 ON condition2;
C. Neither
D. Both A and B

Correct Answer: Option D


Explanation:
Both syntaxes are valid: explicit JOIN syntax and implicit comma join with WHERE conditions.

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