INSY Chapter 9-11

Human errors are mistakes made by computer operators

True

Which type of problem requires human intuition as the basis for finding a solution.​

Unstructured

Iterative SDLCs are often referred to as "agile methods" because they allow flexibility as development progresses.​

True

Horizontal market software is designed to meet the needs of a single industry while vertical market software meets the needs of many different industries

False

​Which of the following is a core CRM system

- customer support

- Sales

- Marketing

The maintenance phase of a SDLC includes all of the following except _________.​

Convert Data

Fraud alerts interfere with your ability to receive instant credit

False

A DSS manipulates the data needed to make a decision as well as making a decision

False- DSS does not make the actual decision

Detailed application specifications can be developed before or after selecting the hardware and software for an information system

False

A major source of data for CRM is produced by loyalty programs.​

True

As the design phase of a SDLC begins, programming languages, development tools, and application software needed for the new information system are purchased, installed, and tested to ensure that they work correctly.​

False

The scope of an information system includes which of the following?

- computers, communications networks, and data

- people and products

- policies and procedures

ALL OF THE ABOVE

Which business practice is a technique initiated by top management that involves all employees and all departments, and focuses on quality assurance in every product and service offered to customers?​

TQM

System documentation contains step-by-step instructions for performing specific tasks.

False- this would be a procedure handbook

Which of the following is a part of the analysis phase of a SDLC?

- Study the current system

- Determine system requirements

- ​Write requirements report

A(n) _____________ is a group of people working together to accomplish a goal.​

organization

At an ecommerce site, the merchant's ecommerce application carries out only the first and last stages of the payment process.​

True

Data centers are designed to proactively reduce the risk of data loss that might occur as a result of a disaster.​

True

_______ applications provide optimal information when they encompass customer support, marketing, and sales.​

CRM

A(n) ___________ is the sequence of organizations, people, activities, information, and resources involved in moving a product or service from supplier to customer

​supply chain

Which type of security measure reduces the likelihood of a deliberate attack?​

Deterrents

Application software for an information system is usually a series of preprogrammed software modules supplied by a software publisher.​

True

Which ecommerce classification encompasses consumers selling merchandise and services to each other?​

C2C

Which ecommerce classification encompasses online storefronts selling merchandise and services to consumers?

​B2C

In addition to sales, CRM, and SCM, ERP modules support business activities such as _____________.​

- product planning

- manufacturing and purchasing

- inventory control and distribution

A transaction processing system is characterized by its ability to:​

- Collect, display, and modify transactions.

- ​Store transactions.

- List transactions.

ALL OF THE ABOVE

Acceptance testing is designed to verify that the new information system works as required.​

True

A lookup routine validates an entry by checking data in an in-house or third-party database

True

An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed

The 3rd platform

A DBMS feature known as __________ ensures that transactions are updated in an orderly manner by establishing update rules

serializability

The goal of normalization is to minimize data redundancy.

True

A table's physical sort order is the order in which records are arranged on storage devices.​

True

A __________ solution for data storage adds resources to a single device, while a __________ solution adds more devices to a system.​

​scale up, scale out

SQL statements contain command words but do not contain data.

False

__________ are the most commonly used database clients.​​

Browsers

The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.​

JOIN

SQL keywords must be entered in all uppercase letters because they are case-sensitive.​

False

Which database data type is a collection of binary data stored in a single field of a database?​

BLOB

A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field.​

field validation rule

Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.​

True

​In a database, a(n) __________ contains the smallest unit of meaningful information

Field

A(n) ________________ is a software tool for specifying the content and format for a database report.

​report generator

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.​

False

A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.​

False

A(n) __________ is the column of data in a database that is used as the basis for rearranging the data.​

​sort key

The acronym ____________ refers to software that manages data stored in a database.​​

DBMS

A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than one field.

single-level, multi-level

Which of the following is not considered to be type of database client?​

a. Local software

b. ​Browsers

c. ​Apps

ALL OF THE ABOVE

Spreadsheet software offers database capabilities for establishing relationships between different record types.​

False

Which database tool is best for simple flat files that involve calculations?​

Spreadsheet software​

__________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status.​

OLAP

In a relational database, relationships are specified by joining common data stored in records from different tables.

True

The human-readable version of a program created in a high-level language by a programmer is called __________.​

source code

_________________ refers to the process of hiding the internal details of objects and their methods.​

Encapsulation

Microprocessors only understand machine language, so there has to be some way to convert assembly language instructions into 1s and 0s

True

Regarding OO programming, which of the following terms best matches with the term "method"?​

​main()

Prolog and other declarative languages were classified as fifth-generation languages.​

True

Programmers insert documentation called facts into the program code.​

False

What is the term that refers to the sequence in which a computer executes program instructions?​

Flow Control

A(n) __________ is available for use by any routine in the program while a(n) _______________ can be accessed only from the routine in which it is defined.​

public attribute, private attribute

The _____________ in a problem statement is the information that is supplied to the computer to help it solve a problem.​

known information

Procedural languages encourage programmers to approach problems by breaking the solution down to a series of steps.​

True

Some software engineering activities overlap with the systems analysis and design activities​

True

Finding a value for a variable is referred to as ___________.​

instantiation

The process of planning a computer program begins with a problem statement that clearly define the program's purpose.​

True

The facts in a Prolog program are useful even without any rules.

True

Prolog allows you to ask open-ended questions by replacing constants with __________.​

Variables

The instructions that make up a computer program are sometimes referred to as __________.​

​code

A(n) _________ provides programmers with tools to build substantial sections of a program by pointing and clicking rather than typing lines of code.​

VDE

A(n) ____________ for a computer program is a set of steps that explains how to begin with known information specified in a problem statement and how to manipulate that information to arrive at a solution.​

​algorithm

An API is a set of application or operating system functions that programmers can add to the programs they create.​

True

A(n) ________________ tells a computer what to do based on whether a condition is true or false.​

selection control structure

When taking the object-oriented approach to a problem, one of the first steps is to identify the objects that pertain to a solution.​

True

A low-level language uses command words and grammar based on human languages.​

False

A(n) ___________ converts all the statements in a program in a single batch, and the resulting collection of instructions, called ________, is placed in a new file.​

compiler, object code

In Prolog, the __________ describes the relationship between the _________ .​

predicate, arguments

Prolog programming is all about facts and rules.​

True

in DFD terminology, a data store is a process that changes date by performing a calculation, updating information, or sorting a list.

False

Which of the following is not a characteristic of a management information system?

Collect, display, and modify transactions

In addition to sales, CRM, and SCM, ERP modules support business activities such as ______.

All of the above

Interative SDLC's are often referred to as "agile methods" because they allow flexibility as development progresses

True

Industry standard tools for scheduling and project management include PERT, WBS, and _____.

Gantt charts

Which type of problem requires human intuition as the basis for finding a solution.

Unstructured

JAD provides a structured methodology for planning and holding a series of meetings in which users and analysts jointly identify problems and look for solutions

True

Hacking accounts for about 90% of data breaches.

False- accounts for 30% for data breaches

The design phase of a SDLC includes all of the following except______.

Write requirements report

Once you've released data to an information system, you still have control of its distribution or its security.

False- you no longer have control

Three key concepts ensure good quality of service include all of the following except____.

Convertibility

The planning phase of a SDLC includes all of the following except_____.

Writing a requirements report

Information systems designed for a specific industry or enterprise may use vertical market software

True

Which of the following is not a characteristic of a management information system

Collect, display, and modify transactions

The goal of SCM is to supply customers with the right product at the right price

True

Which of the following is not a core CRM system?

Payment gateway

Which of the following is not part of the analysis phase of a SDLC?

Develop a project schedule

Which of the following would not be considered a database data type?

Select

One of the ways that databases are classified is by their structure.

True

The entire internet contains about a zettabyte of data

False

______ refers to a branch of data mining that analyze current and historical data to predict future trends.

Predictive analytics

An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.

True

It is not possible to extract analytical data from operational databases.

False