Isa 235 Exam 2

Front 1

A maintenance management systems is an example of what type of system?

Back 1

Departmental

Front 2

Which of the following is not a responsibility of the IS department

Back 2

Gather data

Front 3

A malicious hacker floods a web server with millions of bogus requests. This is an example of a(n) ______ attack

Back 3

Denial-of-service

Front 4

The more attributes there are, the easier it is to build a model that fits the sample data, but is worthless as a redictor. Which of the following best explains this phenomenon?

Back 4

The curse of dimensionality

Front 5

Which is a way that a data warehouse differs from a data mart?

Back 5

A data mart addresses a specific business are or question

Front 6

Which of the following is not a characteristic of Web 2.0

Back 6

Sales of software licenses

Front 7

Describe what the following does when included in a Query.
to_char(orderdate,"YYYY") as Year

Back 7

It formats the orderdate as year and labels the column Year

Front 8

Which step in the SDLC aims to eliminate projects that have the potential to violate industry regulations?

Back 8

feasibility analysis

Front 9

You have received an email asking you to click on a link that will take you to your bank's website where you are to put in your account information and other personal data. This is an example of __________.

Back 9

Phishing

Front 10

Which of the following is not a problem caused by information silos?

Back 10

data consistency

Front 11

The System development life cycle is the traditional process used to develop information systems. It is an iterative process with the steps repeated as many times as necessary

Back 11

false

Front 12

In general, the people you know best contribute the most connections to your network

Back 12

false

Front 13

Brooks' Law points out that adding more people to a late project makes the project later. This is also known as ________.

Back 13

diseconomies of scale

Front 14

the proper order for SQL statements is _________.

Back 14

Select, From, Where, Group by, order by

Front 15

write a query to get all fields from Northwinds Orders table.

Back 15

Select *
From Northwinds.orders

Front 16

Which of the following is not a component of an ERP?

Back 16

an EAI server

Front 17

Which of the following os one of the principal

Back 17

to be an effective consumer of the IT department's resoures

Front 18

The primary Key in the Orders table is orderid. The foreign Key in the OrderDetails table is orderid. You need to get information from both tables. What must be in the query and in what statement?

Back 18

WHERE orderdetails.orderid = orders.orderid

Front 19

Explain in detail the difference between reporting and data-mining systems

Back 19

Reporting systems integrated data from multiple sources, and they process that data by sorting, grouping, summing, averaging, and comparing. Data-mining systems improve decision making by using the discovered patterns and relationships to anticipate events or predict future outcomes

Front 20

Well-managed organizations recognize that __________ are critical, complex, and dynamic.

Back 20

business processes

Front 21

Which of the following is NOT an example of a service?

Back 21

Going to the office supply store for reams of paper

Front 22

Systems development is the process of creating and maintaing information systems. The scope of an information system includes which of the following?

Back 22

data, procedures, software, hardware, people

Front 23

An enterprise that can quickly adapt to external factors such as regulations is called a(n) _________ enterprise.

Back 23

Agile

Front 24

Which of the following is not a challenge when implementing new enterprise systems?

Back 24

employees welcoming the new system

Front 25

In social networks, the value of social capital is determined by the number of relationships, the strength of the relationships, and the resources controlled by those relationships.

Back 25

True

Front 26

You receive an email from a close friend. The email says that their car broke down and they need a $550 loan from you to get it fixed. It gives instructions on where to wire the money to them. You do as they ask. A week later you ask the friend about getting repaid. They look at you like you are nuts. They have never been where the email said they were. You are a victim of a(n) ________ attack.

Back 26

Spoofing

Front 27

Which of the following is not a problem with raw data?

Back 27

consistent data

Front 28

Explain in detail the difference between supervised data-mining and unsupervised data-mining

Back 28

In supervised data mining the model is created before analysis and statistical techniques such as regression are used to estimate the model's variable parameters

In unsupervised data mining the analysis is run before creating a model. Techniques such as clustering and neutral networks are used to see relationships in the data. Hypotheses are created after the data-mining to explain the results.

Front 29

After establishing the goals and purpose of a new information system, the project feasibility must be examined. Which of the following is not a dimension of feasibility that would be considered?

Back 29

administrative

Front 30

Which of the following is not part of the requirements analysis?

Back 30

module development

Front 31

which of the following non-merchant e-commerce companies match buyers and sellers at a predetermined price and arrange for delivery of the goods or services?

Back 31

clearinghouses

Front 32

which of the following use if/then rules?

Back 32

Expert

Front 33

The process of creating and maintaining information systems is called _________.

Back 33

Systems development

Front 34

Which of the following is not a way that social capital adds value?

Back 34

expediency

Front 35

benefits of a computer system for which it is not possible to assign dollar values are _______ benefits.

Back 35

intangible

Front 36

which of the following is an advantage of outsourcing?

Back 36

It can be an easy way to gain expertise

Front 37

A web store front is an example of a(an) __________.

Back 37

functional information system

Front 38

One of the distinguishing characteristics of Enterprise 2.0 is that the company manages the relationship with the customer through the use of a customer relationship management system

Back 38

False

Front 39

Interenterprise systems are used within a company to enable the transparency of the data and minimize the loss of data

Back 39

false

Front 40

Which of the following is not a disadvantage of disintermediation?

Back 40

price elasticity

Front 41

A business intelligence system (BI) is an information system that provides information for improving decision making. A reporting system is not part of a BI system.

Back 41

False

Front 42

The systems development life cycle is the traditional process used to develop information systems. It is a four phase process consisting of 1. system definition, 2. requirements analysis, 3. component design, and 4. implementation.

Back 42

False

Front 43

On what day in history did Dr. Fletcher Glancy not wear a Hawaiian shirt to ISA 235 class?

Back 43

Tuesday April 23rd.