Relational Database Quiz

What structure is used to store data in a relational database?

• Record

• Chart

• Table

• Report

A primary key must be:

• Optional and non-unique

• Unique and not null

• Always text data type

• Linked to all tables

Which key connects one table to another?

• Composite Key

• Primary Key

• Foreign Key

• Alternate Key

What is a foreign key used for?

• To store index values

• To link two tables

• To delete duplicate rows

• To rename tables

The NULL value in a relational database means:

• A number

• A string

• Unknown or missing value

• Zero

What is a composite key?

• A primary key with one field

• A foreign key

• A key made of multiple fields

• A system-defined key

Which rule ensures every record has a unique identifier?

• Referential Integrity

• Entity Integrity

• View Updating

• Physical Independence

What does referential integrity prevent?

• Updates

• Repeated logins

• Orphan records

• Duplicate fields

In Microsoft Access, which view is used to define relationships?

• Datasheet View

• Form View

• Relationship View

• Layout View

Which Codd rule requires metadata to be stored in tables?

• Rule 12

• Rule 1

• Rule 4

• Rule 6