D322 IT Practice Test UPDATED ACTUAL
Exam Questions and CORRECT Answers
FROM - CORRECT ANSWER - The _______ keyword in SQL is used to inform the
DBMS what fields or attributes are of interest (and where they are located, i.e. which
table/relation they can be found in).
System Software - CORRECT ANSWER - Which software is run automatically rather
than by the end user
Expansion slots allow additional cards to be connected to the motherboard that interface with
peripheral devices - CORRECT ANSWER - Which of the following best describes the
purpose of expansion slots in modern computers?
STAR network - CORRECT ANSWER - In this network topology ALL devices have a
single point-to-point connection with a central device.
Device driver - CORRECT ANSWER - ________, sometimes referred to as middleware,
facilitate the communication of hardware and software.
A Platform as a Service is the ability to quickly and consistently develop and deliver
applications. - CORRECT ANSWER - What is the definition of a Platform as a Service
(PaaS)?
Computer software is developed by writing a program using programming language whereas
computer hardware is the physical components such as memory modules and disk drives. -
CORRECT ANSWER - Select the statement that best describes the difference between
software and hardware.
Third generation - CORRECT ANSWER - During which generation did computers begin
to see widespread use in business?
, IaaS (Infrastructure as a Service) - CORRECT ANSWER - With ________ an IT
department resources (i.e. servers, data storage) are located outside of the organization and are
accessible by anyone, anywhere.
Data are modeled using parent-child relationships. - CORRECT ANSWER - Which of the
following best describes a hierarchical database format?
Business continuity plan - CORRECT ANSWER - A company's ability to recover after a
disaster is directly related to which of the following?
Cost-effective if time is constrained - CORRECT ANSWER - What is an advantage of
outsourcing?
RAM - CORRECT ANSWER - Which is found on the motherboard and stores
information, but the information is not permanent?
CPU - CORRECT ANSWER - Which of the four main components of a computer is
described by this statement: This component executes all of the arithmetic and logic operations
and is responsible for controlling (commanding) all of the components in the computer.
An information system does not have to use computer hardware; whereas information
technology requires the use of hardware and software. - CORRECT ANSWER - Which of
the following statements best describes the difference between information systems and
information technology?
Optical wire - CORRECT ANSWER - __________ uses the concept of reflection of light
through a core made up of glass or plastic.
Hierarchal - CORRECT ANSWER - This database structure format organizes data using a
tree-like or organizational chart type structure (i.e. parent-child structure).
Exam Questions and CORRECT Answers
FROM - CORRECT ANSWER - The _______ keyword in SQL is used to inform the
DBMS what fields or attributes are of interest (and where they are located, i.e. which
table/relation they can be found in).
System Software - CORRECT ANSWER - Which software is run automatically rather
than by the end user
Expansion slots allow additional cards to be connected to the motherboard that interface with
peripheral devices - CORRECT ANSWER - Which of the following best describes the
purpose of expansion slots in modern computers?
STAR network - CORRECT ANSWER - In this network topology ALL devices have a
single point-to-point connection with a central device.
Device driver - CORRECT ANSWER - ________, sometimes referred to as middleware,
facilitate the communication of hardware and software.
A Platform as a Service is the ability to quickly and consistently develop and deliver
applications. - CORRECT ANSWER - What is the definition of a Platform as a Service
(PaaS)?
Computer software is developed by writing a program using programming language whereas
computer hardware is the physical components such as memory modules and disk drives. -
CORRECT ANSWER - Select the statement that best describes the difference between
software and hardware.
Third generation - CORRECT ANSWER - During which generation did computers begin
to see widespread use in business?
, IaaS (Infrastructure as a Service) - CORRECT ANSWER - With ________ an IT
department resources (i.e. servers, data storage) are located outside of the organization and are
accessible by anyone, anywhere.
Data are modeled using parent-child relationships. - CORRECT ANSWER - Which of the
following best describes a hierarchical database format?
Business continuity plan - CORRECT ANSWER - A company's ability to recover after a
disaster is directly related to which of the following?
Cost-effective if time is constrained - CORRECT ANSWER - What is an advantage of
outsourcing?
RAM - CORRECT ANSWER - Which is found on the motherboard and stores
information, but the information is not permanent?
CPU - CORRECT ANSWER - Which of the four main components of a computer is
described by this statement: This component executes all of the arithmetic and logic operations
and is responsible for controlling (commanding) all of the components in the computer.
An information system does not have to use computer hardware; whereas information
technology requires the use of hardware and software. - CORRECT ANSWER - Which of
the following statements best describes the difference between information systems and
information technology?
Optical wire - CORRECT ANSWER - __________ uses the concept of reflection of light
through a core made up of glass or plastic.
Hierarchal - CORRECT ANSWER - This database structure format organizes data using a
tree-like or organizational chart type structure (i.e. parent-child structure).
