NEW
Font size
WorksheetsDatabases - 1.2 Primary Key
Total questions: 7
Worksheet time: 4mins
What is a primary key?
A unique identifier for each record in a table that cannot contain NULL values.
A duplicate identifier for records in a table.
A foreign key in a table.
A non-unique identifier for records in a table.
What is a composite key?
A composite key is a primary key made up of two or more columns to uniquely identify a record.
A composite key is a single column used to uniquely identify a record.
A composite key is a foreign key used to link two tables.
A composite key is a unique constraint on a single column.
A primary key column can contain duplicate values because:
It is allowed by database design.
It ensures data integrity.
It uniquely identifies each record.
It can have null values.
Activity Question: Given a "Library" table with columns BookID, Title, and AuthorID, which column(s) would be the most appropriate primary key?
BookID
Title
AuthorID
Title and AuthorID
Which is the best example of a primary key?
Driver's License Number
Home Runs Hit
Price
First and Last Name
Which of the following is a method to enforce data integrity in Access?
Using primary keys
Using foreign keys
Using validation rules
All of the above
In Access, what does the term "referential integrity" refer to?
Ensuring that all data is encrypted
Ensuring that relationships between tables remain consistent
Ensuring that all tables have a primary key
Ensuring that all queries run efficiently
