Part 2

Question 1

A form of backup that creates a copy of everything that is on a hard drive including the OS, programs, and configuration files.

Answer 1

Image Backups

Question 2

ALU

Answer 2

The ALU contains the circuitry that performs operations on data such as addition and subtraction

Question 3

What is the purpose of a business continuity plan?

Answer 3

To enable an organization to continue offering critical services in the event of disruptions

Question 4

The role of a systems administrator

Answer 4

Systems administrators are responsible for supporting, monitoring, and maintaining workplace technology and end users

Question 5

Which statement is correct given that usability is very subjective, and handheld and desktop computers may be more or less usable based on the demands of the user?

Answer 5

A desktop has more processing power

Question 6

What is a primary difference between a modern handheld computer and a modern desktop computer?

Answer 6

A desktop has more processing power

Question 7

Light impulses

Answer 7

Fiber optic cable

Question 8

A petabytes consists of how many terabytes?

Answer 8

1000

Question 9

Teachers in the Lincoln County School District are complaining about the speed on the Internet in their classrooms. Marcus, the IT coordinator, has a limited amount of money to spend to address the issue. What option that uses hardware or software helps solve the problem?

Answer 9

Marcus determines that school’s routers that transmit information from the Internet across the district are slow and outdated, so he will use the money to replace then

Question 10

SQL (Structured Query Language), a query for databases, was invented by?

Answer 10

IBM

Question 11

System Administrator

Answer 11

This individual updates an organization’s computer hardware and software, performs troubleshooting, and maintains the operating system of a computer system

Question 12

The four computers based on size and processing speed are supercomputers, workstation, mainframe, and microcomputer. True or False?

Answer 12

True

Question 13

The timeline of computer development

Answer 13

First, computers built and programmed by engineer. Next, limited use of computers by large organizations. Next, introduction of personal computers. Lastly, Graphical User Interface systems are introduced.

Question 14

The business case, feasibility study, and stakeholder input are 3 key elements of which project phase?

Answer 14

Initiation

Question 15

The selection operation takes columns from one table and creates a new table. True or False?

Answer 15

True

Question 16

______ are system development methodologies that propose incremental implementations, respond to rapidly changing requirements, and reduce the emphasis on rigorous requirements.

Answer 16

Agile methods

Question 17

What is NOT true of compilers and interpreters?

Answer 17

Compilers do not translate source code into machine code

Question 18

Which database categories is the most similar to a spreadsheet or MS Excel document?

Answer 18

Flat file

Question 19

Within this CLOUD computing function all the resources hardware and software(e.g., servers, data storage) an IT department needs are located outside of the organization and are accessible by anyone, anywhere

Answer 19

IaaS (Infrastructure as a Service)

Question 20

What is the collection of names, addresses, and account balances of all the patients of Mei’s office more technically known as?

Answer 20

Database

Question 21

___ refers to data sets that are so large and complex that they will require more advanced database management/processing tools that we currently use?

Answer 21

Big Data

Question 22

A Web page’s URL (Uniform Resource Locator) has three main parts:

Answer 22

The protocol, the domain name, and the resource or file name

Question 23

Which factors should Mike NOT consider when choosing a file organization system?

Answer 23

Hierarchy

Question 24

How many tiers of ISPs?

Answer 24

3

Question 25

What is NOT an operation for database queries?

Answer 25

Serve

Question 26

While hardware is ____, software is ____?

Answer 26

tangible - intangible

Question 27

What is one probable advantage of outsourcing?

Answer 27

Reliance can be placed on the expertise of outsourcing vendors

Question 28

____ is defined as a code of moral conduct or a set of principles that govern behavior?

Answer 28

Ethics

Question 29

Which type of systems testing includes having developers test internal structures of software?

Answer 29

White-box

Question 30

The name, address, and telephone number of each individual patient in Dr. Alan’s office is known as a:

Answer 30

Record

Question 31

Which is NOT part of the history of the computer?

Answer 31

Abracadabra

Question 32

Marcus has a summer job working at a real estate agency. He is calculating the zip code with the most houses for sale. At which stage of the DIKW hierarchy is Marcus working?

Answer 32

Information

Question 33

IT functions cover these five different domains: communication, data collection and management, information security management, consumer relationship management, and process improvement. True or False?

Answer 33

True

Question 34

A typical database application has how many layers?

Answer 34

2

Question 35

Which data format is not in an easily usable format and take greater effort to extract?

Answer 35

Unstructured

Question 36

As a part of effective IT governance, the IT plan should be consistent with the organization's what?

Answer 36

Business plan