Management Information System Exam 2 (Chapters 6, 7, 8)
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:
A mashup
Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large datasets are referred to as:
Analytic platforms
Which of the following is an open-source operating system designed for mobile devices?
Android
Software used to apply the computer to a specific task for an end user is called:
Application software
A characteristic or quality describing an entity is called a(n):
Attribute
The smallest unit of data a computer can handle is called a:
Bit
Which of the following is a type of optical disc storage?
CD-ROM
Virtualization:
Can boost server utilization rates to 70% or higher
Which of the following is considered to be the fastest growing form of computing?
Cloud computing
The main challenge coming to Microsoft's Office software suite will be:
Cloud-based productivity software such as Google Docs and Google Apps
The select operation:
Creates a subset consisting of all records in the file that meet stated criteria
The project operation:
Creates a subset consisting of columns in a table
Software that organizes, manages, and processes business data, such as data concerned with inventory, customers, and vendors, is called:
Data management software
A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system.
Data quality audit
The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.
Data redundancy
A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS.
Database server
Which type of software provides more control over text and graphic placement in the layout of a page than word processing software?
Desktop publishing software
DBMS typically include report-generating tools in order to:
Display data in an easier-to-read-format
The use of multiple computers linked by a communications network for processing is called:
Distributed processing
A schematic of the entire database that describes the relationships in a database is called a(n):
Entity-relationship diagram
A SaaS provider maintains a large web server, or series of servers, and provides fee-paying subscribers with space to maintain their websites.
FALSE
A grouping of characters into a word, a group of words, or a complete number is called a record.
FALSE
A mainframe is a type of legacy workstation
FALSE
Application server software is responsible for locating and managing stored web pages.
FALSE
Client/server computing is the most widely used form of centralized processing.
FALSE
Today, most system and application software is custom built by in-house programmers.
FALSE
Using an online storage service such as DropBox is a type of virtualization.
FALSE
XML is limited to describing how data should be presented in the form of web pages, while HTML can perform presentation, communication, and storage of data.
FALSE
Which of the following is an example of a company whose business model is based on access to large databases through the web?
Which of the following is not an example of the consumerization of IT?
Data mining is a tool for allowing users to:
Find hidden relationships in data
________ describes the practices and technologies used to minimize the environmental effects of manufacturing and managing computing devices.
Green computing
Connecting geographically remote computers in a single network to create a "virtual supercomputer" is called:
Grid computing
All of the following are features of smartwatches except a(n):
Gyrometer
In a ________ computing model, companies use their own infrastructure for essential computing tasks and adopt public cloud computing for less critical operations or additional processing during peak business periods.
Hybrid cloud
A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:
In two short marks
What type of device gathers data and converts them into electronic form for use by the computer?
Input device
Common data quality problems include all of the following except:
Internet connectivity problems
Which of the following statements is not true about cloud computing?
It removes the concern about data and systems security for businesses
Connecting geographically remote computers in a single network to create a "virtual supercomputer" is called:
Java
Which of the following is not a type of output device?
Keyboard
Which of the following statements about Linux is not true?
Linux is the primary OS used in quantum computing
Which of the following storage technology stores data sequentially?
Magnetic tape
Software applications that combine different components of online software applications are referred to as:
Mashups
In clustering, a data mining tool will find:
New groupings within data
MongoDB and SimpleDB are both examples of:
NoSQL databases
In terms of the data relationships found by data mining, associations refers to:
Occurrences linked to a single event
You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?
One-to-one
Which of the following is not an essential characteristic of cloud computing?
Open source software
________ is free software created and updated by a worldwide community of programmers.
Open-source software
Hadoop is a(n):
Open-source software framework designed for distributing data-processing over inexpensive computers
A DBMS makes the:
Physical database available for different logical views
MySQL is a:
Popular open-source DBMS
Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.
Referential integrity rules
Links coming out of an online document are a sign of:
Richness or variety of topics covered
In a table for customers, the information about a single customer would reside in a single:
Row
Which of the following is a high-speed network dedicated to storage that connects different kinds of storage devices, such as tape libraries and disk arrays so they can be shared by multiple servers?
SAN
A(n) ________ is a set of self-contained services that communicate with each other to create a working software application.
SOA
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
Which of the following devices collects data directly from the environment for input into a computer system?
Sensor
Which of the following types of computer would you use to support a computer network?
Server
All of the following are examples of wearable computing devices except:
Smartphones
Translating software to different languages is commonly referred to as:
Software localization
Which of the following software tools would you use to prepare a break-even analysis?
Spreadsheet
Microsoft Excel is an example of:
Spreadsheet software
The primary storage technologies are:
Storage networks, magnetic tape, magnetic disk, and optical disk.
What is the purpose of a DBMS's data definition function?
Structuring the database
Which of the following types of computer is used for weather forecasting on a national or worldwide scale?
Supercomputer
Software that manages the resources of the computer is called:
System software
A computer language translation program is an example of system software.
TRUE
A firm's IT infrastructure provides the foundation for supporting all the information systems in the business.
TRUE
A physical view shows data as it is organized on the storage media.
TRUE
A private cloud is operated for the benefit of a single organization but may be managed by a third party and located off premises.
TRUE
A software package for a mainframe usually requires a programmer to install it.
TRUE
Both Oracle and Microsoft Access use SQL to retrieve information from a database.
TRUE
DBMS simplify how end users work with databases by separating the logical and physical views of the data.
TRUE
End users use a data manipulation language to manipulate data in the database.
TRUE
Every record in a file should contain at least one key field.
TRUE
Google Apps is an example of SaaS.
TRUE
HTML specifies how text, graphics, video, and sound are placed on a document.
TRUE
HTML5 is the latest evolution of HTML, and is designed to make it much easier to embed third-party add-ons in web pages.
TRUE
In cloud computing, rapid elasticity refers to the ability of computing resources to be quickly obtained, increased, or decreased to meet demand.
TRUE
Nanotechnology uses individual atoms and molecules to create computer chips and other devices that are thousands of times smaller than current technologies permit.
TRUE
SOA is a set of self-contained web services that communicate with each other to create a working software application.
TRUE
Systems integration means ensuring the legacy systems work with new elements of the infrastructure.
TRUE
Web browsers are the primary interface for accessing the Internet
TRUE
Web services can exchange information between two different systems regardless of the operating system or programming languages on which the systems are based.
TRUE
XML provides a standard format for data exchange, enabling web services to pass data from one process to another
TRUE
Which of the following statements about client/server computing is not true?
The bulk of processing occurs on the client
In a multitiered 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?
Transaction processing system running on a mainframe
A client computer networked to a server computer, with processing split between the two types of machines, is called a(n) ________ architecture.
Two-tiered client/server
Which of the following is a visual programming tool and environment for creating applications that run on Microsoft Windows operating systems?
Visual Basic
The ability of a person booking a flight on Southwest.com's website to reserve a car from Dollar Rent-A-Car without having to leave the airline's website is an example of the usage by Dollar Rent-A-Car and Southwest Airlines of which of the following?
Web services
The toy manufacturer you work for wants to exchange data with a chain of toy stores in order to improve its distribution and speed to market. The toy stores use different software than your firm. Which of the following tools or technologies presents the best solution?
Web services
Which of the following would you use to find patterns in user interaction data recorded by web servers?
Web usage mining
What would be a reason for using a workstation rather than a personal computer?
When you need more powerful computational abilities
What is the foundation technology for web services?
XML
