ITE 152 - EXAM 3 QUESTIONS AND CORRECT ANSWERS |
ALREADY GRADE A+ | LATEST EXAM
1. Which field could serve as the primary key for a list of Student ID number
students in your school?
2. A field's data type determines what kind of information True
can be stored there.
3. Dana is creating a table that will show books for sale on ProductID
a bookstore's website. Which field in the table would
best serve as its primary key?
4. All the pet names in a veterinarian's database are Field
stored in a called PetName.
5. Which of the following is a way to sort data? All of the above (Alphabeti-
cally, Numerically, Chrono-
logically)
6. What does SQL stand for? Structured Query Lan-
guage
7. What is a query? A question you ask a data-
base
8. What are the columns in a Microsoft Access table Fields
called?
9. In a record, each separate piece of data, such as a Field
last name, a first name, or an address, is called a
.
10. Which data type would be best suited to a field that Currency
lists a product's clearance price?
, ITE 152 - EXAM 3 QUESTIONS AND CORRECT ANSWERS |
ALREADY GRADE A+ | LATEST EXAM
11. A query lets you speed up the browsing process by True
finding information that matches specifically to your
criteria.
12. What are the different views to display a table? All of the above (Piv-
ot Table & Pivot Chart
View, Datasheet View, De-
sign View)
13. Databases typically store their data in one big table. False
14. Kian needs to sort a list of patients by birthdate to Smallest to largest
show the oldest patients first. What sort order on the
birthdate field will give him this result?
15. In a database, each contains a collec- Table (?)
tion of related data.
16. A database is an organized collection of information. True
17. Ibraheem works for a music store. Which of the follow- Vendors
ing tables will give him the company contact informa-
tion he needs to place a custom order for a guitar?
18. Xavier is designing a Students table that will continue Graduated
to track students even after they have completed their
programs. Which of the following fields would work
best with the Yes/No data type?
19. Sawyer is looking at a table of students in his class, but The table is filtered.
it seems like the list is way too short. What is the most
likely problem?
ALREADY GRADE A+ | LATEST EXAM
1. Which field could serve as the primary key for a list of Student ID number
students in your school?
2. A field's data type determines what kind of information True
can be stored there.
3. Dana is creating a table that will show books for sale on ProductID
a bookstore's website. Which field in the table would
best serve as its primary key?
4. All the pet names in a veterinarian's database are Field
stored in a called PetName.
5. Which of the following is a way to sort data? All of the above (Alphabeti-
cally, Numerically, Chrono-
logically)
6. What does SQL stand for? Structured Query Lan-
guage
7. What is a query? A question you ask a data-
base
8. What are the columns in a Microsoft Access table Fields
called?
9. In a record, each separate piece of data, such as a Field
last name, a first name, or an address, is called a
.
10. Which data type would be best suited to a field that Currency
lists a product's clearance price?
, ITE 152 - EXAM 3 QUESTIONS AND CORRECT ANSWERS |
ALREADY GRADE A+ | LATEST EXAM
11. A query lets you speed up the browsing process by True
finding information that matches specifically to your
criteria.
12. What are the different views to display a table? All of the above (Piv-
ot Table & Pivot Chart
View, Datasheet View, De-
sign View)
13. Databases typically store their data in one big table. False
14. Kian needs to sort a list of patients by birthdate to Smallest to largest
show the oldest patients first. What sort order on the
birthdate field will give him this result?
15. In a database, each contains a collec- Table (?)
tion of related data.
16. A database is an organized collection of information. True
17. Ibraheem works for a music store. Which of the follow- Vendors
ing tables will give him the company contact informa-
tion he needs to place a custom order for a guitar?
18. Xavier is designing a Students table that will continue Graduated
to track students even after they have completed their
programs. Which of the following fields would work
best with the Yes/No data type?
19. Sawyer is looking at a table of students in his class, but The table is filtered.
it seems like the list is way too short. What is the most
likely problem?
