MIS Study Questions; 2
A DBMS makes the: a. physical database available for different logical views. b. logical database available for different analytic views. c. relational database available for different logical views. d. relational database available for different analytic views. e. physical database available for different analytic views.
a
A schematic of the entire database that describes the relationships in a database is called a(n): a. entity-relationship diagram. b. data dictionary. c. data analysis table. d. intersection relationship diagram. e. data definition diagram.
a
All of the following are issues with the traditional file environment except: a. inability to develop specialized applications for functional areas. b. data sharing. c. lack of flexibility in creating ad-hoc reports. d. data inconsistency. e. poor security.
a
In TCP/IP, IP is responsible for which of the following? a. Disassembling and reassembling packets during transmission b. Establishing an Internet connection between two computers c. Moving packets over the network d. Sequencing the transfer of packets e. Breaking messages down into packets
a
In a relational database, a record is referred to in technical terms as a(n): a. tuple. b. field. c. key. d. table. e. entity.
a
Infrastructure-as-a-Service (IaaS): a. is one type of cloud computing service where users pay only for the computing capacity they actually use. b. is a cloud-based service which provides software applications to users on demand. c. is a cloud-based service that provides a platform for software development. d. provides users with a service-oriented architecture for their systems. e. provides cloud users with ubiquitous networking environment.
a
On which of the following protocols is the Internet based? a. TCP/IP b. FTP c. IMAP d. HTTP e. DNS
a
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. Lack of flexibility b. Lack of data sharing c. Program-data dependence d. Data redundancy e. Poor security
a
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
The marketplace for computer hardware: a. has become increasingly concentrated in top firms. b. has expanded to include a wide variety of start-up and mobile-computing firms. c. has moved significantly to Asian firms. d. has been decimated by mobile and cloud computing. e. has begun moving away from blade servers
a
Which of the following is a DBMS for desktop computers? a. Microsoft Access b. Microsoft Exchange c. Oracle Database d. DB2 e. Microsoft SQL Server
a
Which of the following is a multitasking, multiuser, operating system developed by Bell Laboratories that operates on a wide variety of computing platforms? a. Unix b. Linux c. OS X d. COBOL e. DOS
a
Which of the following is a specialized language that programmers use to add and change data in the database? a. Data manipulation language b. DBMS c. Data access language d. Data definition language e. Structured query language
a
Which of the following is an example of a legacy system? a. Transaction processing system running on a mainframe b. Scalable grid computing system c. Web services running on a cloud computing platform d. MDM software e. Quantum computing system
a
Which of the following is not an IT infrastructure service component? a. Operating system software b. Computing platforms to provide a coherent digital environment c. Physical facilities management to manage the facilities housing physical components d. IT management services to plan and develop the infrastructure and provide project management e. IT education services that provide training to employees
a
Which of the following is the most prominent data manipulation language today? a. SQL b. Crystal Reports c. Access d. NoSQL e. DB2
a
Which of the following types of computing involves purchasing computing power from a remote provider and paying only for the computing power used? a. On-demand b. Grid c. Edge d. Autonomic e. Quantum
a
_______ 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. Law of scalability d. Law of outsourcing e. Law of networks
a
Which of the following became the standard PC in the Personal Computer Era? a. Wintel PC b. DOS PC c. MITS PC d. Altair e. Apple II
a.
A field identified in a record as holding the unique identifier for that record is called the: a. primary field. b. key field. c. primary key. d. unique ID. e. key attribute.
b
A field identified in a table as holding the unique identifier of the table's records is called the: a. primary field. b. primary key. c. primary entity. d. key field. e. unique ID.
b
In a multi-tiered 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
Microsoft SQL Server is a(n): a. DBMS for mobile devices. b. DBMS for midrange computers. c. DBMS for both desktops and mobile devices. d. Internet DBMS. e. desktop relational DBMS.
b
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. 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
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: a. data cleansing. b. normalization. c. data defining. d. optimization. e. data scrubbing.
b
The select operation: a. creates a subset consisting of rows in a table. b. creates a subset consisting of all records in the file that meet stated criteria. c. combines relational tables to provide the user with more information than is otherwise available. d. identifies the table from which the columns will be selected. e. creates a subset consisting of columns in a table.
b
The term big data refers to all of the following except: a. data from Web traffic b. datasets with fewer than a billion records. c. datasets with unstructured data. d. machine-generated data (i.e. from sensors). e. data created by social media (i.e. tweets, Facebook Likes).
b
Which of the following enables a DBMS to reduce data redundancy and inconsistency? a. Ability to couple program and data b. Ability to minimize isolated files with repeated data c. Use of a data dictionary d. Ability to create two-dimensional tables e. Ability to enforce referential integrity
b
Which of the following is a grouping of characters into a word, a group of words, or a complete number? a. Table b. Field c. File d. Entity e. Tuple
b
Which of the following is a recent addition to the mobile digital platform? a. Quantum computing devices b. Wearable computing devices c. Cloud computing devices d. Grid computing devices e. Green computing devices
b
Which of the following is not one of the benefits of a blockchain database? a. It allows administrators to manage data more effectively. b. It prevents data from being altered retroactively. c. It enables firms to create and verify translations on a network very rapidly. d. It provides users with an integrated view of the data. e. It enables the ability to use relational databases.
b
Which of the following is the best description of a protocol in a telecommunications network architecture? a. A device that handles the switching of voice and data in a local area network b. A standard set of rules and procedures for control of communications in a network c. A communications service for microcomputer users d. The main computer in a telecommunications network e. A pathway through which packets are routed
b
Which of the following is the most popular mobile operating system? a. Linux b. Android c. Chrome OS d. iOS e. Unix
b
_______ 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
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with: a. one short mark. b. a crow's foot. c. a crow's foot topped by a short mark. d. three short marks. e. two short marks.
c
Microsoft Access's data dictionary displays all of the following information about a field except the: a. description of the field. b. type of the field. c. the organization within the organization that is responsible for maintaining the data. d. format of the field. e. size of the field.
c
Specifications that establish the compatibility of products and the ability to communicate in a network are called: a. network standards. b. telecommunications standards. c. technology standards. d. Internet standards. e. compatibility standards.
c
The Internet is based on which three key technologies? a. TCP/IP, HTML, and HTTP b. TCP/IP, HTTP, and packet switching c. Client/server computing, packet switching, and the development of communications standards for linking networks and computers d. Client/server computing, packet switching, and HTTP e. Email, instant messaging, and newsgroups
c
The join operation: a. organizes elements into segments. b. creates a subset consisting of columns in a table. c. combines relational tables to provide the user with more d. information than is otherwise available. d. identifies the table from which the columns will be selected. e. creates a subset consisting of rows in a table.
c
Today's computer transistors are roughly equivalent in size to: a. the width of a fingernail. b. a human hair. c. a virus. d. several atoms. e. a grain of sand.
c
What are the four layers of the TCP/IP reference model? a. Physical, Application, Transport, and Network Interface b. Physical, Application, Internet, and Network Interface c. Application, Transport, Internet, and Network Interface d. Application, Hardware, Internet, and Network Interface e. Software, Hardware, Network Interface, Internet
c
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? a. Data accuracy b. Data redundancy c. Data inconsistency d. Data duplication e. Data normalization
c
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? a. Cloud computing b. Autonomic computing c. Virtualization d. Multicore processing e. Ubiquitous computing
c
Which of the following is a device that sends packets of data through different networks assuring they go to the correct address? a. Hub b. Switch c. Router d. NIC e. Modem
c
Which of the following is not a characteristic of packet switching? a. Packets travel independently of each other. b. Packets are routed through many different paths. c. Packet switching requires point-to-point circuits. d. Packets include data for checking transmission errors. e. Packets are reassembled into the original message when they reach their destinations.
c
Which of the following is not an example of a wearable computing device? a. Smartwatch b. Smart glasses c. Smartphones d. Activity trackers e. Smart ID badges
c
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? a. TCP/IP b. COBOL c. Ethernet d. ASCII e. Linux
c
Which of the following occurs when the same attribute in related data files has different values? a. Data duplication b. Data dependence c. Data inconsistency d. Data redundancy e. Data discrepancy
c
a database _______ describes a database entity a. byte b. field c. record d. value e. file
c
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. multi-tiered client/server architecture. d. two-tiered client/server architecture. e. divided architecture.
d
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
All of the following are current hardware platform trends except: a. green computing. b. virtualization. c. cloud computing. d. Unix. e. quantum computing.
d
DBMSs typically include report generating tools in order to: a. retrieve and display data. b. analyze the database's performance. c. perform predictive analysis. d. display data in a more structured and polished format than would be possible just by querying. e. display data in graphs.
d
Data ________ occurs when the same data is duplicated in multiple files of a database. a. discrepancy b. independence c. partitions d. redundancy e. repetition
d
In a table for customers, the information about a single customer resides in a single: a. field. b. column. c. entity. d. row. e. table.
d
The Windows Operating System: a. was an early PC operating system. b. is used on virtually all tablet and mobile devices today. c. is a data management application used on PCs. d. is an operating system used on most Wintel PCs throughout the world. e.is a web-based operating system for the Internet era.
d
The logical view of a database: a. includes a digital dashboard. b. enables users to manipulate the logical structure of the database. c. displays the organization and structure of data on the physical storage media. d. presents data as they would be perceived by end users. e. allows the creation of supplementary reports.
d
The telephone system is an example of a ________ network. a. peer-to-peer b. wireless c. packet-switched d. circuit-switched e. client/server
d
Which of the following best illustrates the relationship between entities and attributes? a. The entity PURCHASE with the attribute CUSTOMER b. The entity PRODUCT with the attribute PURCHASE c. The entity PRODUCT with the attribute CUSTOMER d. The entity CUSTOMER with the attribute PURCHASE e. The entity CUSTOMER with the attribute PRODUCT
d
Which of the following is not an example of the mobile digital platform? a. Tablets b. Kindle c. Cell phones d. CRM e. Smartwatches
d
_______ creates confusion that hampers the creation of information systems that integrate data from different sources a. data quality b. online processing c. data independence d. data redundancy e. batch processing
d
A characteristic or quality that describes a particular database entity is called a(n): a. relationship. b. key field. c. field. d. tuple. e. attribute.
e
A(n) ________ represent data as two-dimensional tables. a. mobile DBMS b. object-oriented DBMS c. hierarchical DBMS d. non-relational DBMS e. relational DBMS
e
All of the following are typically factors in a firm's decision to engage consulting and system integration services except: a. the firm does not have the staff necessary to deploy and maintain the firm's IT infrastructure. b. the firm's staff do not have the skills necessary to deploy and maintain the firm's IT infrastructure. c. The firm does not have the budget to deploy and maintain a firm's IT infrastructure. d. The firm's staff does not have the necessary experience to deploy and maintain the firm's IT infrastructure. e. The firm's staff knows more about the firm's IT infrastructure than service providers.
e
At what percent of capacity do most servers operate? a. 100% b. 80-90% c. Approximately 70 percent d. 40-50% e. 15-20%
e
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. where, from, and join. d. where, find, and select. e. select, project, and join.
e
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
The ability to be in multiple states at once, dramatically increasing processing power, is a hallmark of: a. colocation. b. edge computing. c. grid computing. d. utility computing. e. quantum computing.
e
The development of TCP/IP occurred during the ________ era. a.cloud and mobile computing b. general-purpose mainframe and minicomputer c. client/server era d. personal computer e. mainframe
e
The project operation: a. combines relational tables to provide the user with more information than is otherwise available. b. organizes elements into segments. c. identifies the table from which the columns will be selected. d. creates a subset consisting of rows in a table. e. creates a subset consisting of columns in a table.
e
Which of the following factors does not help explain why computing resources today are even more available than in previous decades? a. Network economics b. Law of mass digital storage c. Moore's law d. Declining communications costs and the Internet e. Widespread rejection of technology standards
e
Which of the following involves slicing digital messages into parcels, transmitting them along different communication paths, and reassembling them at their destinations? a. Multiplexing b. Packet shifting c. Packet routing d. ATM e. Packet switching
e
Which of the following is a leading networking hardware provider? a. Dell b. Intel c. Seagate d. IBM e. Cisco
e
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 table b. Relationship dictionary c. Entity-relationship diagram d. Data definition diagram e. Data dictionary
e
Which of the following is not a part of the IT infrastructure ecosystem found in firms? a. Consultant and system integrators b. Internet platforms c. Operating system platforms d. Enterprise software applications e. Virtual reality systems
e
Which type of infrastructure service stores and manages corporate data and provides capabilities for analyzing the data? a. networking b. telephone c. VOIP d. telecommunitcations e. data management
e
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. City b. Address c. Day d. State e. Airport code
e
It is much harder to eliminate a cloud service than to remove functionality from a company's core internal systems.
false
t/f The operating system is used to manage the software applications used in business activities.
false
t/f: CGI is a DBMS programming language that end users and programmers use to manipulate data in the database.
false
t/f: IT infrastructure consists of only those physical computing devices and software required to operate the enterprise.
false
t/f: In N-tier computing, significant parts of website content, logic, and processing are performed by a single web server.
false
t/f: Microsoft is no longer the market leader in client/server networking.
false
t/f: Mobile computing is the fastest growing form of computing.
false
t/f: NoSQL technologies are used to manage sets of data that require the flexibility of tables and relations.
false
t/f: Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.
false
t/f: The logical and physical views of data are combined into a single view in a DBMS.
false
t/f: Web hosting services maintain a series of servers and provide fee-paying subscribers with space to maintain their websites.
false
Enterprise infrastructure requires software that can link disparate applications and enable data to flow freely among different parts of the business.
true
t/f: A physical view shows data as it is actually organized and structured on the data storage media.
true
t/f: A web server is responsible for locating and managing stored webpages.
true
t/f: An application server may reside on the same computer as a web server or on its own dedicated computer.
true
t/f: Client/server computing is a primary example of decentralized processing.
true
t/f: Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.
true
t/f: DBMS have a data definition capability to specify the structure of the content of the database.
true
t/f: Every record in a file should contain at least one key field.
true
t/f: Exponential growth in the number of transistors and the power of processors is expected to decrease in the foreseeable future.
true
t/f: In financial services firms, investments in IT infrastructure represent more than half of all capital invested.
true
t/f: 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
t/f: a record is a group of related fields
true
