Testout ITF Chapter 7

What is a primary key?

• A row in a database
• A column in a database
• A raw figure
• A unique field

What is a relationship?

• Two relational databases share a field
• When a database has two matching primary keys
• When two people have the same surname
• When two or more people have the same surname

What do relational databases tend to have in common?

• Primary keys
• Records
• Fields
• Indexes

How many records are in this database?

• 8
• 5
• 10
• 12

Which of these is an advantage of relational databases?

• Only relevant data is displayed
• It is cheaper
• It is faster
• Data may be displayed multiple times so it is harder to miss

What is the primary key in this database?

• Emp_Id
• Last Name
• Gender
• Title

Which is the best description of a database?

• Stores data

• Stores data in a organised structure

• Stores data in an organised and logical structure

A collection of fields and records in a specific category

• Record

• Table

• Field

In a database about school form groups, you would need to create a different _____ for each year group

• Table

• Record

• Field

Rows in a database tables are called...

• Fields

• Records

• Tables