Question
What is the role of a foreign key in a database management system (DBMS)?

Answer

In a DBMS, a foreign key establishes a relationship between two tables. It references the primary key of another table, enforcing referential integrity. It ensures data consistency by preventing actions that would violate the defined relationships, such as deleting a record referenced by a foreign key constraint.

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free