D QUESTIONS WITH COMPLETE VERIFIED SOLUTIONS
The __________________ is the electronic circuit responsible for executing
computer program instructions.
Central Processing Unit
Which of the following best describes the Internet?
The Internet is a global network of networks
Which is found on the motherboard and stores information, but the information is
not permanent?
RAM
The role of a ______ ______ is to respond to requests most typically come from
web browsers, such as HTTP
Web server
The _____ keyword in SQL is used to inform the DBMS of the specific criteria the
data should match to be returned as the output of the query.
WHERE clause
All of the following are parts of a URL except for:
LAN
What is the correct order of project phase for Project Management?
Initiation, Planning, Executing, Closing
The scope of the project is considered what?
The work that needs to be done
In the _______ phase of the SDLC (system development life cycle), architects
think about the components that they would need to solve the problem or
implement the plan.
Design
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?
Data Mirroring
Which of the following is/are true of the IPOS cycle?
Once words, numbers or images are entered, a computer processes the data into
useable information that can then be accessed to answer questions or meet specific
needs.
Select the statement that best describes the difference between software and
hardware.
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.
Which of the following would NOT be considered hardware?
Word processor
Which of the following best describes a hierarchical database format?
Data are modeled using parent-child relationships.
__________ uses the concept of reflection of light through a core made up of
glass or plastic.
Optical wire
Which of the following are the three main categories of databases?
Hierarchical , Flat File, Relational
What is the definition of business intelligence?
Business intelligence is a term used to reflect the knowledge a business can create by
analyzing data gathered from multiple sources.
Which two are both types of scripting languages?
ASP & Python
During _______ users test the system in an operational setting to make sure the
system continues to align with business objectives and meet the goals of the
stakeholders.
User Acceptance Testing
What is another term that defines a script?
, Interpreted program
In a __________ shell forward slash (/) is used to express directory paths?
Linux
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).
Select clause
Which of the following best describes the purpose of expansion slots in modern
computers?
Expansion slots allow additional cards to be connected to the motherboard that
interface with peripheral devices.
This server addresses protocols such as: IMAP, POP3, SMTP, HTTP, MAPI, and
MIME?
eMail server
The team will write a final report detailing the processes and outcomes of the
project in which project phase?
Closing
Which of the following would NOT require the use of a network?
Loading a statistical program on your personal computer.
With ________ an IT department resources (i.e. servers, data storage) are located
outside of the organization and are accessible by anyone, anywhere.
IaaS (Infrastructure as a Service)
________________ is a general term that describes any attack that takes
advantage of humans' trusting nature.
Social engineering
Which of the following is an accurate definition of a computer system?
A computer system is a collection of hardware and software components that work
together to meet the needs of the user.
Which device permits packet switching so that a message can be routed to the
next link in a network?
Router