Chapter 5&6 Information Systems

Which company controls the mainframe market? 1) Dell 2) IBM 3) Cisco 4) Oracle 5) HP

2) IBM

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? A) Data dictionary B) Data definition diagram C) Entity-relationship diagram D) Relationship dictionary E) Data table

A) Data dictionary

Which of the following statements about Hadoop is not true? A) Hadoop is proprietary software sold by the Apache Software Foundation. B) Hadoop runs on a cluster of inexpensive servers. C) Companies use Hadoop as for a staging area for unstructured and semistructured data before they are loaded into a data warehouse. D) Hadoop breaks a big data problem down into subproblems. E) Hadoop consists of several key services

A) Hadoop is proprietary software sold by the Apache Software Foundation.

Which of the following is not one of the benefits of a blockchain database? A) It enables the ability to use relational databases. B) It prevents data from being altered retroactively. C) It allows administrators to manage data more effectively. D) It enables firms to create and verify transactions on a network very rapidly. E) It provides users with an integrated view of the data.

A) It enables the ability to use relational databases.

________ states that the value or power of a network grows exponentially as a function of the number of network members. A) Metcalfe's Law B) Moore's Law C) The Law of Scalability D) The Law of Mass Digital Storage E) The Law of Networks

A) Metcalfe's Law

Which of the following is a multitasking, multiuser, operating system developed by Bell Laboratories that operates on a wide variety of computers from different manufacturers? A) Unix B) Wintel C) OS X D) COBOL E) DOS

A) Unix

Which of the following became the standard PC in the Personal Computer Era? A) Wintel PC B) Unix PC C) MITS PC D) Altair E) Apple Macintosh

A) Wintel PC

The introduction of the minicomputer: A) allowed computers to be customized to the specific needs of departments or business units. B) strengthened centralized computing. C) offered new, powerful machines at higher prices than mainframes. D) represented the rise of Microsoft. E) was dominated by IBM.

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

A common field that links two different tables and serves as a primary key to one of these tables is called the: A) foreign key. B) secondary key C) primary field. D) unique ID. E) primary entity.

A) foreign key.

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: A) normalization. B) data scrubbing. C) data cleansing. D) data defining. E) optimization.

A) normalization.

A DBMS makes the: A) physical database available for different logical views. B) relational database available for different logical views. C) physical database available for different analytic views. D) relational database available for different analytic views. E) logical database available for different analytic views.

A) physical database available for different logical views.

All of the following are technologies used to analyze and manage big data except: A) relational DBMS. B) NoSQL C) in-memory computing. D) analytic platforms. E) Hadoop.

A) relational DBMS.

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 5. Mainframe and Minicomputer. A) 5, 2, 3, 4, 1 B) 5, 4, 2, 3, 1 C) 4, 5, 2, 3, 1 D) 5, 4, 2, 1, 3 E) 4, 5, 3, 2, 1

B) 5, 4, 2, 3, 1

Which of the following is a specialized language that programmers use to add and change data in the database? A) Data access language B) Data manipulation language C) Database language D) Data definition language E) DBMS

B) Data manipulation language

________ creates confusion that hampers the creation of information systems that integrate data from different sources. A) Batch processing B) Data redundancy C) Data independence D) Online processing E) Data distribution

B) Data redundancy

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? A) Program-data dependence B) Lack of flexibility C) Poor security D) Lack of data sharing E) Data redundancy

B) Lack of flexibility

________ uses individual atoms and molecules to create computer chips and other devices. A) Virtualization B) Nanotechnology C) Quantum computing D) A minicomputer E) On-demand computing

B) Nanotechnology

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): A) SOA. B) SLA. C) TCO. D) RFQ. E) SaaS.

B) SLA. Service Level Agreement

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? A) Modality B) Scalability C) Expandability D) Disintermediation E) Customizability

B) Scalability

A household appliances manufacturer has hired you to help analyze its social media data sets to determine which of its refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data? A) Text mining tools B) Sentiment analysis software C) Web mining technologies D) Data mining software E) Data governance software

B) Sentiment analysis software

________ tools can be used to rapidly analyze large unstructured data sets, such as email, memos, and survey responses to discover patterns and relationships. A) OLAP B) Text mining C) In-memory D) Clustering E) Classification

B) Text mining

Which of the following best illustrates the relationship between entities and attributes? A) The entity CUSTOMER with the attribute PRODUCT B) The entity CUSTOMER with the attribute PURCHASE C) The entity PRODUCT with the attribute PURCHASE D) The entity PRODUCT with the attribute CUSTOMER E) The entity PURCHASE with the attribute CUSTOMER

B) The entity CUSTOMER with the attribute PURCHASE

Data mining allows users to: A) quickly compare transaction data gathered over many years. B) find hidden relationships in large databases. C) obtain online answers to ad-hoc questions in a rapid amount of time. D) summarize massive amounts of data into much smaller, traditional reports. E) access the vast amounts of data in a data warehouse.

B) find hidden relationships in large databases.

All of the following are issues with the traditional file environment except: A) data inconsistency. B) inability to develop specialized applications for functional areas. C) lack of flexibility in creating ad-hoc reports. D) poor security. E) data sharing

B) inability to develop specialized applications for functional areas.

A field identified in a record as holding the unique identifier for a record is called the: A) identifier key. B) key field. C) primary field. D) unique ID. E) key attribute.

B) key field.

In a relational database table for customers, the information about a single customer resides in a single: A) field. B) row. C) column. D) table. E) entity.

B) row.

In a multitiered network: A) the work of the entire network is centralized. B) the work of the entire network is balanced over several levels of servers. C) processing is split between clients and servers. D) processing is handled by multiple, geographically-remote clients. E) processing is located in the cloud.

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

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

B) unstructured and structured data that has not been analyzed.

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? A) Address B) City C) Airport code D) State E) Day

C) Airport code

Which of the following is the network standard for connecting desktop computers into local area networks that enabled the wide spread adoption of client/server computing and local area networks and further stimulated the adoption of personal computers? A) TCP/IP B) COBOL C) Ethernet D) ASCII E) Linux

C) Ethernet

Which of the following is not one of the techniques used in web mining? A) Content mining B) Structure mining C) Server mining D) Usage mining E) Data mining

C) Server mining

A schematic of the entire database that describes the relationships in a database is called a(n): A) data dictionary. B) intersection relationship diagram. C) entity-relationship diagram. D) data definition diagram. E) data analysis table.

C) entity-relationship diagram.

A distributed database: A) uses predictive analysis. B) uses SQL. C) is a database that is stored in multiple physical locations. D) is a database that is distributed across many business firms. E) uses Hadoop to process information.

C) is a database that is stored in multiple physical locations.

A database ________describes a database entity. A) byte B) field C) record D) value E) file

C) record

A(n) ________ represent data as two-dimensional tables. A) non-relational DBMS B) mobile DBMS C) relational DBMS D) hierarchical DBMS E) object-oriented DBMS

C) relational DBMS

In a relational database, the three basic operations used to develop useful sets of data are: A) select, project, and where. B) select, join, and where. C) select, project, and join. D) where, from, and join. E) where, find, and select.

C) select, project, and join.

Which of the following is a grouping of characters into a word, a group of words, or a complete number? A) File B) Table C) Entity D) Field E) Tuple

D) Field

Which of the following technologies would you use to analyze the social media data collected by a major online retailer? A) OLAP B) Data warehouse C) Data mart D) Hadoop E) DBMS

D) Hadoop

Which of the following is a DBMS for desktop computers? A) DB2 B) Oracle Database C) Microsoft SQL Server D) Microsoft Access E) Microsoft Exchange

D) Microsoft Access

A(n) ________ is used to communicate between a user and an organization's back-end systems. A) public server B) private server C) legacy server D) application server E) blade server

D) application server

A client computer networked to a server computer, with processing split between the two types of machines, is called a(n): A) service-oriented architecture. B) on-demand architecture. C) multitiered client/server architecture. D) two-tiered client/server architecture. E) divided architecture.

D) two-tiered client/server architecture.

Which model can be used to analyze the direct and indirect costs to help firms determine the actual cost of specific technology implementations? A) Supply and demand B) Return on investment C) Breakeven point D) Cost-benefit analysis E) Total cost of ownership

E) Total cost of ownership

Which of the following is not a technology driver transforming IT infrastructure? A) Network economics B) Law of Mass Digital Storage C) Moore's Law D) Declining communications costs and exponential growth in the size of the Internet E) Widespread rejection of technology standards

E) Widespread rejection of technology standards

________ provides a standard format for data exchange, enabling web services to pass data from one process to another. A) HTML B) HTML5 C) Java D) Chrome OS E) XML

E) XML

Interpretations of Moore's law assert that: A) computing power will eventually level off. B) transistors decrease in size 50% every two years. C) data storage costs decrease by 50% every 18 months. D) PCs decrease in market share by 9% every 5 years. E) computing power doubles every 18 months.

E) computing power doubles every 18 months.

During which era did business firms begin seriously to use TCP/IP? A) cloud and mobile computing B) general-purpose main frame and minicomputer C) client/server D) personal computer E) enterprise computing

E) enterprise computing

The logical view of a database: A) displays the organization and structure of data on the physical storage media. B) includes a digital dashboard. C) allows the creation of supplementary reports. D) enables users to manipulate the logical structure of the database. E) presents data as they would be perceived by end users.

E) presents data as they would be perceived by end users.

OLAP enables: A) users to obtain online answers to ad-hoc questions in a rapid amount of time. B) users to view both logical and physical views of data. C) programmers to quickly diagram data relationships. D) programmers to normalizedata. E) users to quickly generate reports using multidimensional views of data.

E) users to quickly generate reports using multidimensional views of data.

A query is a request for data from a database. TRUE or FALSE

TRUE

NoSQL technologies are useful for accelerating simple queries against large volumes of structured and unstructured data. TRUE or FALSE

TRUE

Program-data dependence refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data. TRUE or FALSE?

TRUE

A web server is responsible for locating and managing stored web pages. True or False?

True

Enterprise infrastructure requires software that can link disparate applications and enable data to flow freely among different parts of the business. True or False?

True

Today, many business firms continue to operate legacy systems because they meet a business need and would be costly to replace. True or False?

True

Whereas HTML is limited to describing how data should be presented in the form of web pages, XML can perform presentation, communication, and data storage tasks. True or False?

True