JeopardyDB parts sorting More DB Field prop.

MISC.

Q $100

Q $200

Q $300

Q $400

Q $500

Q $100 Q $100Q $100 Q $100

Q $200 Q $200 Q $200 Q $200

Q $300 Q $300 Q $300 Q $300

Q $400 Q $400 Q $400 Q $400

Q $500 Q $500 Q $500 Q $500

Final Jeopardy

$100 Question from DBWhat software application are these examples of in business and society: 1.Phone book2.Online library card 3.Payroll data including employee names, social security numbers, pay rates, exemptions, etc.4.eBay and other online businesses use databases to maintain inventory and keep track of customers, products, vendor, pay pal accounts.

$100 Answer from DB

The answer is B database

$200 Question from DB

In the Doctors Table, Resident is classified as a/an: A. EntryB. FieldC. FileD. Record

$200 Answer from DB

The answer is B Field

$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?

$300 Answer from DB

Bob

$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:

$400 Answer from DB

Filter

$500 Question from DB

all of the information about Pam Pauls is classified as a/an:

$500 Answer from DB

record

$100 Question from SORT

Which operation will result in a list with an exception

$100 Answer from SORT

Filter by exclusion

$200 Question from SORT

Little Jimmy’s class is lining up shortest to tallest, what sort is this

$200 Answer from SORT

Ascending sort

$300 Question from SORT

Some kid’s class is lined up tall to short, what sort is this

$300 Answer from SORT

Descending sort

$400 Question from SORT

John Doe’s class is separated with blue eyed kids lining up first

$400 Answer from SORT

Filter by selection

$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?

$500 Answer from SORT

Filter by selection

$100 Question from MDB

What is an arrangement of columns and rows? It is the fundamental building blocks of database

$100 Answer from MDB

table

$200 Question from MDB

Single piece of data in a database table

$200 Answer from MDB

entry

$300 Question from MDB

What tool is used to organize store and retrieve related information

$300 Answer from MDB

database

$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

$400 Answer from MDB

a

$500 Question from MDB

Orders is classified as a

$500 Answer from MDB

table

$100 Question from FP

Which data type is used for data that may be calculated sorted or filtered

$100 Answer from FP

number

$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?

$200 Answer from FP

currency

$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?

$300 Answer from FP

memo

$400 Question from FP

Shows the date and time information

$400 Answer from FP

Date/time

$500 Question from FP

In an employee directory database, telephone numbers are formatted as:

$500 Answer from FP

text

$100 Question from MIS

Text in the middle is an example of which design principle?

$100 Answer from MIS

repetition

$200 Question from MIS

Black on white font is

$200 Answer from MIS

contrast

$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?

$300 Answer from MIS

=Jeff Gordon

$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?

$400 Answer from MIS

equals

$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?

$500 Answer from MIS

ascending

Final Jeopardy

This is aligning text to the left, middle or right

Final Jeopardy Answer

alignment