ExpertMedium1 markMultiple Choice
CPA · Question 69 · Area I: Information Systems
In a relational database, what is a 'Foreign Key'?
In a relational database, what is a 'Foreign Key'?
Answer options:
A.
A key used to encrypt the table.
B.
A field in one table that links to the Primary Key of another table.
C.
A unique identifier for a record.
D.
A password to access the database.
How to approach this question
Foreign Key = Link to another table.
Full Answer
B.A field in one table that links to the Primary Key of another table.✓ Correct
B
A Foreign Key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table.
Common mistakes
Confusing Foreign Key with Primary Key.
Practice the full CPA ISC Practice Exam 3
82 questions · hints · full answers · grading
More questions from this exam
Q01A CPA is advising a client who is migrating their legacy on-premise ERP system to a cloud-based s...MediumQ02During a review of a client's cloud governance structure, an auditor notes that the client uses a...MediumQ03An auditor is evaluating the 'Processing Integrity' principle for a financial institution's loan ...HardQ04A company uses a batch processing system to update inventory records overnight. The 'Grandfather-...HardQ05During a walkthrough of the change management process, an auditor observes that the 'Developer' r...Medium