MIS 362 Exam 1

T/F: A collection of data fields that are all related to one object, activity, or individual is called a file.

False

T/F: A redundant array of independent/inexpensive disks (RAID) is a method of storing data so that data can be accessed more quickly.

False

T/F: A tablet computer is a low-cost, centrally managed computer with no internal or external attached drives for data storage.

False

T/F: An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

False

T/F: DBMSs are used primarily for modeling data.

False

T/F: If 10 users can run programs at the same time on the same computer, it is known as multi-tasking.

False

T/F: Proprietary software is mass-produced by software vendors to address needs that are common across businesses, organizations, or individuals.

False

T/F: Software as a Service (SaaS) refers to the use of computing resources, including software and data storage, on the Internet rather than local computers.

False

T/F: Suppose your friend, who is a small business owner, wants to computerize her business functions such as accounting, payroll, and inventory management. She would need to purchase separate software to meet each functional requirement.

False

T/F: Systems software consists of programs that help users solve particular computing problems.

False

T/F: The cost of performing data cleansing is lower than data validation

False

T/F: Thin client computers are a type of portable single-user computers.

False

T/F: When making hardware decisions, the overriding considerations of a business should be technology cost and currency.

False

T/F: Windows 10 is an example of application software.

False

T/F: An embedded system is a computer system that is implanted in and dedicated to the control of another device.

True

T/F: An operating system is a set of programs that controls the computer hardware and acts as an interface with applications.

True

T/F: If "color" is an attribute, then "green" is a data item.

True

T/F: The operating system's application programming interface (API) provides software developers with tools they use to build application software without needing to understand the inner workings of the operating system and hardware.

True

T/F: Virtual tape technology can decrease data access time, lower the total cost of ownership, and reduce the amount of floor space consumed by tape operations.

True

Which is an example of a many to many relationship a. Class and Students b. Customers and orders c. Faculty teaching several classes, but a class taught by one faculty d. B and C only e. All of the above

a. Class and Students

Which statement is true? a. Compiled programs run faster than interpreted programs b. Compiled programs require less memory than interpreted programs c. Compilers display syntax errors immediately d. All of the above

a. Compiled programs run faster than interpreted programs

A _____ is a climate-and-access-controlled building or a set of buildings that houses the computer hardware that delivers an organization's data and information services. a. data mart b. data warehouse c. data center d. data mine

a. data mart

Kyle works for National Sporting Goods, where he manages critical data elements, such as identifying and acquiring new data sources, creating consistent reference data, and analyzing data for quality. Kyle is a _______. a. data steward b. data administrator c. database administrator d. data manager

a. data steward

A _____ is a simple database program whose records have no relationship to one another. a. flat file b. schema c. relational system d. user view

a. flat file

_____ is a program concerned with the efficient and environmentally responsible design, manufacture, operation, and disposal of IS-related products. a. Green computing b. Grid computing c. Cloud computing d. Utility computing

a. green computing

Which of the following types of credit cards is currently diminishing in popularity and being replaced by the other three types? a. magnetic stripe b. chip card c. smart card d. contactless payment card

a. magnetic stripe

A collection of fields all related to a single object, activity, or individual is a(n) _____. a. record b. file c. attribute d. character

a. record

A type of memory whose contents are not lost if the power is turned off or interrupted is said to be _____. a. unarbitrary b. nonvolatile c. inaccessible d. nonadjacent

a. unarbitrary

You would use Query by Example, if _____. a. you wish to use a visual approach to query building b. you build a query from an example c. you use a template for reports d. wish teach SQL with examples

a. you wish to use a visual approach to query building

_____ is used to temporarily hold small units of program instructions and data immediately before, during, and after execution by the central processing unit (CPU). a. Main memory b. A register c. The control unit d. The motherboard

b. A register

Software as s Service (SaaS) a. Refers to the use of computing resources, including software and data storage, on the internet rather than on local computers. b. Allow businesses to subscribe to web delivered software by paying monthly service charge, or a per use fee. c. Refers to the use of data storage on the internet rather than on local computers. d. All of the above

b. Allow businesses to subscribe to web delivered software by paying monthly service charge, or a per use fee.

The structure of the database (schema) can be changed without affecting the sub-schema (user's view). This property is called a. Atomicity b. Data independence c. Data redundancy d. Data isolation

b. Data independence

With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet. a. Internet access b. Database as a Service c. Software as a Service d. Oracle

b. Database as a Service

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization. a. Data selecting b. Enterprise data modeling c. Data cleansing d. Social graph analysis

b. Enterprise data modeling

When the control unit swings into action, which step comes first a. Execute the instruction b. Fetch the instruction c. Load data into ALU d. Perform arithmetic operation

b. Fetch the instruction

Parker has an Android smartphone. Which type of processor is used in his mobile device? a. x86 b. Intel Atom c. ARM d. None of these answers

b. Intel Atom

Each programming language has a set of rules called a. Program code b. Syntax c. Statement d. Interpreter

b. Syntax

Which statement/statements about concurrency control are correct a. Concurrency control allows two or more users or applications to access the same data at the same time. b. Without proper concurrency control, one of the updates might be incorrect. c. Concurrency control is an important feature of a single user database d. Concurrency control cannot be enforced by the DBMS.

b. Without proper concurrency control, one of the updates might be incorrect.

You cannot boot a computer from ____________. a. the hard drive b. a CD or DVD c. a USB flash drive d. a wireless network

b. a CD or DVD

New cars come with an onboard computer that controls anti-lock brakes, air bag deployment, fuel injection, etc. The software is known as ____. a. a multi-user system b. an embedded system c. an enterprise system d. mobile application software

b. an embedded system

The position of a _____ is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization. a. data analyst b. data administrator c. database administrator d. data owner

b. data administrator

At Coast-to-Coast Moving and Van Lines, Ryan is responsible for managing the flow of the company's data, from initial acquisition of new data to deletion of old, outdated data. Ryan is involved in ___________. a. data stewardship b. data lifecycle management c. database administration d. data management

b. data lifecycle management

Starting from monthly sales data, if you wish to get weekly sales data, use the ___ feature. a. roll up b. drill down c. slice and dice d. extract data

b. drill down

_____ is the use of a collection of computers, often owned by many people or different organizations, to work in a coordinated manner to solve a common problem. a. Cloud computing b. Grid computing c. Parallel computing d. Web computing

b. grid computing

Check all that applies to database approach to data management a. Each distinct operational system uses data files dedicated to that system b. information systems share a pool of related data through a common user interface c. Database approach reduces data redundancy d. Database approach increases data redundancy to improve performance and consistency of data.

b. information systems share a pool of related data through a common user interface c. Database approach reduces data redundancy

The component of a computer that provides the CPU with a working storage area for program instructions and data is called the __________. a. main memory b. input/output device c. bus d. processor

b. input/output devices

One of the disadvantages of proprietary software is that ______________. a. it is hard to control results even if one is involved in the development of software b. it can take a long time and significant resources to develop the required software features c. it does not allow modification of features that one might need to counteract an initiative by competitors d. it is difficult to achieve what is required in terms of features and reports

b. it can take a long time and significant resources to develop the required software features

_____ are used in standardized tests, including the SAT and GMAT tests, and to record votes in elections. a. Magnetic Ink Character Recognition (MICR) devices b. Optical mark recognition (OMR) systems c. Speech recognition devices d. Optical character recognition (OCR) systems

b. optical mark recognition (OMR) systems

After entering data into a relational database, users can make all of the following basic data manipulations except: a. projecting b. organizing c. selecting d. joining

b. organizing

The toughest challenge in designing a processor for a smartphone or tablet is balancing _____________. a. performance and price b. performance and power consumption c. heating problems and battery drain d. efficiency and price

b. performance and power consumption

Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database. In terms of the characteristics of big data, Haley is dealing with ________. a. volume b. variety c. velocity d. veracity

b. variety

Which one of the following statements is true? a. A microprocessor executes one instruction for each cycle b. Clock speed is the only factor that affects processor performance c. A multi-core processor can outperform a single core processor that has a faster clock speed d. A 2.4 GHz intel i5 processor with 2 cores is faster than 1.5 GHz intel i7 processor with 4 cores

c. A multi-core processor can outperform a single core processor that has a faster clock speed

_____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of handling. a. Data warehouse b. Data mart c. Big data d. Knowledge base

c. Big data

Which optical storage device you will choose to backup 500 MB of data periodically a. CD-ROM b. CD-R c. CD-RW

c. CD-RW

All of the following are examples of someone using personal productivity software EXCEPT _________. a. Shawna creating an electronic to-do list for the weekend b. Mark entering appointments into his online calendar c. Callie entering a customer's order into a restaurant's ordering system d. Brandon recording the number of miles he's run each day on his exercise tracker

c. Callie entering a customer's order into a restaurant's ordering system

In Database as a Service (DaaS) a. Both Database Administration and Data Administration functions are handled by the service provider. b. Both Database Administration and Data Administration functions are handled by the organization. c. Database administration function is handled by the service provider and Data Administration function is handled by the organization. d. Database administration function is handled by the organization and Data Administration function is handled by the service provider

c. Database administration function is handled by the service provider and Data Administration function is handled by the organization.

What is true about primary key? (I) Cannot have duplicate values (II) Cannot be null. (III) Must be a single field a. (I) Only b. (II) Only c. I and II Only d. I and III Only e. All of the above

c. I and II Only

Which memory is non-volatile (Not lost if the power is turned off or interrupted) a. RAM b. Cache memory c. ROM d. None of the above

c. ROM

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database. a. Query by Example (QBE) b. Access c. Structured Query Language (SQL) d. Java

c. Structured Query Language (SQL)

The smallest piece of data used by a computer is a(n) _____. a. entity b. byte c. bit d. character

c. bit

Pinterest, a visual bookmarking Website, logs more than 14 terabytes of new data each day, which means its storage needs are constantly changing. As a result, Pinterest has turned to Amazon for _______. a. storage as a service b. grid computing c. cloud computing d. infrastructure as a service

c. cloud computing

Suppose a new tech startup wants to define the data model. They would then ____. a. collect and cleanse the data b. define user access privileges c. create the entity-relationship model d. acquire a new database management system

c. create the entity-relationship model

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database. a. data dictionary b. schema c. data definition language d. data manipulation language

c. data definition language

The process of converting human-readable data into machine-readable form is called _____. a. source data automation b. data input c. data entry d. data conversion

c. data entry

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making. a. data dictionary b. data model c. data mart d. data mine

c. data mart

What is true about low level languages? a. efficient use of computing resources, easy to use for programming b. Inefficient use of computing resources, easy to use for programming c. efficient use of computing resources, not easy to use for programming d. Inefficient use of computing resources, not easy to use for programming

c. efficient use of computing resources, not easy to use for programming

The _____ is the heart of the operating system and controls its most critical processes. a. user interface b. register c. kernel d. cache

c. kernel

_____ is a storage technology that is primarily used only for backups. a. Magnetic disk b. Compact disc c. Magnetic tape d. cache memory

c. magnetic tape

Carson's supervisor has asked him to review a variety of portable computers for possible purchase for their company's employees. Which of the following should Carson NOT consider buying? a. laptops b. notebooks c. nettops d. tablets

c. nettops

A(n) _____ is a field or set of fields in a record that uniquely identifies the record. a. attribute b. entity c. primary key d. data item

c. primary key

The action of including only some columns for output while retrieving data is known as ____. a. selecting b. joining c. projecting d. linking

c. projecting

Suppose you wish to find what tables are in a database, what fields they have, and how they are related you would review the _____. a. SQL commands b. attributes c. schema d. sample data

c. schema

A _____ is a computer employed by many users to perform a specific task, such as running network or Internet applications. a. cache b. register c. server d. bus

c. server

The use of middleware to connect disparate systems has evolved into an approach for developing software and systems called _____. a. cloud computing b. rapid application development c. service-oriented architecture d. Software as a Service

c. service-oriented architecture

One of the advantages of off-the-shelf software is that ________________. a. an organization does not have to pay for features that are not required and never used b. the software always matches current work processes and data standards c. the initial cost is lower because the software firm can spread the development costs over many customers d. the software contains important features, thus eliminating the need for future modification and customization

c. the initial cost is lower because the software firm can spread the development costs over many customers

A _____ is a low-cost, centrally managed computer with no internal or external attached drives for data storage with limited capabilities. a. nettop computer b. cloud computer c. thin client d. workstation

c. thin client

_____ are used to support engineering and technical users who perform heavy mathematical computing, computer-assisted design (CAD), video editing, and other applications requiring a high-end processor. a. Desktops b. Netbooks c. Workstations d. Notebooks

c. workstations

What is true about virtual memory (I) Swaps programs or parts of programs between memory and storage (II) Reduces CPU idle time and increase number of jobs that can run in a given time span. (III) increases execution speed of the process a. I Only b. II Only c. III Only d. I and II Only e. I and III Only

d. I and II Only

Which of the following statements is true of a database? a. It is accessed primarily for use by an organization's database administrator and data administrator. b. It provides an essential foundation for an organization's knowledge management and artificial intelligence systems. c. It is a collection of unstructured data. d. It helps companies analyze information to open new market opportunities.

d. It helps companies analyze information to open new market opportunities.

What is not true of secondary storage? a. It is non-volatile b. It is faster to retrieve data from a secondary storage than from main memory c. It offers higher storage capacity than main memory d. It offers greater economy than main memory

d. It offers greater economy than main memory

An operating system with _____ capabilities allows a user to run more than one program concurrently. a. networking b. hardware independence c. memory management d. Multitasking

d. Multitasking

_____ is a hard disk drive storage device that is set up with its own network address and provides file-based storage services to other devices on the network. a. The motherboard b. A thin client c. A storage area network (SAN) d. Network-attached storage (NAS)

d. Network-attached storage (NAS)

What is not true about Open Source Software a. It is distributed free with the source code b. Users can legally modify the code to fit their needs c. No individual or organization is committed to support the open source software d. Organizations avoid using Open Source Software because it is less reliable.

d. Organizations avoid using Open Source Software because it is less reliable.

Completing an instruction involves two phases—instruction and execution—which are each broken down into two steps for a total of four steps. Which of the following is NOT one of the four steps? a. fetch instruction b. store results c. execute instruction d. process data

d. Process Data

All of the following are examples of activities performed by an operating system EXCEPT ________. a. allowing a user to manage system memory b. allowing a user to control common computer hardware functions c. allowing a user to manage files d. allowing a user to do word processing

d. allowing a user to do word processing

To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties? a. atomicity b. durability c. isolation d. currency

d. currency

Each attribute in a relational database model can be constrained to a range of allowable values called a _____. a. bandwidth b. scope c. slot d. domain

d. domain

A database is a collection of integrated and related _____. a. fields b. attributes c. records d. files

d. files

For the ____ operation, it is required that the the two tables have a common attribute. a. delete b. select c. project d. join

d. join

Helen is 72 years old and is a retired school teacher on a fixed income. She would like to buy a new computer so that she can communicate via email, follow friends and family on social media, and occasionally access recipes and gardening tips from the Web. An important thing to consider is that Helen has arthritis in her hands, making it difficult for her to work with small buttons and gadgets. So, of the following options, her best choice is probably a(n) ________. a. smartphone b. e-book c. desktop d. nettop

d. nettop

When choosing from various types of flat panel display, choose _______ for low power consumption. a. liquid crystal display (LCD) b. light-emitting diode (LED) c. plasma d. organic LED

d. organic LED

To develop software you need all these except ________. a. a compiler b. an integrated development environment c. a debugger d. personal application software

d. personal application software

Which of the following is NOT one of the common types of utility programs? a. file compression b. tracking computer programs being run c. merge and sort data d. spreadsheet application

d. spreadsheet application

One advantage of proprietary software versus off-the-shelf software is that _____. a. the initial cost is lower b. the software is likely to meet the basic business needs that are common across organizations c. the software is likely to be of high quality because many customer firms have tested the software and helped identify its bugs d. the software provides a company a competitive advantage by solving problems in a unique manner

d. the software provides a company a competitive advantage by solving problems in a unique manner

Suppose you wish to run two different operating systems on one computer, you can accomplish it by using _______. a. a multi-processor operating system b. an embedded system c.the system utilities d. virtualization software

d. virtualization software