Database Terminology and Concepts Quiz

What is the purpose of a database management system?

• To make it possible to store and retrieve information efficiently

• To create and design a table to your specifications

• To automate a repetitive series of commands

• To view and modify the data in a row-and-column format

What is the function of a foreign key in a database table?

• To establish a relationship between specific records in two tables

• To display a header at the top of every page

• To store a collection of information about a specific database topic

• To prevent rounding off during calculations

What is a relational database?

• To store information in one table

• One that maintains and analyses complex information stored in a spreadsheet

• One that stores data in linked tables

• To create and design a form to your specifications

What is the maximum number of characters that can be stored in a Text field?

• 255 characters

• 50 characters

• 1 byte of disk space

• 65,536 characters

What is the purpose of the AutoNumber data type in Microsoft Access?

• To prevent rounding off during calculations

• To establish a relationship between specific records in two tables

• To create fields that automatically enter a unique number when a record is added

• To store numeric data to be used for mathematical calculations

What is the purpose of the Form View in Microsoft Access?

• To create and design a Google form to your specifications

• To create and design a report to your specifications

• To modify and view data in the fields of the form

• To view and modify the data in a row-and-column format

What is the purpose of a primary key in a database table?

• To uniquely identify each record in the table

• To display a header at the top of every page

• To store a collection of information about a specific database topic

• To prevent rounding off during calculations

The secondary keys are good enough to be primary keys themselves

• true

• false

What is a database

• a set of file folders

• the information stored in a spreadsheet

• A collection of organised and structured data

• MS Access

What is a record?

• one piece of data about the entity

• organised music for sale

• making a list of what was done

• a set of fields that together describe one entity