Introduction to IT KSO1

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

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

A form of backup that creates a copy of everything that is on a hard drive including the OS, programs, and configuration files. This statement best describes which of the following?

Image Backups

Why do high-level programming languages need to be translated?

In order for the computer to understand the code.

A website logs the timestamp, location, and browser of every visitor. It then aggregates this content into peak traffic times and days, minimum and maximum hits for each country and region, and popularity of certain browsers among visitors. What is the timestamp considered in this scenario?

Data

Which of the following best describes a hierarchical database format?

Data are modeled using parent-child relationships.

What is the definition of information information technology (IT)?

It is the technology used to create, maintain, and make information accessible

In a SQL query, the __________ operation combines two tables together?

JOIN

All of the following are compiled languages except for:

Javascript

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?

Knowledge

What two inventions have allowed programmers to avoid writing programs in machine language?

Language Translators and high-level programming languages

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.

Which two computer peripherals are connected to the computer through a port?

External microphone USB flash drive

Hot storage is a low cost and slow means of storing critical data, while cold storage is high cost and fast.

False

Which answer most accurately describes the timeline of computer development?

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

Which accurately describes the advantages of high-level programming languages over low-level programming languages?

High-level languages use natural language words and are easier to learn.

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)

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.

Which is NOT part of the history of the computer?

Abracadabra

When must a software license agreement be accepted when using proprietary software?

After downloading (or obtaining via another medium) but before using the software

A local area network (LAN)

Allows hardware sharing within one office

Which IT position has the responsibility of working with routers and switches?

Network administrator

__________ uses the concept of reflection of light through a core made up of glass or plastic.

Optical wire

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)

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

Planning

During this phase of Project Management, the projects scope and project management plan are defined.

Planning phase

Which classification for documents is used when the unauthorized disclosure, alteration, or destruction of data would result in little or no risk?

Public

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

Record

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

Router

Which two are both types of scripting languages?

Ruby and Python

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 device.

STAR network

What is a cloud model that delivers third-party software such as email or games through the internet?

SaaS

Thru this CLOUD computing function, businesses can access and use software through the Internet?

SaaS (Software as a Service)

Which of the following would be a field in a database? Select two that apply.

Sales, Gender

Which of the following statements accurately describes off-site storage? Select two that apply.

Site sharing is a form of off-site storage that involves having multiple data centers located in different regions. An off-site storage location should be far enough away from the main business site so that it is protected in the case of a disaster.

Which of the following is an accurate statement about the software in a computer system? Select all that apply.

Software must be part of the computer system in order for the system to be useful. The software in a computer system may be shared if the system is a part of a network .A computer system needs software to be able to communicate with users as well as other computers.

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

Strong math background and programming skills

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

System Software

Which statement describes the role of a systems administrator?

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

Power connectors are responsible for which of the following?

Taking current from external wall outlets.

Which of the following statements best defines the ALU?

The ALU contains circuitry that performs operations on data such as addition and subtration.

Which of the following statements represents the relevant characteristic of quality data? Select all that apply.

The data used applies to the question being answered That data has been gathered using consistent, detailed collection processes The data has been inputted correctly and is accurate for its intended use The data is current enough to still serve its purpose for being accessed

What is the role of drivers in facilitating communication between applications?

They allow the application to interact with the database

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

Third generation

Traditional flat file systems are one-dimensional and present information from a single point of view and do not interact with other files.

True

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

Web Server

In a __________ shell forward slash (/) is used to express directory paths?

Windows

Which of the following would NOT be considered hardware?

Word Processor

Which two software application packages would be classified as productivity software?

Word processor Spreadsheet program

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

database

A ____________ is also known as a datasheet.

database table

The use of IT has allowed businesses to have ______

more tools for communicating

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.

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.

In this phase of testing the system is given to a segment of end users for testing from their perspective before the final version is released.

Beta

Which of the following are strategies used for disaster recovery and business continuity?

Data mirroring, Data backups, off-site storage

Read the following scenario, and then select the job title that most accurately depicts the descriptions. Javier starts the day by checking his e-mails. Sandra in payroll would like him to print a report detailing how much money has been spent on training new employees. She would like a comparison of the training dollars spent over the last five years. Javier spends the morning retrieving the appropriate information from the database and e-mails a report to Sandra. In the afternoon, Javier begins a performance analysis of the new database management system that he installed last week. He also double-checks that the old data has properly transferred to the new system. He then develops a list of procedures for those who work under him so they can also run performance analyses. Finally, he heads upstairs to the Chief Operating Officer's office to make a brief presentation on the new database system and how it can be used most effectively.

Database administrator

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

Which category of computer has an external flat screen monitor, optical disk drive, and a large capacity hard drive?

Desktop

________, sometimes referred to as middleware, facilitate the communication of hardware and software.

Device Driver

During which generation did computers begin to see widespread use in homes and offices?

Fourth Generation

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?

Information

Which term is defined as a collection of information used to support management of an organization?

Information system

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

Initiation

What is another term that defines a script?

Interpreted program

What is one of IT's roles in globalization?

It allows companies to reach a wider customer base.

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

Machine

Which low-level language corresponds one-to-one with assembly?

Machine language

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

Open Source Code

Which of these is NOT a category of risk in a project?

Risk in deployment

Which one of these is NOT a operation for database queries?

Serve

Scope creep can impact the allocation of which of the following resources?

Time and capital

A departmental manager is creating a budget estimate for the upcoming year. The manager would like to determine whether that data will be available when the decisions for the next year have to be made. Which characteristics of valuable data is the manager considering?

Timely

In which generation were silicon chips first used in computers?

third generation

There are how many tiers of ISPs?

three