D322 IT PRACTICE TEST QUESTIONS
& VERIFIED ANSWERS ALL PASSED
100%
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).
Update , Delete , Insert - CORRECT ANSWER Which of the following are operations
used to alter the data within a relation of a database?
Knowledge - CORRECT ANSWER 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?
Hierarchical , Flat File, Relational - CORRECT ANSWER Which of the following are the
three main categories of databases?
A local area network (LAN) - CORRECT ANSWER Allows hardware sharing within one
office
Initiation, Planning, Executing, Closing - CORRECT ANSWER What is the correct
order of project phase for Project Management?
Data mirroring - CORRECT ANSWER An operating system will write and change data
to multiple hard drives at the same time so that if something happens to one hard drive,
another hard drive is available to speed up data recovery. This statement best
describes which of the following?
& VERIFIED ANSWERS ALL PASSED
100%
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).
Update , Delete , Insert - CORRECT ANSWER Which of the following are operations
used to alter the data within a relation of a database?
Knowledge - CORRECT ANSWER 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?
Hierarchical , Flat File, Relational - CORRECT ANSWER Which of the following are the
three main categories of databases?
A local area network (LAN) - CORRECT ANSWER Allows hardware sharing within one
office
Initiation, Planning, Executing, Closing - CORRECT ANSWER What is the correct
order of project phase for Project Management?
Data mirroring - CORRECT ANSWER An operating system will write and change data
to multiple hard drives at the same time so that if something happens to one hard drive,
another hard drive is available to speed up data recovery. This statement best
describes which of the following?
