Jeopardy

1
Jeopardy
MISC.
DB parts
sorting
More DB
Field prop.
Q 100
Q 100
Q 100
Q 100
Q 100
Q 200
Q 200
Q 200
Q 200
Q 200
Q 300
Q 300
Q 300
Q 300
Q 300
Q 400
Q 400
Q 400
Q 400
Q 400
Q 500
Q 500
Q 500
Q 500
Q 500
Final Jeopardy
2
100 Question from DB

• What software application are these examples of
  in business and society
• Phone book
• Online library card
• Payroll data including employee names, social
  security numbers, pay rates, exemptions, etc.
• eBay and other online businesses use databases to
  maintain inventory and keep track of customers,
  products, vendor, pay pal accounts.

3
100 Answer from DB
The answer is B database
4
200 Question from DB
In the Doctors Table, Resident is classified as
a/an A. Entry B. Field C. File D. Record
5
200 Answer from DB
The answer is B Field
6
300 Question from DB
four clients Ben, Bob, Brad, and Blake. Ben has
a Body Mass Index (BMI) of 29, Bob's is 32,
Brad's is 28, and Blake's is 18.
the clients are part of a database that is sorted
in ascending order by BMI, which client will
appear closest to the bottom of the page?
7
300 Answer from DB
Bob
8
400 Question from DB
Dave is searching an online database to find out
how many U.S. presidents were Republicans. He
does not intend to save his search. This search
is an example of a
9
400 Answer from DB
Filter
10
500 Question from DB
all of the information about Pam Pauls is
classified as a/an
11
500 Answer from DB
record
12
100 Question from SORT
Which operation will result in a list with an
exception
13
100 Answer from SORT
Filter by exclusion
14
200 Question from SORT
Little Jimmys class is lining up shortest to
tallest, what sort is this
15
200 Answer from SORT
Ascending sort
16
300 Question from SORT
Some kids class is lined up tall to short, what
sort is this
17
300 Answer from SORT
Descending sort
18
400 Question from SORT
John Does class is separated with blue eyed kids
lining up first
19
400 Answer from SORT
Filter by selection
20
500 Question from SORT
Jim selected "vitamin A" in the Nutrients field
of a foods database to locate only the foods that
contain vitamin A. This is an example of which
operation?
21
500 Answer from SORT
Filter by selection
22
100 Question from MDB
What is an arrangement of columns and rows? It is
the fundamental building blocks of database
23
100 Answer from MDB
table
24
200 Question from MDB
Single piece of data in a database table
25
200 Answer from MDB
entry
26
300 Question from MDB
What tool is used to organize store and retrieve
related information
27
300 Answer from MDB
database
28
400 Question from MDB

• Which is an example of an appropriate field
  name?
• A. First Name
• B. Patient's First Name and ID
• C. Name/Last and First
• D. Patient's First Name and Birthdat

29
400 Answer from MDB
a
30
500 Question from MDB
Orders is classified as a
31
500 Answer from MDB
table
32
100 Question from FP
Which data type is used for data that may be
calculated sorted or filtered
33
100 Answer from FP
number
34
200 Question from FP
How should the Cost field be formatted so that
the Hunt's Real Estate database can be filtered
and sorted according to project expense?
35
200 Answer from FP
currency
36
300 Question from FP
Kate has been asked to keep track of employee
sick days and personal information for the Jones
company. If she also needs a field for
miscellaneous information, such as a note about
an employee, which field type should she use?
37
300 Answer from FP
memo
38
400 Question from FP
Shows the date and time information
39
400 Answer from FP
Date/time
40
500 Question from FP
In an employee directory database, telephone
numbers are formatted as
41
500 Answer from FP
text
42
100 Question from MIS
Text in the middle is an example of which design
principle?
43
100 Answer from MIS
repetition
44
200 Question from MIS
Black on white font is
45
200 Answer from MIS
contrast
46
300 Question from MIS
A database of racing statistics includes the
names of each driver, total wins and losses, and
average speeds. What criterion will produce Jeff
Gordon's total winnings?
47
300 Answer from MIS
Jeff Gordon
48
400 Question from MIS
Angela needs to print a list of customers who do
not have children. The children field is
formatted as yes/no. Which criterion is used?
49
400 Answer from MIS
equals
50
500 Question from MIS
If the cows in Farmer Brown's Barn are part of a
database that is sorted in order by gallons of
milk produced least to most, which sort order is
needed?
51
500 Answer from MIS
ascending
52
Final Jeopardy
This is aligning text to the left, middle or right
53
Final Jeopardy Answer
alignment