D322 IT Practice Test Questions with
correct answers
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). - ANSWER -FROM
Which software is run automatically rather than by the end user - ANSWER -System
Software
Which of the following best describes the purpose of expansion slots in modern
computers? - ANSWER -Expansion slots allow additional cards to be connected to
the motherboard that interface with peripheral devices
In this network topology ALL devices have a single point-to-point connection with a
central device. - ANSWER -STAR network
________, sometimes referred to as middleware, facilitate the communication of
hardware and software. - ANSWER -Device driver
What is the definition of a Platform as a Service (PaaS)? - ANSWER -A Platform as a
Service is the ability to quickly and consistently develop and deliver applications.
Select the statement that best describes the difference between software and
hardware. - ANSWER -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.
During which generation did computers begin to see widespread use in business? -
ANSWER -Third generation
With ________ an IT department resources (i.e. servers, data storage) are located
outside of the organization and are accessible by anyone, anywhere. - ANSWER -
IaaS (Infrastructure as a Service)
, Which of the following best describes a hierarchical database format? - ANSWER -
Data are modeled using parent-child relationships.
A company's ability to recover after a disaster is directly related to which of the
following? - ANSWER -Business continuity plan
What is an advantage of outsourcing? - ANSWER -Cost-effective if time is
constrained
Which is found on the motherboard and stores information, but the information is
not permanent? - ANSWER -RAM
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. -
ANSWER -CPU
Which of the following statements best describes the difference between
information systems and information technology? - ANSWER -An information system
does not have to use computer hardware; whereas information technology requires
the use of hardware and software.
__________ uses the concept of reflection of light through a core made up of glass or
plastic. - ANSWER -Optical wire
This database structure format organizes data using a tree-like or organizational
chart type structure (i.e. parent-child structure). - ANSWER -Hierarchal
Which of the following are operations used to alter the data within a relation of a
database? - ANSWER -Update , Delete , Insert
As a new sales manager, Edgar is studying the historical and current sales report
numbers to determine the top three salespersons of the year. At which stage of the
DIKW hierarchy is Edgar working? - ANSWER -Knowledge
correct answers
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). - ANSWER -FROM
Which software is run automatically rather than by the end user - ANSWER -System
Software
Which of the following best describes the purpose of expansion slots in modern
computers? - ANSWER -Expansion slots allow additional cards to be connected to
the motherboard that interface with peripheral devices
In this network topology ALL devices have a single point-to-point connection with a
central device. - ANSWER -STAR network
________, sometimes referred to as middleware, facilitate the communication of
hardware and software. - ANSWER -Device driver
What is the definition of a Platform as a Service (PaaS)? - ANSWER -A Platform as a
Service is the ability to quickly and consistently develop and deliver applications.
Select the statement that best describes the difference between software and
hardware. - ANSWER -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.
During which generation did computers begin to see widespread use in business? -
ANSWER -Third generation
With ________ an IT department resources (i.e. servers, data storage) are located
outside of the organization and are accessible by anyone, anywhere. - ANSWER -
IaaS (Infrastructure as a Service)
, Which of the following best describes a hierarchical database format? - ANSWER -
Data are modeled using parent-child relationships.
A company's ability to recover after a disaster is directly related to which of the
following? - ANSWER -Business continuity plan
What is an advantage of outsourcing? - ANSWER -Cost-effective if time is
constrained
Which is found on the motherboard and stores information, but the information is
not permanent? - ANSWER -RAM
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. -
ANSWER -CPU
Which of the following statements best describes the difference between
information systems and information technology? - ANSWER -An information system
does not have to use computer hardware; whereas information technology requires
the use of hardware and software.
__________ uses the concept of reflection of light through a core made up of glass or
plastic. - ANSWER -Optical wire
This database structure format organizes data using a tree-like or organizational
chart type structure (i.e. parent-child structure). - ANSWER -Hierarchal
Which of the following are operations used to alter the data within a relation of a
database? - ANSWER -Update , Delete , Insert
As a new sales manager, Edgar is studying the historical and current sales report
numbers to determine the top three salespersons of the year. At which stage of the
DIKW hierarchy is Edgar working? - ANSWER -Knowledge
