C182 Practice Exam A

What is the definition of a Platform as a Service (PaaS)?

A Platform as a Service is the ability to quickly and consistently develop and deliver applications.

A program written in a high-level language must be converted into __________ code to be executed by the computer.

Machine

Which of the following statements accurately describes random access memory (RAM)?

RAM is short-term memory.

Which of the following is NOT an important characteristic of an IT professional?

Strong math background and programming skills

Which of the following types of information present a threat to someone's privacy?

Student ID and credit card numbers

During which generation did computers begin to see widespread use in business?

Third generation

Which of the following operators is used to select all of a certain data?

*

Which two are both types of scripting languages?

ASP and Python

Which of the following statements is not part of the path a message takes from one computer to another?

All messages require a response from the destination machine to the sending device.

A local area network (LAN)

Allows hardware sharing within one office

Software testing conducted by a client or a specific department within an organization, is called:

Alpha

During implementation, how is alpha testing different from beta testing?

Alpha testing uses simulated data

Which of the following statements describes the difference between information systems and information technology?

An information system does not have to use computer hardware or software; whereas information technology requires the use of hardware and software.

Which of the following carries out the instructions of a computer program and is often referred to as the "chip"?

Central Processing Unit

The team will write a final report detailing the processes and outcomes of the project in which project phase?

Closing

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.

This database structure format organizes data using a tree-like or organizational chart type structure (i.e. parent-child structure)

Hierarchal

Which of the following are the three main categories of databases?

Hierarchical , Flat File, Relational

What is another term that defines a script?

Interpreted program

All of the following are high-level languages except for:

Javascript

As a new sales manager, Sylvia 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 Sylvia working?

Knowledge

All of the following are parts of a URL except for:

LAN

Which of the following would NOT require the use of a network?

Loading a statistical program on your personal computer.

In the _______ design phase of the SDLC (system development life cycle) the system is described in abstract terms using modeling tools such as flowcharts, UML and entity-relationship diagrams.

Logical

Database administrators might be involved with the integration of data from where?

Older systems to new

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.

Which of the following is an example of what 1 GB would store?

Thousands of books

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

File access rights

Will include files that the user can access

__________ software works with hardware to provide a network service

Windows Server

Which of the following would NOT be considered hardware?

Word processor.

A collection of organized databases is called?

a data warehouse

This server addresses protocols such as: IMAP, POP3, SMTP, HTTP, MAPI, and MIME (email protocols)

eMail server

This type of software is made freely available as source code.

open source software

The role of a ______ ______ is to respond to requests most typically come from web browsers, such as HTTP

web server

This type of database is the most common format for storing data as it provides users with a great deal of flexibility, allowing for multiple tables (relations).

Relational

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 of the following is an example of a relational database?

A database containing student records with fields such as Student ID, First Name, Last Name, Major, GPA that links to other databases in the University's system.

Which of the following interacts between a database and an application?

A driver

Which of the following would NOT be the responsibility of the system administrator?

Answering e-mails from potential customers.

Which type of software includes programs such as Microsoft Word and PowerPoint?

Application

What peripheral component houses CDs and DVD?

Bays

What is IT management responsible for?

Being the project manager

This phase of testing consists of using actual (i.e., live) data in the real working environment

Beta

A company's ability to recover after a disaster is directly related to which of the following?

Business continuity plan

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.

Why is it essential to know what information will be needed from the database from the outset of development? Select all that apply

By knowing the purpose, the developer can determine how many fields are needed in the database. The purpose determines the structure of the database. The developer can determine which data types would help fulfill the purpose.

Which of the following high-level programming languages was created to be business-oriented?

COBOL

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.

CPU

This software protection will protect an individuals original work (tangible form)for the authors life + 70 years

Copyright

What is an advantage of outsourcing?

Cost-effective if time is constrained

Marcus has a summer job working at a real estate agency. He is entering client addresses into the company's computer system. At which stage of the DIKW hierarchy is Marcus working?

Data

Which of the following best describes a hierarchical database format?

Data are modeled using parent-child relationships.

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

In strategic risk analysis, what is the final step?

Develop and enact policies against threats

________ ________ occurs when the old system is "turned off" and the new system is "turned on" at a specific date and time.

Direct Conversion

Which of the following statements accurately describe IT certifications?

Earning an IT certificate indicates an IT professional has a thorough background in a specific IT area.

Learning about social engineering and how to protect passwords is ___.

Education

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.

The ______ keyword in SQL is used to inform the DBMS what tables are to be interrogated by the query and, if more than one table contains the data of interest, how they are to be combined or joined.

FROM

Your site's Internet point of presence is called a:

Gateway

A scanner is a peripheral device for what system?

I/O

Which of the following aligns IT goals and organization goals?

IT goals include cloud computing and organization goals include real-time communication to contain costs while scaling quickly

IT personnel who understand both the technical IT infrastructure and management of the business fill which role?

IT management

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)

Determining the project scope or the work that needs to be completed is in what project phase?

Initiation

Which project phase determines what resources are available to meet the project needs?

Initiation

During this phase of Project Management, the projects scope and requirements are defined

Initiation phase

What is the correct order of project phase for Project Management?

Initiation, Planning, Executing & Controlling, Closing

Which of the following best describes the differences between memory and the hard drive?

Memory stores instructions and data used by programs in the moment; whereas a hard drive stores data, programs, and files that can be accessed at a future time.

The use of IT has allowed businesses to have __________.

More tools for communicating

Which computer will use a docking station to function like a desktop?

Notebook

What is a program that will allow a computer to easily access the hardware and software of the computer system?

Operating system

This form of cloud computing is offered as a service by some major organizations, such as Amazon and Google, and used extensively by app developers. Its intent is to be able to quickly and reliably develop and deliver applications

PaaS (Platform as a Service)

During ____ _____ the output of the new system is compared with the output of the old system

Parallel Converison

This license protects the creation of inventive concepts as well as the tangible work product for 20 years at the date of filing

Patent

During ____ _____ the old system continues to offer some functionality until all subsets of the new system have been turned on and the new system is confirmed to be working effectively.

Phased Conversion

Which project phase consists of determining the objectives and activities, organizing the activities, and estimating the time and costs?

Planning

What external component will allow peripherals to be connected to the system unit and connect additional input, output, storage, and communication devices?

Ports

An undertaking with a start and end, specified goals, and tasks to reach those goals is the definition of the?

Project

Which is found on the motherboard and stores information but the information is not permanent?

RAM

Which device permits packet switching so that a message can be routed to the next link in a network?

Router

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

In this network topology ALL devices have a single point-to-point connection with a central devic

STAR network

During analysis, which system requirement prevents unauthorized users from accessing data?

Security

For the following scenario, which government regulation would be relevant? Andrea is employed by the Deming Foundation, a non-profit seeking to help increase graduation rates in rural communities. She has been working hard to identify and recruit donations from wealthy businessmen and companies and is seeing a great deal of success. While she quickly runs into the grocery store for a few items, someone steals her laptop from her car, containing all her work files.

Security Breach Notification Laws.

All of the following are input systems except:

Speaker

Which software is run automatically rather than by the end user?

System Software

Which term involves replacing the old system with a new system?

System conversion

Which of the following is the final step in creating a BCP plan?

Testing the plan

Which account is also referred to as root or superuser?

The Administrator Account

Which of the following statements best defines the CPU?

The CPU controls the speed at which instructions are retrieved and processed in the computer.

Which of the following best describes the Internet?

The Internet is a global network of networks.

Which of the following statements best represents the relevant characteristic of quality data?

The data used applies to the question being answered.

The scope of the project is?

The work that needs to be done

Which of the following is the correct function of the compiler?

Translates the entire program, creating an executable program, which can be run at a later time.

Which of the following are operations used to alter the data within a relation of a database?

Update , Delete , Insert

Which of the following statements applies to a business intelligence system?

Used when making long-term decisions.

During implementation, which testing assesses whether the system functions and is useful?

User Acceptance

Which of the following describes the duties of a web administrator?

Duties include maintaining and securing the web server. Also responsible for troubleshooting the web server.