Question

In database systems, the DBMS enforces rules about which data can be waitenis certain columns. The rules are known as Select one:_________.

a. data modification control
b. concurrency control
c. data insertion control
d. referential integrity constraints

Answer 1

The DBMS enforces rules known as referential integrity constraints to maintain data accuracy and consistency in databases, ensuring relationships between tables remain valid.

Step-by-step explanation:

In database systems, the DBMS (Database Management System) enforces rules about which data can be stored in certain columns. These rules are known as referential integrity constraints. Option d, referential integrity constraints, is the correct answer. These constraints are a subset of the broader domain of data integrity rules that ensure the accuracy and consistency of data within a relational database.

Referential integrity constraints ensure that relationships between tables remain consistent. For example, if Table A references a primary key in Table B, then all values of that foreign key in Table A must either match an existing primary key in Table B or be null if the relationship is optional.