ITE 152 EXAM 3, PRACTICE EXAM AND STUDY
GUIDE NEWEST 2025 ACTUAL EXAM 100
QUESTIONS AND CORRECT DETAILED
ANSWERS (VERIFIED ANSWERS) |ALREADY
GRADED A+
Which field could serve as the primary key for a list of students in your school? -
ANSWER>>Student ID number
A field's data type determines what kind of information can be stored there. -
ANSWER>>True
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? - ANSWER>>ProductID
All the pet names in a veterinarian's database are stored in a _______ called PetName.
- ANSWER>>Field
Which of the following is a way to sort data? - ANSWER>>All of the above
(Alphabetically, Numerically, Chronologically)
What does SQL stand for? - ANSWER>>Structured Query Language
What is a query? - ANSWER>>A question you ask a database
What are the columns in a Microsoft Access table called? - ANSWER>>Fields
In a record, each separate piece of data, such as a last name, a first name, or an
address, is called a _____________. - ANSWER>>Field
, Which data type would be best suited to a field that lists a product's clearance price? -
ANSWER>>Currency
A query lets you speed up the browsing process by finding information that matches
specifically to your criteria. - ANSWER>>True
What are the different views to display a table? - ANSWER>>All of the above (Pivot
Table & Pivot Chart View, Datasheet View, Design View)
Databases typically store their data in one big table. - ANSWER>>False
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? - ANSWER>>Smallest to
largest
In a database, each _________________ contains a collection of related data. -
ANSWER>>Table (?)
A database is an organized collection of information. - ANSWER>>A database is an
organized collection of integrated files
True
Ibraheem works for a music store. Which of the following tables will give him the
company contact information he needs to place a custom order for a guitar? -
ANSWER>>Vendors
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? - ANSWER>>Graduated
GUIDE NEWEST 2025 ACTUAL EXAM 100
QUESTIONS AND CORRECT DETAILED
ANSWERS (VERIFIED ANSWERS) |ALREADY
GRADED A+
Which field could serve as the primary key for a list of students in your school? -
ANSWER>>Student ID number
A field's data type determines what kind of information can be stored there. -
ANSWER>>True
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? - ANSWER>>ProductID
All the pet names in a veterinarian's database are stored in a _______ called PetName.
- ANSWER>>Field
Which of the following is a way to sort data? - ANSWER>>All of the above
(Alphabetically, Numerically, Chronologically)
What does SQL stand for? - ANSWER>>Structured Query Language
What is a query? - ANSWER>>A question you ask a database
What are the columns in a Microsoft Access table called? - ANSWER>>Fields
In a record, each separate piece of data, such as a last name, a first name, or an
address, is called a _____________. - ANSWER>>Field
, Which data type would be best suited to a field that lists a product's clearance price? -
ANSWER>>Currency
A query lets you speed up the browsing process by finding information that matches
specifically to your criteria. - ANSWER>>True
What are the different views to display a table? - ANSWER>>All of the above (Pivot
Table & Pivot Chart View, Datasheet View, Design View)
Databases typically store their data in one big table. - ANSWER>>False
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? - ANSWER>>Smallest to
largest
In a database, each _________________ contains a collection of related data. -
ANSWER>>Table (?)
A database is an organized collection of information. - ANSWER>>A database is an
organized collection of integrated files
True
Ibraheem works for a music store. Which of the following tables will give him the
company contact information he needs to place a custom order for a guitar? -
ANSWER>>Vendors
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? - ANSWER>>Graduated
