NEW
Font size
S
M
L
XL
Worksheetsstudy guide for data base certification
Total questions: 31
Worksheet time: 16mins
Name
Class
Date
1.
Question 1 Which tool allows a user to store organized information that can easily be accessed, edited and queried?
a)
database
b)
spreadsheet
c)
exel
d)
onenote
2.
Question 2 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 contacts
b)
pacient allergy notes
c)
his lunch
d)
his dinner
3.
Question 3 Which operation allows you to arrange database records in alphabetical order?
a)
sorting
b)
order
c)
aphabet order
d)
none of the above
4.
Which database component is commonly referred to as a table row within a database?TitleRecordFieldColumn
a)
title
b)
record
c)
field
d)
column
5.
Question 5 Lisa changes her home address in a database field to her new address. This is an example of what type of operation?
a)
creating a record
b)
updating a record
c)
deleting a record
d)
adding a record
6.
question 6 Which of the following is used by advertisers to determine the best method to reach their target markets?
a)
mass mailing
b)
email
c)
big data
d)
flyers
7.
Question 7 Which of the following is an advantage of using databases instead of spreadsheets?
a)
mutiplal pepole can use it at the same time
b)
none of the above
c)
one person can use it at a time
d)
two pepole can use at the same time
8.
Question 8 Which type of software is considered the most difficult to learn?
a)
data base
b)
spread sheet
c)
exel
9.
Question 9 Which of the following allows a user to create a table based on specific fields within a database?
a)
primary key
b)
forien key
c)
query
d)
none of the above
10.
Question 10 Which of the following consists of multiple tables of information that are related through common fields?
a)
age
b)
height
c)
realational databases
d)
all of the above
11.
Question 12 Which of the following is used by advertisers to determine the best method to reach their target markets?
a)
mass mailing
b)
big data
c)
email
d)
ads
12.
Question 13 Which statement is true about records when they are deleted from a database table?
a)
they are deleted complety from the table
b)
they are kept for later use
c)
they are just cut and put it to the deleted table
d)
none of the above
13.
Question 15 Miranda is creating a database field that has money values. Which data type should she set for this field?
a)
currency
b)
numbers
c)
date and time
d)
general
14.
Question 16 Which database component is used to organize information by data type?
a)
sorting
b)
feild
c)
all of them
d)
none of them
15.
Question 17 James has just inserted his grade for a quiz into a new database table. Which operation has James just performed?
a)
updating a record
b)
deleting a record
c)
editing a record
d)
adding a record
16.
Question 18 Which database component is commonly referred to as a table row within a database?
a)
row
b)
height
c)
record
17.
Question 19 Which of the following is used to retrieve specific information from a database?
a)
query
b)
pirmary key
c)
forigen key
18.
Question 20 Yes/No, Date/Time and Number are examples of:
a)
date and time
b)
text
c)
currency
d)
genreal
19.
You are helping a friend build a query for his database. His database has five tables and no table relationships exist. You add three tables to the query. Before you can proceed with selecting fields for the query, which task must you complete?
a)
inserting a pirmay key
b)
creating a table join
c)
inserting a forien key
20.
Your team is complaining about entering data into your table using the Datasheet view. They are asking your help to make data entry easier. Which database component can you use to help your team with data entry?
a)
table
b)
form
c)
query
d)
pimary key
21.
There are two tables in your database: Students and Identification Resources. Each student only has one identification resource and only one identification resource can be associated with each student. What is unique about the relationship between these two tables?
a)
The relationship is created only by the database administrator.
b)
The relationship is created only if both of the related fields are primary keys.
22.
Albert is preparing for his fundraiser event. He has kept track of his invitations, responses and meal selections in a database. To make it easier for the wait staff, Albert wants to generate a report that contains only the name of an attendee and the meal selected. Ideally, he wants to transfer this information onto a small place card. What report option should Albert select?
a)
report wizard
b)
lables
c)
query wizard
23.
Your local bank uses a complex database management system to keep track of all its clients, their accounts and daily transactions. If you were an analyst working for the bank, what application would you use to question the bank’s database about the transactions made by one client in New Jersey?
a)
access
b)
my sql
c)
exel
d)
none of the above
24.
Abigail has received a request from her partner, Ernest, to share her sales results from the past three years with him. Ernest will be analyzing her information to help Abigail set her sales goals for next year. Ernest would like the sales data to be in a spreadsheet format. What option should Abigail select from the Export – Excel Spreadsheet Wizard to keep her sales data formatting intact?
a)
Open the destination file after the export operation is complete.
b)
Export data with formatting and layout.
c)
only eport the data
d)
only export the spreat sheets
25.
You are using two tables in your query: Customers and Orders. You want to view all of the orders each customer has placed. You must include the Customer ID field to display your information correctly. From which source should the Customer ID field be added to your query
a)
Added from the Orders
b)
: Added from the Customers table
c)
none
d)
all
26.
Entering data into a database can be a daunting task if related data needs to be entered into a multiple tables at the same time. What database components can be customized to make the data entry easier?
a)
reports
b)
queris
c)
forms
d)
exel
27.
2 Jennifer needs to create a presentation that summarizes the data in her database. Which of the following does she need to create?
a)
report
b)
query
c)
table
28.
Bethany is preparing the data in her database to be used in another program. Which operation is she performing?
a)
exporting
b)
importing
c)
adding a record
d)
deleting a record
29.
Which of the following is a unique identifier that is assigned to a field when a user creates a database table?
a)
pimary key
b)
forigen key
c)
report
d)
query
30.
Which operation will alter the "look and feel" of a report?
a)
adding a report theme
b)
puting a picture
c)
color it
31.
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 cannot be stored or processed using traditional database software
b)
data sets that only contain spread sheets
Reset
