ITE 152 FINAL EXAM 3 QUESTIONS AND
VERIFIED ANSWERS 2025
Cassidy is a medical assistant in a hospital and has
access to many medical files. When she brings
patients to the examining room, she can be
observed swiping a card, typing in a password, and
staring into what appears to be a camera, all
attached to the computer. After completing her
check-in, Cassidy leaves the patient in the
examining room waiting on the doctor. It is
important that she logs out of the system so the
patient does not have access to the information
stored in the hospital's database. Based on
Cassidy's actions what systems do you think the
hospital has in place to protect the patient medical
records?
-Two factor authentication
-Digital certificates
-Encryption
-Biometrics - CORRECT ANSWER -Biometrics
,Sawyer is looking at a table of students in his class,
but it seems like the list is way too short. What is
the most likely problem?
-The table is missing a primary key.
-The table is sorted.
-The table is filtered.
-The table has been deleted. - CORRECT ANSWER -
The table is filtered.
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? -
Employer
-Graduated
-GPA
-Major - CORRECT ANSWER -Graduated
,One disadvantage of computerized databases is that
they limit your ability to arrange information.
-True
-False - CORRECT ANSWER -False
A database is a collection of related information, but
a database management system is a type of
software program.
-True
-False - CORRECT ANSWER -True
A database is an organized collection of
information.
-True
-False - CORRECT ANSWER -True
What are the columns in a Microsoft Access table
called?
, -Rows
-Fields
-Records
-Columns - CORRECT ANSWER -Fields
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?
-Inventory
-Employees
-Customers
-Vendors - CORRECT ANSWER -Vendors
What does SQL stand for?
-Stated question language
-Structured query language
-System query lingo
VERIFIED ANSWERS 2025
Cassidy is a medical assistant in a hospital and has
access to many medical files. When she brings
patients to the examining room, she can be
observed swiping a card, typing in a password, and
staring into what appears to be a camera, all
attached to the computer. After completing her
check-in, Cassidy leaves the patient in the
examining room waiting on the doctor. It is
important that she logs out of the system so the
patient does not have access to the information
stored in the hospital's database. Based on
Cassidy's actions what systems do you think the
hospital has in place to protect the patient medical
records?
-Two factor authentication
-Digital certificates
-Encryption
-Biometrics - CORRECT ANSWER -Biometrics
,Sawyer is looking at a table of students in his class,
but it seems like the list is way too short. What is
the most likely problem?
-The table is missing a primary key.
-The table is sorted.
-The table is filtered.
-The table has been deleted. - CORRECT ANSWER -
The table is filtered.
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? -
Employer
-Graduated
-GPA
-Major - CORRECT ANSWER -Graduated
,One disadvantage of computerized databases is that
they limit your ability to arrange information.
-True
-False - CORRECT ANSWER -False
A database is a collection of related information, but
a database management system is a type of
software program.
-True
-False - CORRECT ANSWER -True
A database is an organized collection of
information.
-True
-False - CORRECT ANSWER -True
What are the columns in a Microsoft Access table
called?
, -Rows
-Fields
-Records
-Columns - CORRECT ANSWER -Fields
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?
-Inventory
-Employees
-Customers
-Vendors - CORRECT ANSWER -Vendors
What does SQL stand for?
-Stated question language
-Structured query language
-System query lingo
