What is the concept of referential integrity? MCQ with Answer and Explanation

What is the concept of referential integrity?
A. Ensuring data is normalized
B. Ensuring that all primary keys are unique
C. Ensuring that foreign key values match primary key values in the referenced table
D. Ensuring that no null values exist
Answer: Option C
Solution (By JKSSB Mock Tests)
Referential integrity ensures that relationships between tables remain consistent, meaning foreign key values must have corresponding primary key values.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which SQL component is used to specify a fallback default value for a column when no value is provided during an insert operation?
A. DEFAULT
B. CHECK
C. NOT NULL
D. UNIQUE

Correct Answer: Option A


Explanation:
The DEFAULT constraint assigns a predefined default value to a column when an INSERT statement does not explicitly provide a value for that column.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which constraint ensures that all values in a column are unique?
A. FOREIGN KEY
B. CHECK
C. PRIMARY KEY
D. UNIQUE

Correct Answer: Option D


Explanation:
UNIQUE constraint ensures that all values in a column are distinct, but allows NULL (unless combined with NOT NULL).

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which SQL clause is used to filter groups after grouping?
A. WHERE
B. ORDER BY
C. HAVING
D. GROUP BY

Correct Answer: Option C


Explanation:
HAVING is used to filter groups based on aggregate conditions, applied after GROUP BY.

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