D322 IT Practice Test Exam with
100% Verified Answers
FROM - -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 - -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 - -Which of the following best
describes the purpose of expansion slots in modern computers?
-STAR network - -In this network topology ALL devices have a single point-
to-point connection with a central device.
-Device driver - -________, 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. - -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. - -Select the statement that best
describes the difference between software and hardware.
-Third generation - -During which generation did computers begin to see
widespread use in business?
-IaaS (Infrastructure as a Service) - -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. - -Which of the following
best describes a hierarchical database format?
-Business continuity plan - -A company's ability to recover after a disaster is
directly related to which of the following?
-Cost-effective if time is constrained - -What is an advantage of
outsourcing?
, -RAM - -Which is found on the motherboard and stores information, but the
information is not permanent?
-CPU - -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. - -Which
of the following statements best describes the difference between
information systems and information technology?
-Optical wire - -__________ uses the concept of reflection of light through a
core made up of glass or plastic.
-Hierarchal - -This database structure format organizes data using a tree-
like or organizational chart type structure (i.e. parent-child structure).
-Update , Delete , Insert - -Which of the following are operations used to
alter the data within a relation of a database?
-Knowledge - -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 - -Which of the following are the three
main categories of databases?
-A local area network (LAN) - -Allows hardware sharing within one office
-Initiation, Planning, Executing, Closing - -What is the correct order of
project phase for Project Management?
-Data mirroring - -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?
-eMail server - -This server addresses protocols such as: IMAP, POP3, SMTP,
HTTP, MAPI, and MIME?
-Education - -Learning about social engineering and how to protect
passwords is ___.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Victorious23. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £8.39. You're not tied to anything after your purchase.