Database Relationships and Queries Quiz

Which of the following is the main purpose of creating relationships between tables?

• To reduce the number of queries

• To link data from multiple tables correctly

• To remove duplicate data from queries

• To automatically create reports

A primary key is used in a table to:

• Identify a field that can store duplicate values

• Ensure each record is unique

• Create faster queries

• Automatically group data

In the Students table, “ClassNo” is linked to the Classes table. In this case, “ClassNo” in the Students table is called:

• Primary Key

• Foreign Key

• Candidate Key

• Composite Key

Why should you design a database with multiple related tables instead of putting all fields into one large table?

• To save hard drive space

• To improve formatting of reports

• To reduce redundancy and improve accuracy

• To make it easier to sort by Name

If a student is enrolled in multiple subjects, which relationship type should be created between Students and Subjects?

• One-to-One

• One-to-Many

• Many-to-Many

• One-to-All

A simple select query is mainly used to:

• Enter new data

• Delete old data

• Display specific records based on criteria

• Create relationships

Which operator would you use in a query to find students who live in Dallas OR London?

• AND

• OR

• NOT

• BETWEEN

Which operator would you use to find students living in Dallas AND having Postal Code > 12345?

• OR

• NOT

• AND

• LIKE

A parameter query allows the user to:

• Store data permanently

• Enter their own criteria each time the query runs

• Remove duplicates from results

• Create reports automatically

In a parameter query, what will happen if you type [Enter City:] in the City criteria row?

• The database will always show Dallas students

• The user must type a city name before results appear

• The query will not run

• It will display all cities without filtering