Unit 2

Hardware and software acquisition costs account for about ________ percent of TCO.

20

Place the following eras of IT infrastructure evolution in order, from earliest to most recent: 1. Cloud Computing Era; 2. Client/Server; 3. Enterprise Era; 4. Personal Computer; and 5. Mainframe and Minicomputer.

54231

which of the following statements about 5G is true

5G will be able to transmit data in the gigabit range

A DBMS makes the:

A) physical database available for different logical views.

You are creating a database to store temperature and wind data from various airports. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

Airport code

Which of the following is the most popular mobile operating system?

Android

Firms that allow employees to use their own devices are embracing which of the following?

BYOD

Which of the following enables you to create a script that allows a web server to communicate with a back-end database?

CGI

Leading network hardware provider

CISCO

Which of the following is not an example of the mobile digital platform?

CRM

The select operation A) combines relational tables to provide the user with more information than is otherwise available. B) creates a subset consisting of columns in a table. C) identifies the table from which the columns will be selected. D) creates a subset consisting of all records in the file that meet stated criteria.

Creates a subset consisting of all records in the file that meet stated criteria

Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?

Data inconsistency

In a large organization, which of the following functions would be responsible for policies and procedures for managing internal data resources? A) Data administration B) Database administration C) Information policy administration D) Data auditing E) Database management

Database administration

Which of the following is the network standard for connecting desktop computers into local area networks that enabled the widespread adoption of client/server computing and local area networks and further stimulated the adoption of personal computers?

Ethernet

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

Hadoop

Which of the following is a DBMS for desktop computers?

Microsoft Access

MongoDB and SimpleDB are both examples of:

NoSQL databases

MongoDB and SimpleDB are both examples of: A) open source databases. B) SQL databases. C) NoSQL databases. D) cloud databases. E) big data databases.

NoSQL databases

Which of the following is not an IT infrastructure service component?

Operation system software

Which of the following is not one of the characteristics of cloud computing, as defined by the U.S. National Institute of Standards and Technology?

Reduced elasticity

A formal contract between customers and their service providers that outlines the specific responsibilities of the service provider and to the customer is called a(n):

SLA

Which of the following refers to a set of self-contained services that communicate with each other to create a working software application?

SOA

A household appliances manufacturer has hired you to help analyze its social media datasets to determine which of its refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

Sentiment Analysis software

In data mining, which of the following involves events linked over time?

Sequences

________ tools are used to analyze large unstructured data sets, such as email, memos, and survey responses to discover patterns and relationships.

Text mining

Which of the following best illustrates the relationship between entities and attributes?

The entity PRODUCT with the attribute PURCHASE

All of the following are typically factors in a firm's decision to engage consulting and system integration services except:

The firm's staff knows more about the firm's IT infrastructure than service providers.

Microsoft Access's data dictionary displays all of the following information about a field except the: description of the field. size of the field. format of the field. type of the field. the organization within the organization that is responsible for maintaining the data.

The organization within the organization that is responsible for maintaining the data

In a multi-tiered network:

The work of the entire network is balanced over several levels of servers.

Which of the following is an example of a legacy system? Scalable grid computing system Transaction processing system running on a mainframe Quantum computing system Web services running on a cloud computing platform MDM software

Transaction processing system running on a mainframe

All of the following are current hardware platform trends except:

Unix

All of the following are current hardware platform trends except: quantum computing. virtualization. cloud computing. Unix. green computing.

Unix

Which of the following is a multitasking, multiuser, operating system developed by Bell Laboratories that operates on a wide variety of computing platforms?

Unix

Which of the following is not a part of the IT infrastructure ecosystem found in firms?Consultant and system integratorsOperating system platformsInternet platformsVirtual reality systemsEnterprise software applications

Virtual Reality Systems

Which of the following became the standard PC in the Personal Computer Era?

Wintel PC

Which of the following is the foundation technology for web services?

XML

________ provides a standard format for data exchange, enabling web services to pass data from one process to another.

XML

Running a Java program on a computer requires:

a Java Virtual Machine to be installed on the computer.

ZipRealty, which combines Google Maps with real estate data, is an example of: cloud computing

a mashup

Two-factor authentication utilizes a(n):

a multistep process of authentication

Today's computer transistors are roughly equivalent in size to:

a virus

The introduction of the minicomputer

allowed computers to be customized to the specific needs of departments or business units.

Linux is:

an example of open-source software.

A(n) ________ is used to communicate between a user and an organization's back-end systems

application server

A(n) ________ is used to communicate between a user and an organization's back-end systems.

application server

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases?

application server software

A characteristic or quality that describes a particular database entity is called a(n): A) field. B) tuple. C) key field. D) attribute. E) relationship.

attribute

A software program with a graphical user interface for displaying web pages and for accessing the web and other Internet resources is called a web:

browser

in data mining, which of the following involves recognizing patterns that describe the group to which an item belongs by examining existing items and inferring a set of rules?

classifications

You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use the data mining software you are using to do which of the following?

classify data

All of the following are technologies used to analyze and manage big data except:

cloud computing

The join operation:

combines relational tables to provide the user with more information than is otherwise available.

interpretations of Moore's law assert that:

computing power doubles every 18 months

The select operation:

creates a subset consisting of all records in the file that meet stated criteria.

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security?

data dictionary

Which type of infrastructure service stores and manages corporate data and provides capabilities for analyzing the data?

data management

In a large organization, which of the following functions would be responsible for physical database design and maintenance?

database administration

A schematic of the entire database that describes the relationships in a database is called a(n):

entity-relationship diagram

Which of the following is a grouping of characters into a word, a group of words, or a complete number?

field

Data mining allows users to:

find hidden relationships in data

Which of the following involves practices and technologies to minimize the environmental effects of manufacturing and managing computing devices?

green computing

The marketplace for computer hardware:

has become increasingly concentrated in top firms.

SaaS refers to:

hosting and managing access to software applications delivered over the Internet to clients on a subscription basis.

A distributed database:

is a database that is stored in multiple physical locations

The Windows Operating System:

is an operating system used on most Wintel PCs throughout the world

Infrastructure as a Service (IaaS)

is one type of cloud computing service where users pay only for the computing capacity they actually use.

A field identified in a table as holding the unique identifier of the table's records is called the:

key field

The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues with traditional file systems?

lack of flexibility

The development of TCP/IP occurred during the ________ era

mainframe

A(n) ________ is an integrated circuit which contains two or more processors to enhance performance and reduce power consumption.

multicore processor

Which of the following is not one of the current software platform trends? Multicore processors Software outsourcing Open-source software HTML5 Web services and service-oriented architecture

multicore processors

Which of the following is not one of the current software platform trends? Open-source software HTML5 Software outsourcing Web services and service-oriented architecture Multicore processors

multicore processors

Which of the following is not one of the techniques used in web mining?

server mining

Which of the following is not an example of a wearable computing device?

smartphones

Prewritten, commercially available sets of software programs that eliminate the need for a firm to write its own software programs for certain functions, are referred to as

software mashups

________ are created by combining and customizing components from different online software applications.

web mashups

Sets of loosely coupled software components that exchange information with each other using standard web communication standards and languages are referred to as:

web services

Which of the following would you use to find patterns in user interaction data recorded by a web server?

web usage mining

_______ uses individual atoms and molecules to create computer chips and other devices.

nanotechnology

In the context of data relationships, the term associations refers to:

occurrences linked to a single event

Which of the following types of computing involves purchasing computing power from a remote provider and paying only for the computing power used?

on-demand

The ability to be in multiple states at once, dramatically increasing processing power, is a hallmark of:

quantum computing

The ability to be in multiple states at once, dramatically increasing processing power, is a hallmark of: edge computing. colocation. utility computing. quantum computing. grid computing.

quantum computing

All of the following are specific security challenges that threaten the communications lines in a client/server environment except: theft and fraud. radiation. phishing tapping. sniffing.

radiation

A database ________ describes a database entity. file value byte field record

record

In a table for customers, the information about a single customer resides in a single:

row

Which of the following refers to the ability of a computer, product, or system to expand to serve a larger number of users without breaking down?

scalability

In a relational database, the three basic operations used to develop useful sets of data are:

select, project, and join

Specifications that establish the compatibility of products and the ability to communicate in a network are called:

technology standards

Microsoft Access's data dictionary displays all of the following information about a field except the:

the organization within the organization that is responsible for maintaining the data

Which model can be used to analyze the direct and indirect costs to help firms determine the actual cost of specific technology implementations?

total cost ownership

In a relational database, a record is referred to in technical terms as a(n):

tuple

A client computer networked to a server computer, with processing split between the two types of machines, is called a(n):

two-tiered client/server architecture

A data lake is composed of: historical data from legacy systems. internal and external data sources. historic and current internal data. historic external data. unstructured and structured data that has not been analyzed.

unstructured and structured data that has not been analyzed.

Which of the following is not a part of the IT infrastructure ecosystem found in firms? Internet platforms

virtual reality systems

Which of the following enables a single physical resource (such as a server or a storage device) to appear to the user as multiple logical resources?

virtualization

All of the following are cloud computing services except:

virtualization as a service

All of the following are cloud computing services except: virtualization as a service. platform as a service. on-demand computing. software as a service. infrastructure as a service.

virtualization as a service