Which relational database constraint enforces referential integrity by linking a column in one table to the primary key of another table?
Answer and explanation
Correct answer: C. Foreign key constraint
- Step 1: A foreign key ensures that child table records can only reference valid existing records in the parent table. Step 2. It prevents orphaned records and maintains relational consistency across tables. Answer: Foreign key constraint. Why not the others: Check constraint validates value ranges; unique constraint prevents duplicates; not null prevents empty fields.
Practise more Computer Systems, Networking and ICT.
Free questions with an explanation for every one, and full timed Bangladesh Civil Service Preliminary Examination mock tests.
More Computer Systems, Networking and ICT questions
- Which internal CPU register holds the memory address of the next machine instruction to be fetched and executed by the processor?
- Which type of computer memory provides the fastest read and write access times directly to the arithmetic logic unit?
- How many distinct memory addresses can be uniquely referenced by a microprocessor with a 32-bit address bus?
- What is the hexadecimal equivalent of the 8-bit binary number 11011010_2?
- Which logic gate outputs a binary 1 if and only if its two binary inputs are unequal (one is 1 and the other is 0)?
- Which two digital logic gates are considered universal gates because any combinational circuit can be constructed solely using either of the…