MIS Midterm

Laws and regulations have thoroughly addressed concerns about privacy and data management in private organizations and federal agencies. True False

False

Never send sensitive personal data such as credit card numbers, bank account numbers, or passwords via text or IM; only send them through Web sites that don't begin with https or cause a padlock icon to appear in the Address bar or status bar. True False

False

New technology innovations rarely influence an organization's information system strategic plan since it is so strongly determined by corporate strategy. True False

False

RAM stands for random access memory, a form of memory that holds its contents even if the current is turned off or disrupted. True False

False

Solid state storage devices (SSDs) store data in hard disk drives or optical media rather than memory chips. True False

False

Suppose a manager wishes to analyze historical trends in sales. He would use the online transaction processing (OLTP) system. True False

False

The American Recovery and Reinvestment Act Title XIII helped establish the National Fraud Alert system to help prevent identity theft. True False

False

The sql query below will only return the product ID and the total inventory for any product whose total on had value is greater or equal to 5. SELECT product_id , total_on_hand + total_on_order FROM retail.inventory WHERE total_on_hand <= 5 True False

False

The sql statement SELECT * FROM retail.inventory will return only half of the column from the inventory table. True False

False

Today, due to security concerns, most organizations avoid the database approach to data management, where multiple information systems share a pool of related data. True False

False

Two collections of attributes can have a common primary key. True False

False

Users still need help from the IT function of the organization to create customer reports using modern reporting tools. True False

False

When you receive a text message that there is a problem with your bank account and you are required you to click on a link to submit some information, you are likely facing a vishing attack. True False

False

A database management system (DBMS) serves as an interface between an application program and a database. True False

True

A database must reflect the business processes of an organization. True False

True

Downloading games from unknown websites can be risky. The software may be a Trojan horse. True False

True

In many cases, good ethics can mean good business and improved profits True False

True

It is possible to restrict access to data depending on the database user's privileges. True False

True

One of the primary roles of a senior IS manager is to provide subordinates with leadership and direction that will help the organization achieve its goals. True False

True

Secondary storage can store large amounts of data, instructions, and information more permanently than allowed with main memory. True False

True

Software as a Service (SaaS) allows businesses to subscribe to Web-delivered business application software by paying a monthly service charge or a per-use fee. True False

True

Some organizations choose to practice a form of Internet censorship by installing Internet filters on their employees' computers to prevent them from viewing sites containing pornography or other objectionable material. True False

True

Sometimes a database can contain "bad data," meaning incomplete, incorrect, inaccurate, or irrelevant records, which can be corrected or deleted through data cleansing. True False

True

The American Recovery and Reinvestment Act Title XIII includes strong privacy provisions for electronic health records (EHRs). True False

True

The GDPR obligates organizations that operate in the European Union to obtain the consent of the people they collect information about. True False

True

The data for BI (business intelligence) comes from many sources. True False

True

There are laws that require businesses to prove that their data are secure. True False

True

U.S. federal law permits employers to prevent viewing of pornography in the workplace by employees. True False

True

When a computer security incident occurs, it is recommended that the organization NOT reveal all they know in public forums. True False

True

If 10 users can run programs at the same time on the same computer, it is known as multitasking. True False

False

With the launch of Windows 10, Microsoft announced that it would publish ongoing, incremental upgrades instead of releasing new versions of the software every few years. However, IS professionals can opt out of frequent updates if they believe that making minimal changes will ensure reliable operations. True False

True

You are given the database information: retail.inventory, retail represent the database schema and inventory represent the table from the retail schema. True False

True

You work at a call center of a large bank, where you answer credit card services-related questions from customers. Lately, you have noticed an increased number of customers enquiring whether your organization initiated a call about their account. There might be a vishing scam in progress. True False

True

Your friend has a Mac that runs OS X. If she needs to run a Windows app on it, she can set it up to run Windows also. True False

True

Although Roberta had signed a form preventing her doctor from sharing her personal medical records with the company she worked for, she later discovered that the doctor's office had, in fact, shared her data with her health insurance provider and her employer, which caused her to be terminated. Because the doctor's practice violated its own privacy policy, she was able to file a lawsuit under the ________. a. Health Insurance Portability and Accountability Act b. Health and Medical Records Privacy Act c. Gramm-Leach-Bliley Act d. none of these answers

a. Health Insurance Portability and Accountability Act

Which component of Leavitt's Diamond defines roles, responsibilities, and lines of authority among members of the organization, which must be understood and accepted for the organization to operate successfully? a. structure b. technology infrastructure c. people d. processes

a. Structure

_____ encompasses all the activities required to get the right product into the right consumer's hands in the right quantity at the right time and at the right cost, from acquisition of raw materials through customer delivery. a. Supply chain management b. Value chain management c. Inventory management d. Customer management

a. Supply chain management

Felicity, who works at a bank, opens multiple credit card accounts for customers without their authorization in order to improve her customer sales, and thus her apparent job performance. This behavior is explicitly forbidden by bank policies and the instructions her manager gave her. Which statement is true in this situation? a. The bank can be held responsible for Felicity's behavior despite its ethical policies. b. The bank cannot be held responsible for Felicity's actions since they were contrary to bank policies. c. This situation demonstrates how bad organizational ethics can lead to bad business results. d. The principle called respondeat superior, meaning "let the master answer," does not apply.

a. The bank can be held responsible for Felicity's behavior despite its ethical policies.

How do fair information practices in the United States and the European Union differ? a. Unlike the EU, the U.S. has no single, overarching national data privacy policy. b. Unlike the U.S., the EU has implemented numerous data privacy laws. c. Unlike the EU, the U.S. addresses potential abuses by private industry but not by the government. d. Unlike the U.S., the EU divides their data privacy laws into three ares: financial, health related, and child specific.

a. Unlike the EU, the U.S. has no single, overarching national data privacy policy.

Which of the following activities does the USA Patriot Act define? a. cyberterrorism b. identity theft c. credit card fraud d. transmitting virus programs

a. cyberterrorism

Raw facts such as a social security number or catalog item number for a shirt are known as _____. a. data b. knowledge c. information d. entities

a. data

Walter mentions to his manager that it would simplify the maintenance of their firm's relational database if changes made to data attributes in a single table would automatically be made throughout the database. What would best achieve this? a. data normalization b. selecting c. data cleansing d. concurrency control

a. data normalization

A hospital system that wants to utilize big data can use HIPAA regulations to help them _____. a. identify which data needs to be protected from unauthorized access b. find nuggets of data that are relevant to the decision making at hand c. choose a subset of data to store d. process unstructured data into a usable form

a. identify which data needs to be protected from unauthorized access

A successful IS manager recognizes that sustaining a competitive advantage _____. a. means evolving to account for changes in customer needs b. requires little effort compared with initially gaining that advantage c. is outside the IS department's roles in most organizations d. primarily involves consistency in product and service offerings

a. means evolving to account for changes in customer needs

Bubba creates a web application that allows his coworkers to generate reports providing information on sales, costs, and inventory that they need for their job functions without assistance. Bubba has developed a(n) _____. a. personal information system b. workgroup information system c. enterprise information system d. interorganizational information system

a. personal information system

A collection of characteristics that belong to a single person, place, or thing for which data is maintained is a(n) _____. a. record b. file c. attribute d. character

a. record

Kennedy's company is adopting a service-oriented architecture approach to software development. This means that _____. a. their software will be flexible enough to allow the addition of new services b. their software will consist of many program modules that do not share information c. they have decided not to build or adopt microservices in the future d. they can build software without creating application programming interfaces

a. their software will be flexible enough to allow the addition of new services

High-quality data on the operations of the business is the primary ingredient of any effort to improve _____. a. worker efficiency or service quality b. competitive advantage c. customer experiences or satisfaction d. IS security

a. worker efficiency or service quality

Because they must deal with large quantities of data from so many different sources, IS employees at financial institutions may be at increased risk of failing to comply with government regulations designed to prevent money laundering, such as the _____. a. Sarbanes-Oxley Act b. Bank Secrecy Act c. HIPAA d. PCI Data Security Standard

b. Bank Secrecy Act

How is data governance different from data management? a. Data management is the core component of data governance. b. Data governance is the core component of data management. c. Data management involves defining processes, whereas data governance does not. d. Data governance involves defining processes, whereas data management does not.

b. Data governance is the core component of data management.

American's rights to freedom of religion, freedom of expression, and freedom to assemble peaceably are protected by the _____. a. Fourth Amendment b. First Amendment c. COPPA d. HIPA

b. First Amendment

Which element is not part of the CIA triad? a. Integrity b. Integration c. Confidentiality d. Availability

b. Integration

Business analytics certifications in high demand include _____. a. AJAX, C#, and Sharepoint b. SAP Business Objects, Hadoop, and Ruby on Rails c. Cisco, LINUX/UNIX, and CISSP d. .NET, PHP, and Java

b. SAP Business Objects, Hadoop, and Ruby on Rails

Which of the following is a provision of the USA PATRIOT Act? a. termination of the bulk collection of telephone records and Internet metadata b. authorization of "snack and peak warrants" for law enforcement agencies c. gathering of foreign intelligence from non-Americans outside the U.S. d. requirement for judicial authorization within 72 hours after surveillance of U.S. citizens begins

b. authorization of "snack and peak warrants" for law enforcement agencies

Autumn develops a strategic plan that will allow her organization to take advantage of opportunities and trends by _____. a. staying focused on costs b. being proactive c. reacting passively d. remaining in state of flux

b. being proactive

Assessing damage following a computer incident, investigating the unauthorized disclosure of corporate confidential data, and confirming or evaluating the impact of industrial espionage are tasks most appropriate for _____. a. managed security service providers b. computer forensics c. the CIA security triad d. a security dashboard

b. computer forensics

A high-level IS manager has his firm utilize sophisticated information systems to digitally design its products so that design defects can be detected and removed early in the process, reducing development cost. What business strategy does this represent? a. high standards b. cost leadership c. differentiation d. focus

b. cost leadership

A senior IS manager decides to invest in an information system that will reduce subcontractor labor costs for her organization by facilitating relocation of tools and materials to more optimal locations while rearranging workflows. What business strategy does this represent? a. high standards b. cost leadership c. differentiation d. focus

b. cost leadership

A senior IS manager implements a vendor-managed inventory system that reduces both the administrative costs of managing inventory and inventory holding costs. What business strategy does this represent? a. high standards b. cost leadership c. differentiation d. focus

b. cost leadership

Haley needs to query her firm's database, Jeff needs to generate a report for his next project status meeting, and Karen needs to make some modifications to update the data in the database. Which of the following tools can they all use to complete their current task? a. data dictionary b. data manipulation language c. data definition language d. These tasks require different tools.

b. data manipulation language

An IS manager is focusing on the people component of Leavitt's Diamond when he or she _____. a. delegates the responsibility for creating new procedures b. ensures that the IS help desk is available during work hours c. selects new IS software and service providers d. clarifies the changes in employee roles related to a new IS

b. ensures that the IS help desk is available during work hours

A DaaS arrangement can be especially cost effective for businesses that _____. a. host their own physical backup and recovery b. have fluctuating needs for database storage capacity c. require unusual data security processes be enforced d. prefer to build and maintain their own data centers

b. have fluctuating needs for database storage capacity

In which step of the ethical decision-making process is it essential to communicate well with all stakeholders and have someone they trust and respect explain why things are changing and how this will benefit them? a. evaluate the results b. implement the decision c. choose an alternative d. identify alternatives

b. implement the decision

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

b. nonvolatile

CPU clock speed is the predetermined rate at which the processor _____. a. processes instructions b. produces a series of electronic pulses c. produces a number of files d. loads memory pages

b. produces a series of electronic pulses

Amazon's decision to explore the possible use of delivery drones to gain a real competitive advantage over competitors who rely on less efficient ground transportation is an example of _____. a. inbound logistics b. strategic planning c. procurement d. human resource management

b. strategic planning

Government entities may pressure upstream Internet service providers to _____. a. immediately take down particular hosted material b. track and monitor the Internet activities of individuals c. deregister domains because of their hosted content d. accept defamation or copyright infringement claims

b. track and monitor the Internet activities of individuals

Why would Claire, who has a Certified Information Systems Security Professional credential, object to shadow IT efforts at her company? a. Issues can arise over the responsibility to fix shadow IT solutions when they break. b. Shadow IT provides the opportunity to evaluate and test many more information system initiatives. c. Shadow IT systems and processes may lack necessary levels of security required to meet compliance standards. d. Shadow IT delays testing of quick solutions to business needs.

c. Shadow IT systems and processes may lack necessary levels of security required to meet compliance standards.

What discipline combines elements of law and computer science to identify, collect, examine, and preserve data from computer systems, networks, and storage devices in a manner that preserves the integrity of the data gathered so that it is admissible as evidence in a court of law? a. CIA implementation b. risk assessment c. computer forensics d. security policy

c. computer forensics

A tier 3 or 4 data center would be most necessary for an organization with which characteristic? a. small with few employees b. prepared to process manual customer orders manually c. dependent on computers to manage manufacturing operations d. impacted by long-term but not short-term business disruptions

c. dependent on computers to manage manufacturing operations

An upper-level IS manager proposes that his organization implement a system to consolidate shipping and exception data from multiple carriers so that consumers know when their purchase will ship and when it will arrive. What business strategy does this represent? a. high standards b. cost leadership c. differentiation d. focus

c. differentiation

You might be a successful information systems worker if you _________. a. prefer a slow-paced environment where technology rarely changes b. prefer to work only on the computer and are not interested in the business c. enjoy learning new techniques and enjoy working with people d. are good at book-keeping, like an accountant

c. enjoy learning new techniques and enjoy working with people

Which type of information system do organizations use to define structured interactions among employees or between the organizational and external customers, suppliers, or business partners? a. personal information system b. workgroup information system c. enterprise information system d. interorganizational information system

c. enterprise information system

A database system that stores the entire database in random access memory is known as a(n) _____. a. relational database b. HDFS database c. in-memory database d. NoSQL database

c. in-memory database

Rigorous management processes are needed to govern data in order to _____. a. evade external regulations that manage risk associated with financial data b. support haphazard or incomplete business processes c. inform key business decisions with high-quality data d. isolate data architecture management from security management

c. inform key decisions with high-quality data

Violating the European Union General Data Protection Regulation guidelines will most likely increase a successful cyberattack's _____. a. direct impacts b. recovery costs c. legal consequences d. reputation damage

c. legal consequences

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

Compared with the traditional licensing model in which users purchase and install software, SaaS _____. a. can be accessed from fewer devices per license b. provides more reliable access in areas with no Internet service c. offers less expensive upgrades and new releases d. requires more maintenance on the part of customers

c. offers less expensive upgrades and new releases

After a successful cyberattack, the funds spent on repairing affected systems, restoring lost data, and performing a post-incident analysis are considered part of the _____. a. direct impact b. business disruption c. recovery cost d. legal consequences

c. recovery cost

After completing a security self-assessment, Hal decides to improve his practices related to use of social media sites such as Facebook. How can he make his social media use safer? a. access social media sites via a VPN b. change his password to one that includes only numbers and is eight characters long c. review, understand, and if necessary adjust his privacy settings for these sites d. run his antivirus software just before he logs in to these sites

c. review, understand, and if necessary adjust his privacy settings for these sites

Hardware utilization can be improved by logically dividing the resources of a single physical server to create multiple logical servers. This approach is known as _____. a. real-time task scheduling b. multithreading c. server virtualization d. multiprocessing

c. server virtualization

The purpose of business intelligence is to _____. a. provide access to novel tools to end users b. reduce the cost of data processing c. support improved decision making d. improve employee morale

c. support improved decision making

Big data veracity is a measure of _____. a. the degree of organization or structure of the data b. the data's worth for decision making in a given scenario c. the accuracy, completeness, and currency of the data d. the rate at which data in an area is becoming available

c. the accuracy, completeness, and currency of the data

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

_____ are people who work directly with information systems to get results. a. System analysts b. Database administrators c. System developers d. End users

d. End users

Which amendment protects Americans' rights to freedom of religion, freedom of expression, and freedom to assemble peaceably? a. Second b. Third c. Fourth d. First

d. First

_____ is/are considered to be the most important element in computer-based information systems. a. Bandwidth b. Software applications c. Standard operating procedures d. People

d. People

A company's risk assessment process can consider numerous threats to the computers and networks. Which of the following should an organization identify as loss events or threats to assess? a. distributed denial-of-service attack b. email attachment with harmful worm c. harmful virus d. all of the above

d. all of the above

During the early formation of the United States, many influential writings criticizing British rule were published without the real names of their authors. These publications represented a form of _____. a. slander b. First Amendment expression c. incitement to crime d. anonymous expression

d. anonymous expression

A slight majority (52%) of 700 CIOs surveyed reported that their IS organization is viewed as a _____. a. cost center or service provider b. value chain c. game changer d. business partner or peer

d. business partner or peer

To successfully fight computer crime in a court of law, prosecutors and victims depend on a properly handled _____. a. security education initiative b. intrusion detection system c. corporate security risk assessment d. computer forensics investigation

d. computer forensics investigation

An IS manager recommends that his organization invest in improving its customer information system so as to more clearly define the target market and improve service to that market. What business strategy does this represent? a. high standards b. cost leadership c. differentiation d. focus

d. focus

Collaboration between two or more organizations that lowers costs and reduces manual effort among employees is enabled by a(n) _____. a. personal information system b. workgroup information system c. enterprise information system d. interorganizational information system

d. interorganizational information system

High-quality data can increase sales by facilitating cross-selling, which involves _____. a. delivering a generalized shopping experience to customers b. ensuring customers pay a fair, correct price for each product they purchase c. encouraging customers to buy a comparable but higher-end product d. inviting customers to purchase an item related to what they are primarily interested in

d. inviting customers to purchase an item related to what they are primarily interested in

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

Ethical business practices _____. a. create a negative discrepancy between employee and organizational values b. increase employee turnover when workers feel their actions are overly restricted c. are usually more expensive for a business over the long term than unethical ones d. often raise an organization's priority with suppliers and other business partners

d. often raise an organization's priority with suppliers and other business partners

While conducting a security self-assessment of his personal laptop use, Vann realizes that he is putting himself at risk by _____. a. upgrading his operating system too often b. installing both firewall and antivirus software at the same time c. purchasing new anti-malware software before it has been reviewed by other consumers d. putting off installing available software updates that he has been notified about

d. putting off installing available software updates that he has been notified about

Allie has noticed that people at her company spend a lot of time researching the reasons for and correcting errors in the data they must use for their job functions. Usually when a mistake is discovered, it has already been propagated into multiple places, requiring a considerable clean-up effort. Allie realizes that improving the quality of the data at her firm would change this situation by _____. a. increasing sales b. improving decision making c. facilitating innovation d. raising productivity

d. raising productivity

What do AT&T, Computer Sciences Corporation, Dell SecureWorks, IBM, Symantec, and Verizon have in common? a. they recently suffered massive data breaches b. they pioneered bring your own device policies c. they have reduced their security risk to zero d. they are managed security service providers

d. they are managed security service providers

A well-designed series of rules or algorithms is a key component of which stage of the ETL process? a. extract b. edit c. load d. transform

d. transform