IT FUNDAMENTALS COMPREHENSIVE EXAM QUESTIONS
AND SOLUTIONS 2025/2026 GRADED A+
✔✔When composing an email message, why might you want to use the Bcc field? -
✔✔To copy the email confidentially
✔✔There are several processes related to database usage. Which of the following
involves the information stored in a database, where the database is hosted, and how
clients can access the data? - ✔✔Creation
✔✔Which of the following terms describes the set of SQL commands that change the
structure or schema of a database, such as the DROP command? - ✔✔Data Definition
Language (DDL)
✔✔Which of the following SQL commands would change the title of a movie in a Movies
relational database from "The Education of Rita" to "Educating Rita"? - ✔✔UPDATE
Movies SET movie_title = "Educating Rita" WHERE id=124
✔✔In addition to having a good backup that can restore files that have been encrypted
as a result of a ransomware attack, which of the following is one of the BEST ways to
avoid being threatened to pay a ransom? - ✔✔Protect confidential company information
✔✔Which of the following 802.11 standards measures its maximum transfer rate in
Gbps (gigabytes per second)? - ✔✔802.11ac
✔✔Email and instant messaging (IM) seem to be very similar. What is the major
difference between the two communication systems? - ✔✔With instant messaging, you
and the message recipient are logged into the same sever.
✔✔A user reports that her system is running slow when saving files. You determine that
you will need to upgrade her hard disk. You identify the components that are required
and schedule the repair for later that afternoon.
Which of the following steps have you forgotten in your troubleshooting process? -
✔✔Perform a backup.
✔✔Ryan has a Google Docs account and has created a family history spreadsheet to
manage important family dates (such as birthdays and anniversaries). He has given full
access to the spreadsheet to several family members to keep the information updated.
Which of the following BEST describes this type of access model? - ✔✔Discretionary
access control
✔✔Which of the following divides a single physical disk into multiple logical drives called
volumes? - ✔✔Partitioning
,✔✔A network engineer has set up a network at company headquarters to service all
employees. Which of the following BEST describes this type of network topology? -
✔✔LAN
✔✔When using an if...else statement or a while loop, a programmer must test for a
certain condition to be true. In the following pseudocode example, which line contains
the condition?
program guessMyFavoriteColor
declare favoriteColor equal to Yellow
declare guess
read guess from user
do while (guess does not equal favoriteColor)
display "You guessed my favorite color"
else
display "That is not my favorite color"
end while
end program - ✔✔guess does not equal favoriteColor
✔✔Which of the following display devices uses adjustable mirrors along with a light
source and color filters to display the correct image? - ✔✔DLP
✔✔Which of the following CPU types does Nvidia's Tegra fall under? - ✔✔ARM
✔✔Which of the following features is supplied by WPA2 on a wireless network? (Select
two.) - ✔✔Encryption
Authentication
✔✔You are the PC technician for a company. An employee has gone to a meeting while
you fix the computer in her office. She accidentally left a report open next to her
computer which states that a friend of yours in accounting will be submitted for review if
their poor work performance continues.
Which of the following is the BEST action to take? - ✔✔Ignore the paper and tell no one
of its contents.
✔✔Which of the following are optical storage devices? (Select three.) - ✔✔DVD
BD
CD
✔✔Which of the following are important reasons for reading the documentation before
installing an application on your computer? (Select two.) - ✔✔To make sure that you
have a valid software agreement or license
To make sure that the application is compatible with your operating system
, ✔✔Lydia, a programmer, is using a two-dimensional array to store a user's status for
their chat program. As a container, an array is a special kind of variable that can store
many values. Lydia created the following:
declare user(40,2) as a string
Which of the following is true about containers? - ✔✔A container is an identifier that is
used to reference the user array.
✔✔Which of the following helps you determine your level of software product technical
support? - ✔✔Product ID
✔✔Which of the following Microsoft Access database features provides the BEST way
to organize and summarize data for analysis? - ✔✔Reports
✔✔Which of the following would best prevent an unauthorized person from remotely
accessing your computer? - ✔✔Firewall
✔✔Which of the following reflects the inverted hierarchical tree structure of Domain
Name System (DNS) servers? - ✔✔Fully qualified domain name (FQDN)
✔✔A programmer is developing a program that will list the order history for a customer.
Which of the following data structures is the BEST one to use? - ✔✔Array
✔✔What is the number of instructions a CPU can perform per second measured in? -
✔✔Hertz
✔✔One option that a computer has for the information gathered in data processing is to
return information to the user. Which of the following BEST describes this process? -
✔✔Output
✔✔What do you call any type of storage, whether it is an internal hard drive, an internal
optical drive, an external drive, a thumb drive, or a memory card, that has been shared
on a computer connected to a network for other computer to use? - ✔✔DAS (direct
attached storage)
✔✔Carol is connecting to a wireless network from her Windows 10 laptop and wants to
make sure that her laptop is hidden from other computers on the network and that file
sharing is disabled. Which of the following wireless network options should Carol select
to enable these features? - ✔✔Public
✔✔Which of the following flow chart concepts is depicted below? - ✔✔Sequence
AND SOLUTIONS 2025/2026 GRADED A+
✔✔When composing an email message, why might you want to use the Bcc field? -
✔✔To copy the email confidentially
✔✔There are several processes related to database usage. Which of the following
involves the information stored in a database, where the database is hosted, and how
clients can access the data? - ✔✔Creation
✔✔Which of the following terms describes the set of SQL commands that change the
structure or schema of a database, such as the DROP command? - ✔✔Data Definition
Language (DDL)
✔✔Which of the following SQL commands would change the title of a movie in a Movies
relational database from "The Education of Rita" to "Educating Rita"? - ✔✔UPDATE
Movies SET movie_title = "Educating Rita" WHERE id=124
✔✔In addition to having a good backup that can restore files that have been encrypted
as a result of a ransomware attack, which of the following is one of the BEST ways to
avoid being threatened to pay a ransom? - ✔✔Protect confidential company information
✔✔Which of the following 802.11 standards measures its maximum transfer rate in
Gbps (gigabytes per second)? - ✔✔802.11ac
✔✔Email and instant messaging (IM) seem to be very similar. What is the major
difference between the two communication systems? - ✔✔With instant messaging, you
and the message recipient are logged into the same sever.
✔✔A user reports that her system is running slow when saving files. You determine that
you will need to upgrade her hard disk. You identify the components that are required
and schedule the repair for later that afternoon.
Which of the following steps have you forgotten in your troubleshooting process? -
✔✔Perform a backup.
✔✔Ryan has a Google Docs account and has created a family history spreadsheet to
manage important family dates (such as birthdays and anniversaries). He has given full
access to the spreadsheet to several family members to keep the information updated.
Which of the following BEST describes this type of access model? - ✔✔Discretionary
access control
✔✔Which of the following divides a single physical disk into multiple logical drives called
volumes? - ✔✔Partitioning
,✔✔A network engineer has set up a network at company headquarters to service all
employees. Which of the following BEST describes this type of network topology? -
✔✔LAN
✔✔When using an if...else statement or a while loop, a programmer must test for a
certain condition to be true. In the following pseudocode example, which line contains
the condition?
program guessMyFavoriteColor
declare favoriteColor equal to Yellow
declare guess
read guess from user
do while (guess does not equal favoriteColor)
display "You guessed my favorite color"
else
display "That is not my favorite color"
end while
end program - ✔✔guess does not equal favoriteColor
✔✔Which of the following display devices uses adjustable mirrors along with a light
source and color filters to display the correct image? - ✔✔DLP
✔✔Which of the following CPU types does Nvidia's Tegra fall under? - ✔✔ARM
✔✔Which of the following features is supplied by WPA2 on a wireless network? (Select
two.) - ✔✔Encryption
Authentication
✔✔You are the PC technician for a company. An employee has gone to a meeting while
you fix the computer in her office. She accidentally left a report open next to her
computer which states that a friend of yours in accounting will be submitted for review if
their poor work performance continues.
Which of the following is the BEST action to take? - ✔✔Ignore the paper and tell no one
of its contents.
✔✔Which of the following are optical storage devices? (Select three.) - ✔✔DVD
BD
CD
✔✔Which of the following are important reasons for reading the documentation before
installing an application on your computer? (Select two.) - ✔✔To make sure that you
have a valid software agreement or license
To make sure that the application is compatible with your operating system
, ✔✔Lydia, a programmer, is using a two-dimensional array to store a user's status for
their chat program. As a container, an array is a special kind of variable that can store
many values. Lydia created the following:
declare user(40,2) as a string
Which of the following is true about containers? - ✔✔A container is an identifier that is
used to reference the user array.
✔✔Which of the following helps you determine your level of software product technical
support? - ✔✔Product ID
✔✔Which of the following Microsoft Access database features provides the BEST way
to organize and summarize data for analysis? - ✔✔Reports
✔✔Which of the following would best prevent an unauthorized person from remotely
accessing your computer? - ✔✔Firewall
✔✔Which of the following reflects the inverted hierarchical tree structure of Domain
Name System (DNS) servers? - ✔✔Fully qualified domain name (FQDN)
✔✔A programmer is developing a program that will list the order history for a customer.
Which of the following data structures is the BEST one to use? - ✔✔Array
✔✔What is the number of instructions a CPU can perform per second measured in? -
✔✔Hertz
✔✔One option that a computer has for the information gathered in data processing is to
return information to the user. Which of the following BEST describes this process? -
✔✔Output
✔✔What do you call any type of storage, whether it is an internal hard drive, an internal
optical drive, an external drive, a thumb drive, or a memory card, that has been shared
on a computer connected to a network for other computer to use? - ✔✔DAS (direct
attached storage)
✔✔Carol is connecting to a wireless network from her Windows 10 laptop and wants to
make sure that her laptop is hidden from other computers on the network and that file
sharing is disabled. Which of the following wireless network options should Carol select
to enable these features? - ✔✔Public
✔✔Which of the following flow chart concepts is depicted below? - ✔✔Sequence
