ITE152 EXAM 3 QUESTIONS AND ANSWERS
(mod 9) Xavier is designing a Students table that will continue to track students even after they have
completed their programs. Which of the following fields would work best with the Yes/No data type?
A. Major
B. GPA
C. Graduated
D. Employer - CORRECT ANSWER✅✅C. Graduated
(mod 9) Which data type would be best suited to a field that lists customer email addresses?
A. Hyperlink
B. Date/Time
C. Number
D. AutoNumber - CORRECT ANSWER✅✅A. Hyperlink
(mod 9) What are the different views to display a table?
A. All of the above
B. Datasheet View
C. Pivot Table & Pivot Chart View
D. Design View - CORRECT ANSWER✅✅A. All of the above
(mod 9) All the pet names in a veterinarian's database are stored in a _______ called PetName.
A. table
B. worksheet
C. field
,D. record - CORRECT ANSWER✅✅C. field
(mod 9) A relationship is created between how many tables?
A. Two
B. Three
C. Any number
D. One - CORRECT ANSWER✅✅A. Two
(mod 9) A database is an organized collection of information
(T/F) - CORRECT ANSWER✅✅True
(mod 9) What is a query?
A. A question you ask a field
B. A question you ask a table
C. A question you ask a record
D. A question you ask a database - CORRECT ANSWER✅✅D. A question you ask a database
(mod 9) Contact information for all the people taking a class at a school are stored in a ________ called
Students.
A. worksheet
B. record
C. table
D. field - CORRECT ANSWER✅✅C. table
(mod 9) Dana is creating a table that will show books for sale on a bookstore's website. Which field in
the table would best serve as its primary key?
, A. ProductID
B. Title
C. PageCount
D. Author - CORRECT ANSWER✅✅A. ProductID
(mod 9) In a database, each _________________ contains a collection of related data.
A. Table
B. Field
C. Record
D. None of the above - CORRECT ANSWER✅✅A. Table
(mod 9) Which of the following is LEAST likely to be a field in a Customers table?
A. LastName
B. EmploymentDate
C. PhoneNumber
D. Address - CORRECT ANSWER✅✅B. EmploymentDate
(mod 9) Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort
order on the birthdate field will give him this result?
A. Smallest to largest
B. Z to A
C. Largest to smallest
D. A to Z - CORRECT ANSWER✅✅C. Largest to smallest
(mod 9) Xavier is designing a Students table that will continue to track students even after they have
completed their programs. Which of the following fields would work best with the Yes/No data type?
A. Major
B. GPA
C. Graduated
D. Employer - CORRECT ANSWER✅✅C. Graduated
(mod 9) Which data type would be best suited to a field that lists customer email addresses?
A. Hyperlink
B. Date/Time
C. Number
D. AutoNumber - CORRECT ANSWER✅✅A. Hyperlink
(mod 9) What are the different views to display a table?
A. All of the above
B. Datasheet View
C. Pivot Table & Pivot Chart View
D. Design View - CORRECT ANSWER✅✅A. All of the above
(mod 9) All the pet names in a veterinarian's database are stored in a _______ called PetName.
A. table
B. worksheet
C. field
,D. record - CORRECT ANSWER✅✅C. field
(mod 9) A relationship is created between how many tables?
A. Two
B. Three
C. Any number
D. One - CORRECT ANSWER✅✅A. Two
(mod 9) A database is an organized collection of information
(T/F) - CORRECT ANSWER✅✅True
(mod 9) What is a query?
A. A question you ask a field
B. A question you ask a table
C. A question you ask a record
D. A question you ask a database - CORRECT ANSWER✅✅D. A question you ask a database
(mod 9) Contact information for all the people taking a class at a school are stored in a ________ called
Students.
A. worksheet
B. record
C. table
D. field - CORRECT ANSWER✅✅C. table
(mod 9) Dana is creating a table that will show books for sale on a bookstore's website. Which field in
the table would best serve as its primary key?
, A. ProductID
B. Title
C. PageCount
D. Author - CORRECT ANSWER✅✅A. ProductID
(mod 9) In a database, each _________________ contains a collection of related data.
A. Table
B. Field
C. Record
D. None of the above - CORRECT ANSWER✅✅A. Table
(mod 9) Which of the following is LEAST likely to be a field in a Customers table?
A. LastName
B. EmploymentDate
C. PhoneNumber
D. Address - CORRECT ANSWER✅✅B. EmploymentDate
(mod 9) Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort
order on the birthdate field will give him this result?
A. Smallest to largest
B. Z to A
C. Largest to smallest
D. A to Z - CORRECT ANSWER✅✅C. Largest to smallest
