Nt1330 Unit 4

Mrs. Bills needs to get an alphabetical list of students who have sold 100 lollipops. Which

criterion is used? (NCCTE.9_12.BE.6411.PP105.01)

a) And

b) Equals

c) Not

d) Or

2. Chad wants to print a list of seniors who are going to any college except East Carolina

University when they graduate. Which criterion is used? (NCCTE.9_12.BE.6411.PP105.01)

a) And

b) Equals

c) Not

d) Or

3. Sally wants to print a list of foods that have 100 calories, zero grams of fat, and 2 grams of

fiber per serving. Which criterion will she use? (NCCTE.9_12.BE.6411.PP105.01)

a) Equals

b) Greater than

c) Less than

d) Or

4. Lynn is adding a billing table to a customer database. If she wants the database to retrieve

client names and account numbers, which data
He does not intend to save his search. This search is an example of a:

(NCCTE.9_12.BE.6411.PP105.02)

a) filter.

b) form.

c) query.

d) report.

27. Dave is a salesman at CarMax. He searched the CarMax database for BMWs and printed

a list of available cars for a client. This search is an example of a:

(NCCTE.9_12.BE.6411.PP105.02)

a) filter.

b) form.

c) query.

d) report.

28. Dino is searching the online Headhunter database for job postings. He prints out the job

listings for all chef positions in the Chicago area. This search is an example of a:

(NCCTE.9_12.BE.6411.PP105.02)

a) filter.

b) form.

c) query.

d) report.

29. Dottie gave her students a test about database concepts and functions. She arranges the

database of student grades so that only students who made an 85 or higher are displayed.

This is an example of a: (NCCTE.9_12.BE.6411.PP105.02)

a) filter.

b) form.

c) query.

d) report.

30. Dax performed a search for counties with populations greater than 25,000 from one table

in a database and states with populations less than 225,000 from another table in the same

database. This search is an example of a: (NCCTE.9_12.BE.6411.PP105.02)

a) filter.

b) form.

c) query.

d)