In a relational database, what is a 'Foreign Key'?

Answer options:

A key used to encrypt the table.

A field in one table that links to the Primary Key of another table.

A unique identifier for a record.

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

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.

Question 68 All questions Question 70

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...Medium Q02During a review of a client's cloud governance structure, an auditor notes that the client uses a...Medium Q03An auditor is evaluating the 'Processing Integrity' principle for a financial institution's loan ...Hard Q04A company uses a batch processing system to update inventory records overnight. The 'Grandfather-...Hard Q05During a walkthrough of the change management process, an auditor observes that the 'Developer' r...Medium

View all 82 questions →