Database Management Systems (DBMS)
Which term refers to a database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys?
Difficulty: Medium
About this MCQ
This Medium Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “Which term refers to a database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys?”
The accepted answer is B. Referential integrity. Referential integrity refers to a database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.
- A. NoSQL database
Why not A: “NoSQL database” is not correct. The accepted answer is B. Referential integrity. Referential integrity refers to a database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.
- B. Referential integrity ✓
- C. Composite key
Why not C: “Composite key” is not correct. The accepted answer is B. Referential integrity. Referential integrity refers to a database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.
- D. Third normal form (3NF)
Why not D: “Third normal form (3NF)” is not correct. The accepted answer is B. Referential integrity. Referential integrity refers to a database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.
Correct answer
B. Referential integrity
Explanation
Referential integrity refers to a database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.
Source: Database Management Systems (DBMS) Official Reference Guide
Tags: computer science, dbms, SQL, databases
Submitted by: MCQsHub Editorial
Related MCQs
- The concept in which a subset of SQL commands used to define and modify database structures, such as CREATE an...
- Identify the correct definition of Data Definition Language (DDL).
- What term describes the following? a subset of SQL commands used to manage data within tables, such as INSERT,...
- In computer science, Data Manipulation Language (DML) refers to which of the following?
- Select the correct name for: a subset of SQL primarily represented by the SELECT statement, used to retrieve d...
- Which statement correctly explains Data Query Language (DQL)?