Database Management Systems (DBMS)
What does Referential integrity refer to?
Difficulty: Medium
About this MCQ
This Medium Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “What does Referential integrity refer to?”
The accepted answer is D. A database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.. A database property ensuring that relationships between tables remain consistent typically enforced through foreign keys is the fact required by What does Referential integrity refer to option D Option A A precompiled collection of SQL statements stored in a database that can be executed as a single unit does not match the stem it is a near-miss used to catch incomplete recall of A database property ensuring that relationships between tables remain consistent typically enforced through foreign keys Option B A type of database that organizes data into tables of rows and columns linked by defined relationships does not match the stem it is a near-miss used to catch incomplete recall of A database property ensuring that relationships between tables.
- A. A precompiled collection of SQL statements stored in a database that can be executed as a single unit.
Why not A: “A precompiled collection of SQL statements stored in a database that can be executed as a single unit.” is not correct. The accepted answer is D. A database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.. A database property ensuring that relationships between tables remain consistent typically enforced through foreign keys is the fact required by What does Referential integrity ref
- B. A type of database that organizes data into tables of rows and columns linked by defined relationships.
Why not B: “A type of database that organizes data into tables of rows and columns linked by defined relationships.” is not correct. The accepted answer is D. A database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.. A database property ensuring that relationships between tables remain consistent typically enforced through foreign keys is the fact required by What does Referential integrity ref
- C. A key formed by combining two or more columns to uniquely identify a row in a table.
Why not C: “A key formed by combining two or more columns to uniquely identify a row in a table.” is not correct. The accepted answer is D. A database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.. A database property ensuring that relationships between tables remain consistent typically enforced through foreign keys is the fact required by What does Referential integrity ref
- D. A database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys. ✓
Correct answer
D. A database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.
Explanation
A database property ensuring that relationships between tables remain consistent typically enforced through foreign keys is the fact required by What does Referential integrity refer to option D Option A A precompiled collection of SQL statements stored in a database that can be executed as a single unit does not match the stem it is a near-miss used to catch incomplete recall of A database property ensuring that relationships between tables remain consistent typically enforced through foreign keys Option B A type of database that organizes data into tables of rows and columns linked by defined relationships does not match the stem it is a near-miss used to catch incomplete recall of A database property ensuring that relationships between tables.
Source: Database Management Systems (DBMS) Official Reference Guide
Tags: computer science, dbms, SQL, databases
Submitted by: MCQsHub Editorial
Related MCQs
- Select the accurate description of Composite key.
- Which of the following best describes Concurrency control?
- The following statement describes a specific concept. What is it called? a key formed by combining two or more...
- Identify the correct concept described as: a large, centralized repository of integrated data from multiple so...
- What is Stored procedure primarily used for?
- Data warehouse is best defined as which of the following?