Year 11 data processing quiz

What does a table represent in a relational database?

• A single record

• A collection of attributes

• A set of data organized in rows and columns

• A primary key

What is another name for a record in a relational database?

• Attribute

• Tuple

• Field

• Primary Key

Which of the following is an example of an attribute in a relational database?

• A row in a table

• A column in a table

• A relationship between two tables

• A query result

What does a primary key do?

• Establishes relationships between tables

• Ensures each record is unique

• Allows NULL values

• Helps retrieve data faster

What is the purpose of a foreign key?

• To uniquely identify a record

• To establish relationships between tables

• To allow duplicate values

• To delete tables

Which integrity constraint prevents duplicate primary key values?

• Referential Integrity

• Entity Integrity

• Domain Integrity

• User-Defined Integrity

What type of integrity constraint ensures that a foreign key references a valid primary key?

• Entity Integrity

• Referential Integrity

• Domain Integrity

• User-Defined Integrity

Which integrity constraint ensures that data follows predefined formats?

• Domain Integrity

• Entity Integrity

• Referential Integrity

• User-Defined Integrity

A field that holds only numeric values for age would be an example of:

• Entity Integrity

• Referential Integrity

• Domain Integrity

• User-Defined Integrity

What is the role of User-Defined Integrity?

• It enforces business rules specific to the database

• It ensures foreign key constraints

• It ensures that NULL values are not entered

• It maintains indexes on tables