When the attribute of one table is used as the key address of another table, this kind of...
IBM aptitude question, verified with a worked answer. Free to practise - no sign-up.
When the attribute of one table is used as the key address of another table, this kind of address/key is called:
Show answer & explanation
A foreign key is an attribute (or set of attributes) in one table that references the primary key of another table, establishing a relationship between them. This is the standard relational database terminology. Primary keys uniquely identify records within a table; candidate keys are alternative keys that could serve as primary keys; and secondary/secondary key is not standard database terminology.
Step-by-step Derivation:
In relational database theory: 1) A Primary Key uniquely identifies each record within its own table. 2) A Foreign Key is a field in one table that refers to the Primary Key in another table, creating referential integrity between tables. 3) The question explicitly states 'attribute of one table is used as the key address of another table'—this describes a foreign key relationship. 4) Option A directly matches this definition. Options B, C, and D refer to keys within or across a single table's context, not inter-table references.