Referential integrity constraints are implemented in SQL using the ________ syntax.
A)PRIMARY KEY
B)FOREIGN KEY
C)DEFAULT
D)UNIQUE

Question

Quizplus · Accepted Answer

Referential integrity constraints are implemented using foreign keys in SQL. When a foreign key is created, it references the primary key of another table, ensuring that any data inserted into the referencing table matches the data in the referenced table. This maintains data consistency and prevents data inconsistencies or errors. Primary keys, unique constraints, and default values are also used in SQL, but they do not specifically enforce referential integrity constraints.

Referential Integrity Constraints Are Implemented in SQL Using the ________