Study for the CompTIA ITF+ Exam. Enhance your tech literacy with multiple-choice questions and detailed explanations. Prepare thoroughly and succeed!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.


Which value uniquely identifies a database record?

  1. Foreign key

  2. Index

  3. Primary key

  4. Trigger

The correct answer is: Primary key

A foreign key is used to establish a link between records in two tables. An index is a data structure used to optimize data retrieval. A trigger is a special type of stored procedure that is executed when a specific event occurs. A primary key is a unique identifier for a record in a database table, and it is used to ensure that each record is uniquely identified. Unlike a foreign key, which can be shared between multiple records, a primary key can only belong to one record in the table. This makes it the best option for uniquely identifying a database record.