NEW
Font size
S
M
L
XL
Worksheetsdatabase
Total questions: 40
Worksheet time: 10hrs 46mins
Name
Class
Date
1.
James has just inserted his grade for a quiz into a new database table. Which operation has James just performed?
a)
adding a record
b)
Deleting a record
c)
sorting a record
d)
updating the record
2.
Which database component is commonly referred to as a table row within a database
a)
Field
b)
Column
c)
Title
d)
Record
3.
Study this example of a database. Which field uses the Number format?
a)
Name
b)
Age
c)
Favorite Color
d)
Birthdate
4.
Which of the following is used by advertisers to determine the best method to reach their target markets?
a)
Big data
b)
A list of phone numbers to call
c)
Mass mailing
d)
A spreadsheet of customer names
5.
Which statement is true about records when they are deleted from a database table?
a)
Records cannot be deleted from a database table.
b)
Records are removed completely from the table.
c)
Records are hidden within the table.
d)
Records are saved for later use.
6.
Which of the following allows a user to create a table or report based on specific fields within a database?
a)
Table
b)
Field
c)
Query
d)
Record
7.
Which of the following consists of multiple tables of information that are related through common fields?
a)
Text document
b)
Presentation
c)
Relational database
d)
Spreadsheet
8.
Johann is creating a database field which will store descriptive text about products. Which data type should he set for this field?
a)
Numeric
b)
Text
c)
Yes/No
d)
Memo
9.
What kind of data would an art gallery retail store need to store in a database?
a)
Inventory, prices, sales, customer information
b)
Schedules of demonstrations, classes and special events
c)
Marketing flyers, post cards and advertisements
d)
Artist biographies, resumes, and art techniques
10.
Lisa changes her home address in a database field to her new address. This is an example of what type of operation
a)
Deleting a record
b)
Updating a record
c)
Adding a record
d)
Sorting a record
11.
Which type of software is considered the most difficult to learn
a)
Text document software
b)
Database software
c)
Basic image-editing software
d)
Presentation software
12.
Which operation allows you to arrange database records in alphabetical order
a)
Adding
b)
Updating
c)
Sorting
d)
Filtering
13.
Which of the following is an advantage of using databases instead of spreadsheets
a)
Multiple people can use the same database data at a time.
b)
Databases consist simply of worksheets.
c)
Databases are easier to learn than spreadsheets
d)
Only one person can use the same database data at a time.
14.
Which database component is used to organize information by data type?
a)
Row
b)
Title
c)
Field
d)
Record
15.
Study this example of a database. Which field is sorted in numerical order?
a)
id
b)
Zip Code
c)
name
d)
birthdate
16.
Which of the following is used to retrieve specific information from a database?
a)
Keyword
b)
Table
c)
Instance
d)
Query
17.
Study this example of a database. Which database component is shown outlined in red
a)
Record
b)
Heading
c)
Row
d)
Field
18.
Which tool allows a user to store organized information that can easily be accessed, edited and queried?
a)
Database
b)
Calculator
c)
Text document
d)
Pen and paper
19.
Yes/No, Date/Time and Number are examples of:
a)
data types.
b)
tabs you can select.
c)
data queries.
d)
records in a data table.
20.
Study this example of a database. Which database component is shown outlined in red
a)
Record
b)
Column
c)
Field
d)
Heading
21.
Which data type may contain text, numbers and/or certain special characters?
a)
Number
b)
Text
c)
Date/time
d)
Currency
22.
Which term describes a single entry of information of a particular data type in a database table?
a)
Row
b)
Field
c)
Range
d)
Record
23.
Bethany is preparing the data in her database to be used in another program. Which operation is she performing?
a)
Importing
b)
Exporting
c)
Creating
d)
Updating
24.
Which operation will alter the "look and feel" of a report?
a)
Creating a form
b)
Adding a report theme
c)
Inserting a new field
d)
Creating a query
25.
Brian has converted a spreadsheet into a database. Which operation did he perform?
a)
Exporting
b)
Importing
c)
Updating
d)
Creating
26.
Which type of database relationship allows one record in Table A to relate to many matching records in Table B, and many records in Table B to relate to only one matching record in Table A?
a)
One-to-one
b)
Many-to-many
c)
One-to-many
d)
Primary-to-foreign
27.
Which language is used to develop and manage databases?
a)
Java
b)
SQL
c)
HTML
d)
C++
28.
Which query type allows you to retrieve, view and print data?
a)
Action query
b)
Select query
c)
Macro query
d)
Menu query
29.
Jennifer needs to create a presentation that summarizes the data in her database. Which of the following does she need to create?
a)
Query
b)
Report
c)
Field
d)
Record
30.
Study this example of a database. Which database component is shown outlined in red?
a)
Field
b)
Record
c)
Heading
d)
Column
31.
What kinds of data types can be used in relational databases?
a)
Memory
b)
Images
c)
Processes
d)
Queries
32.
Which of the following is a unique identifier that is assigned to a field when a user creates a database table?
a)
Report
b)
Primary key
c)
Query
d)
Foreign key
33.
Which tool allows a user to store organized information that can easily be accessed, edited and queried?
a)
Pen and paper
b)
Database
c)
Calculator
d)
Text document
34.
Yes/No, Date/Time and Number are examples of:
a)
data queries.
b)
data types.
c)
tabs you can select.
d)
records in a data table.
35.
Which database error commonly occurs when a user is creating a database that can result in data errors?
a)
Failing to add a foreign key
b)
Entering the wrong data type in a field
c)
Forgetting to assign each record an ID
d)
Failing to identify a common field
36.
Databases used by organizations such as Google, Amazon, and Facebook are typically referred to as "big data." What does "big data" mean?
a)
Data sets that contain 2 gigabytes of data
b)
Data sets that cannot be stored or processed using traditional database software
c)
Data sets that require multiple tables and records to store all the information
d)
Data sets that contain multiple data types
37.
Daniel works at a hospital. He is creating a database for his patient care department. Which type of information would be included in his database?
a)
Teacher contact numbers
b)
Patient allergy notes
c)
Web page descriptions
d)
Sports game schedules
38.
Brandon is creating a database that includes all of his friends' names, birthdates and ages. Which three data types does Brandon need to use?
a)
Date/Time, Number and Currency
b)
Text, Date/Time and Memo
c)
Text, Date/Time and Number
d)
Text, Currency and Date/Time
39.
Justine was adding data records to her database when she noticed that her brother’s birthdate was listed incorrectly. She immediately corrected the error and saved her database. Which database operation did Justine perform?
a)
Sorting a record
b)
Deleting a record
c)
Updating a record
d)
Adding a record
40.
Spencer has a database of 2000 customers. He needs to print mailing labels. He can get a discount on the postage, if he delivers the labeled mail in an organized way. Which field should he sort his list by, to take advantage of the discount?
a)
Phone number
b)
E-mail address
c)
Zip/postal code
d)
Last name
Reset
