BCIS Test 1

Being able to develop software without concern for the specific underlying hardware is referred to as _____.

hardware independence

Together, bits, characters, fields, records, files, and databases form the ______.

hierarchy of data

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

in-memory database (IMDB)

Of the five categories of innovation adopters, ---- are always the first to try new products and ideas

innovators

In a relational database model, _____ involves combining two or more tables.

joining

A(n) --- is an organized collection of people, procedures, software, databases, and devices that provides routine info to managers and decision makers

management information system (MIS)

T or F: For most companies, the spheres of influence are _____, workgroup, and enterprise.

personal

The attitude towards using an information system depends on its perceived ease-of-use and perceived-----

usefulness

Over time, decision support systems, executive information systems, online analytical processing, business intelligence, and business analytics have gained in capabilities and expanded in scope to add new functionality, but all have had the same goal: deriving the most _____ from the data available.

value

When your IT person says, "It is best to host the application on a web server," that means the users will be accessing the software via a(n) ______.

website/browser/browser interface/web browser

T or 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 or F: Systems software consists of programs that help users solve particular computing problems

False

T or F:In the context of the relational database model, selecting involves combining two or more tables.

False

T or F:One of the final steps in installing and using a large database involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.

False

T or False: Data modeling usually involves setting a specific business goal and then analyzing the data and information needed to reach that goal.​

False

T or false: Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.​

False

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

False

TRUE OR FALSE: An organization's structure is independent of its goals and approach to management.

False

TRUE OR FALSE: Cyber criminals are hackers who try to steal business information or government data related to nation's infrastructure, all for personal gain.

False

--- is the awareness and understanding of a set of info and the ways that info can be made useful to support a specific task or reach a decision

Knowledge

TRUE OR FALSE: When a customer buys products using the company's website, it results in transactions that are recorded for later use by management information systems

TRUE

TRUE or false: Opportunities in IS are available to people from different parts of the world

TRUE

T or F 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

T or F: A database management system (DBMS) serves as an interface between an application program and a database

True

T or F: A database management system (DBMS) serves as an interface between an application program and a database.

True

T or F: The primary function of application software is to apply the power of the computer to enable people, workgroups, and the entire enterprise to solve problems and perform specific tasks.

True

The ---- theory was developed by EM Rogers to explain how a new idea or product gains acceptance and diffuses (or spreads) through a specific population or subset of an organization

diffusion of innovation

The gulf between those who do and do not have access to modern info and communications technology is described as the ---

digital divide

Data modeling done at the level of an entire enterprise is called _____.

enterprise data modeling

Suppose a small manufacturing business wishes to have a system to manage all its vital business operations, they should go for a (n)

enterprise resource planning (ERP) program

With----, a service provider organization owns and manages the hardware, software, networking, and storage devices, with cloud user organizations (called tenants) assessing slices of shared resources via the Internet.

-cloud computing/ public cloud computing

---- process for testing skills and knowledge, which results in statement by the certifying authority that confirms an individual is capable of performing particular tasks

Certification

_____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

Concurrency control

--- design and set up databases to meet an organization's needs

Database administrators/DBAs

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

End users

______ use basic graphical symbols to show an organization of and relationships between data. You Answered

Entity-relationship (ER) diagrams

--- is a network based on Web technologies that allows selected outsiders, such as business partners and customers, to access authorized resources of company's intranet

Extranet

TR OR FALSE: Using a computer to forecast future sales and order more inventory before a shortage can occur is an example of information system feedback

FALSE

TRUE OR FALSE: A set of random or unrelated tasks performed to achieve a definite outcome is called a process

FALSE

TRUE OR FALSE: When a business finds that many of its business applications have to be updated or rewritten, it will be better if they replace them with an ERP system

FALSE

TRUE or FALSE: For someone to be a good CIO, technical ability is the most important characteristic.

FALSE

TRUE or False: Adapting is the second stage in Lewin's Change Model, which involves learning new work methods, behaviors, and systems

FALSE

_____ programs can reduce the amount of disk space required to store a file or reduce the time it takes to transfer a file over the Internet.

FIle-Compression/ Compression/Zip/Data-compression

TRUE OR FALSE: Data represents real-world things including raw facts such as image and audio data.

TRUE

_____ software addresses the needs that are common across businesses, organizations, or individuals.

Mass-produced/Off-the-shelf/Package/Off the Shelf

_____ is an example of a popular general purpose software suite for personal computer users. a. Google Chrome b. Snow Leopard c. Office d. Firefox

Office

TRUE OR FALSE: Database is essential to the operation of a computer-based information system

TRUE

_____ is a set of rules associated with a programming language.

Syntax

---- activity of building information systems to meet users' needs

Systems Development

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

TRUE

TR OR FALSE: An example of the concept of feedback is factory information system that is programmed to alert the manager if there is any decrease in productivity so the manager can take corrective steps to improve productivity

TRUE

TRUE OR FALSE: Components of a computer-based information system include people such as the CIO (chief information officer) and end-users

TRUE

T or F: 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, some IS professionals have opted out of frequent updates because they believe making minimal changes will ensure reliable operations. ​

True

T or F:In the context of the relational database model, projecting involves eliminating columns in a table.

True

T or F:Most operating systems support virtual memory which allocates space on the hard disk to supplement the immediate, functional memory capacity of RAM.

True

T or F:The operating system converts a basic user request into the set of detailed instructions that the computer hardware requires, thus acting as an intermediary between the application and the hardware.

True

TRUE OR FALSE: A traditional view of information systems holds that organizations use them to control and monitor processes and ensure effectiveness and efficiency

True

TRUE OR FALSE: According to Lewin's Change model, an organization must deliberately change old habits, learn new work methods, and accept the new work methods as parts of the job.

True

TRUE OR FALSE: Since the 1950s, computers have been used to perform common business applications

True

TRUE OR FALSE: ​The successful implementation for change only happens when people accept the need for change and believe that it will improve factors such as productivity and/or customer satisfaction.

True

A friend's computer came with Windows 8 operating system. Which of the following years was the computer most likely bought in? a. 2012 b. 2001 c. 2009 d. 1999

a. 2012

Positive outcomes of continuous improvement include a. all of these b. increased customer satisfaction c. increased customer loyalty d. protection against customers

a. all of these

_____ 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. enterprise data modeling b. social graph analysis c. data cleansing d. data selecting

a. enterprise data modeling

Suppose you are assigned to manage a virtual team. Which would you NOT do? a. hold team meetings regularly-whether ppl like it or not b. be aware of team members cultural sensitivity c. ensure the team members are familiar w/ each other at personal level d. define goals, set expectations

a. hold team meetings regularly-whether ppl like it or not

To develop software you need all these except ​________. a. personal application software b. debugger c. integrated dev. environment d. complier

a. personal application software

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

a. service-oriented architecture

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. variety b. veracity c. volume d. velocity

a. variety

Suppose your friend plans, designs, creates, operates, secures, monitors, and maintains databases. She must be a(n) ___________.

database administrator DBA

---- is a visa program that allows skilled employees from foreign lands into the US. a. L-1B b. H-1B c. 4F d. G-5

b. H-1B

When the IS organization and its resources are focused on efforts that support the key objectives defined in the managers' strategic plan for the business, the organization is in a. development b. alignment c. construction d. compliance

b. alignment

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

b. allowing a user to do word processing

Which of the following is NOT a task typically associated with the systems analyst role? a. troubleshooting problems after implementation b. collaborating with others to build a software product from scratch c. choosing and configuring hardware and software d. conveying system requirements to software developers and network architects

b. collaborating with others to build a software product with scratch

The performance levels of radically new 'high tech' products usually improve w/ newer versions. Such types of products are know as a.business reengineering b. disruptive innovations c. sustaining innovations d. continuous improvement

b. disruptive innovations

​Calligraph Publishing Company has created a system for storing every piece of data about every one of its books, both those that have already published and those that are still in production. The production team can input and access information about each book's format, editors can specify which procedures are in use, salespeople can input and access information about each book's sales history and availability, and even some external partners are allowed to access some data. This is an example of a(n) __________. a. group information system b. knowledge management system c. management information system d. database

b. knowledge management system

Which of the following statements is NOT true about a mainframe computer? a. mainframe computer provides the computing and storage capacity to meet massive data processing require. b. single computer with a single user is typical of mainframe computer c. wide range of application software has been developed to run in mainframe environment d. mainframe computer offers users high performance and excellent system availability

b. single computer with a single user is typical of mainframe computer

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

b. spreadsheet application

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

b. wireless network

Suppose a business wishes to move away from hosting its own applications, the recommended solution is to use ______. a. virtualization b. software as a service c. cloud computing d. multi boost options

c. cloud computing

Suppose you work at a business unit that has group of people who would rather wait to try a new technique. They listen to and follow the opinion leaders. They would be classified as the _________. a. late majority b. early adopters c. early majority d. innovators

c. early majority

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

c. files

In a manufacturing organization, the supply chain is a key value chain whose primary activities include all of the following except: a. inbuound logistics b. customer service c. finance and accounting d. marketing and sales

c. finance and accounting

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

c. record

​Last week Jake and Gina used their computer programming skills to illegally gain access to a local veterinary clinic's customer database. They stole the customers' names, addresses, and credit card numbers, and they're now using this information to purchase things from the Internet. Jake and Gina are _________. a. cyber criminals b. end users c. cyber terrorists d. all of these

cybercriminals

_____ is an example of a popular general purpose software suite for personal computer users. a. Snow Leopard b. Google Chrome c. Mozilla Firefox d. Microsoft Office

d. Microsoft Office

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

d. Structured Query Language (SQL)

---- are responsible for running and maintaining information system equipment and also for scheduling, hardware maintenance, and preparing input and output a. Data-entry operators b. Local area network operators c. Web operators d. System operators

d. System operators

Important functions of the chief information officer include: a. ensuring the organization complies with law and regulations b. monitoring the financial consideration of the IS dep. such as return of the investment c. employing an IS department's equipment and staff to help the organization reach its goals d. all of these

d. all of these

Over the next few years, it is expected that many organizations will focus on projects that a. take advantage of cloud computing b. create more mobile applications for their customers and employees c. apply analytics to large amounts of business data d. all of these

d. all of these

The Internet of Things connects wireless identifiable objects--- a. with a central server b. with each other c to their owners d. all of these

d. all of these

The members of an organization who are most likely to contribute to organizational learning are--- a. executives b . mid-level managers c. hourly employees d. all of these

d. all of these

Information systems applications help sales and marketing professionals with all of the following EXCEPT-- a. determining advertising approaches b. setting prices c. developing new goods and services d. computer-assisted manufacturing

d. computer-assisted manufacturing

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 administrator b. data manager c. database administrator d. data steward

d. data steward

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. Oracle c. Software as a service d. database as a service

d. database as a service

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

d. enjoy learning new techniques and enjoy working with people

All of the following are potential drawbacks to outsourcing EXCEPT: a. potential for data breaches b. loss of flexibility and control c. low employee morale d. greater focus on core business

d. greater focus on core business

mySQL is a popular ____________.

database program/DBMS/Database management system/database software

--- are responsible for running and maintaining information system equipment and also for scheduling, hardware maintenance, and preparing input and output a. local area network operators b. data-entry operators c. web operators d. systems operators

d. systems opertors

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

d. virtualization software

A(n) _____ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

data definition language (DDL)

A(n) _____ is a detailed description of all data used in a database.

data dictionary

The _____ is a specific language, provided with a database management system (DBMS) that allows users to access and modify the data, to make queries, and to generate reports.

data manipulation language (DML)

A(n) ---- is an organized collection of facts and information, typically consisting of two or more related data files.

database

--- is the term used to describe the IS and solutions built and deployed by departments other than the IS department

shadow IT/ Shadow Information Technology