Practice Exam A
This is a Course Instructor created resource. If you find any errors, please
email .
Points:
85/100
Correct
2/2 Points
1.Which type of software includes programs such as Microsoft Word
and PowerPoint?
Daemons
Application
Server
System
Correct
1/1 Points
2.Which project phase consists of determining the objectives and
activities, organizing the activities, and estimating the time and costs?
Closing
Initiation
Executing & Controlling
Planning
Correct
1/1 Points
3.Which of the following best describes the purpose of expansion slots
in modern computers?
Expansion slots can be used to store programs and data.
Expansion slots allow additional processors to be connected to the motherboard.
Expansion slots can be used to connect additional peripheral devices such as an
external hard drive or monitor.
Expansion slots allow additional cards to be connected to the motherboard that
interface with peripheral devices.
Correct
1/1 Points
4.Which is found on the motherboard and stores information, but the
information is not permanent?
, CPU
RAM
Bus
ROM
Incorrect
0/1 Points
5.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).
FROM
Feedback: Unit 6 Module 19 pg 113-114
SELECT
WHERE
Correct
2/2 Points
6.Which of the following best describes a hierarchical database format?
Data are modeled using parent-child relationships.
The database format is one of the most commonly used today.
Database records that do not have relationships with other tables.
Correct
2/2 Points
7.Select the statement that best describes the difference between
software and hardware.
Computer software consists of drivers and their associated devices whereas
computer hardware includes only internal system devices.
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.
Computer software consists of applications such as word processing and
spreadsheet programs whereas computer hardware includes the operating system.
Computer programming language instructions can be very broad and general
whereas computer hardware specifications must be very specific.
Correct
2/2 Points
8.Which of the following is/are true of the IPOS cycle?
, If there will be no future need for certain information, a user can go straight from
the input stage to the output stage without going through the processing and storage
stages.
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.
As long as the data is entered correctly, there is no need to store it. The reason for
storage is to be able to prove what has been entered.
The steps of the IPOS cycle can occur in any order.
Correct
1/1 Points
9.This database structure format organizes data using a tree-like or
organizational chart type structure (i.e. parent-child structure).
Flat File
Hierarchal
Relational
Correct
1/1 Points
10.Which two are both types of scripting languages?
ASP and Python
C++ and Pascal
Python and C++
Pascal and ASP
Correct
1/1 Points
11.Which device permits packet switching so that a message can be
routed to the next link in a network?
Router
DNS
LAN
IP Address
Correct
1/1 Points
12.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.
This is a Course Instructor created resource. If you find any errors, please
email .
Points:
85/100
Correct
2/2 Points
1.Which type of software includes programs such as Microsoft Word
and PowerPoint?
Daemons
Application
Server
System
Correct
1/1 Points
2.Which project phase consists of determining the objectives and
activities, organizing the activities, and estimating the time and costs?
Closing
Initiation
Executing & Controlling
Planning
Correct
1/1 Points
3.Which of the following best describes the purpose of expansion slots
in modern computers?
Expansion slots can be used to store programs and data.
Expansion slots allow additional processors to be connected to the motherboard.
Expansion slots can be used to connect additional peripheral devices such as an
external hard drive or monitor.
Expansion slots allow additional cards to be connected to the motherboard that
interface with peripheral devices.
Correct
1/1 Points
4.Which is found on the motherboard and stores information, but the
information is not permanent?
, CPU
RAM
Bus
ROM
Incorrect
0/1 Points
5.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).
FROM
Feedback: Unit 6 Module 19 pg 113-114
SELECT
WHERE
Correct
2/2 Points
6.Which of the following best describes a hierarchical database format?
Data are modeled using parent-child relationships.
The database format is one of the most commonly used today.
Database records that do not have relationships with other tables.
Correct
2/2 Points
7.Select the statement that best describes the difference between
software and hardware.
Computer software consists of drivers and their associated devices whereas
computer hardware includes only internal system devices.
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.
Computer software consists of applications such as word processing and
spreadsheet programs whereas computer hardware includes the operating system.
Computer programming language instructions can be very broad and general
whereas computer hardware specifications must be very specific.
Correct
2/2 Points
8.Which of the following is/are true of the IPOS cycle?
, If there will be no future need for certain information, a user can go straight from
the input stage to the output stage without going through the processing and storage
stages.
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.
As long as the data is entered correctly, there is no need to store it. The reason for
storage is to be able to prove what has been entered.
The steps of the IPOS cycle can occur in any order.
Correct
1/1 Points
9.This database structure format organizes data using a tree-like or
organizational chart type structure (i.e. parent-child structure).
Flat File
Hierarchal
Relational
Correct
1/1 Points
10.Which two are both types of scripting languages?
ASP and Python
C++ and Pascal
Python and C++
Pascal and ASP
Correct
1/1 Points
11.Which device permits packet switching so that a message can be
routed to the next link in a network?
Router
DNS
LAN
IP Address
Correct
1/1 Points
12.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.
