Database Terminology and Concepts Quiz
Authored by Yvonne Lemard
Computers
12th Grade
Used 13+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
