Mid term stuff

Question 1

What are the three main purposes that all businesses use information for?

Answer 1

Communication, process support, decision making

Question 2

Which of these can be considered a direct result of the Moore’s Law?

Answer 2

a playstation today is faster than a military supercomputer form 1996

Question 3

What is the hardware, software, and media used to store, organize, retrieve, and communicate information called?

Answer 3

Information technology

Question 4

While placing an order on Amazon.com for your favorite movie, you find that you are not able to add the DVD to your cart because no more DVD’s are in inventory. This is an example of ________ in action.

Answer 4

business rules

Question 5

What the four categories of change that information systems enable within an organization?

Answer 5

process improvement, automation, control information flow

Question 6

When filling up a car with gasoline today, most people complete their entire transaction at the pump. This includes paying for the transaction, filling the vehicle up with fuel, and receiving a receipt for the transaction. What type of organizational change has this information system allowed for?

Answer 6

automation

Question 7

When sitting at the coffee shop on campus, you connect to the wireless network so that you can research a project for the management class. What element of an information system is the wireless connection?

Answer 7

communication media

Question 8

An associative table must have:

Answer 8

two foreign key columns

Question 9

___ is being faced with more information than we can effectively process.

Answer 9

information overload

Question 10

Yahoo! Finance provides stock quotes that are 15 minutes delayed. For which reasons would this information be unacceptable for high-frequency trading where stock trades are made many times per second?

Answer 10

not current

Question 11

Organizations need ___________, which are specifically meant to provide them competitive advantages.

Answer 11

strategic information systems

Question 12

Today a bank providing an ATM so that its customers can withdraw and deposit cash without the need of a human teller is an example of a:

Answer 12

routine information system

Question 13

The first step of the strategic planning process, which clearly identifies what the mission of the organization is, is often referred to as what?

Answer 13

know who you are

Question 14

The Priority Matrix allows managers to evaluate and prioritize potential initiatives on what two dimensions?

Answer 14

ease of implementation, potential returns

Question 15

For Kiva Systems, a robotics company that builds robots that move over warehouse floors and transport goods, the development of flying drones by

Answer 15

a potential threat of substitutes

Question 16

A multi-national company has office around the world. The company has various departments (e.g., Finance, IT, Marketing) in each country. The department names (e.g., Finance) are unique in each country but not across countries. The company stores quarterly performance scores for each department from every country in its central database that has two tables named “Department” and “Performance”. Which of these is most likely to be true?

Answer 16

The foreign keys in the Performance table include department name and country.

Question 17

A table named “Employee” in a database contains information about Employees. Each employee works for one department. Each department has multiple employees. The field/column named “DeptNum” in the Employee table links each employee to another table called “Department” that contains the information about departments. Which of these is most likely to be true?

Answer 17

The values of DeptNum in the Employee table may repeat

Question 18

In a relational database, the link between two tables by a primary key and a foreign key is known as

Answer 18

a relationship

Question 19

A table with details of students from different universities has two attributes, University ID and University Name, as its composite primary key. Hence

Answer 19

Each row of the table must have a unique combination of values for University ID and University Name

Question 20

When a many-to-many relationship is found between two tables in a relational database it is necessary to create a _______ to link the two tables together to eliminate the many-to-many relationship.

Answer 20

new table

Question 21

Airbnb is a marketplace that connects owners of an unused space (e.g., a house) with the people who are looking for such space. It is an example of what is called

Answer 21

collaborative consumption

Question 22

While looking for anew smartphone you browse through the website of a smartphone manufacturer to gain information about the pros and cons of their smartphones. You may be concerned about the ____ of information on such a site.

Answer 22

objectivity

Question 23

According to the talk by Erik Brynjolfsson titled “The key to growth? Race with the machine”, the current winner of the freestyle chess championship is:

Answer 23

a team of humans working with computers

Question 24

According to the talk by Erik Brynjolfsson titled “The key to growth? Race with the machine” the new machine age is more about _____ than physical production.

Answer 24

knowledge

Question 25

According to the talk by Rachel Botsman, the advances in information technology are making it easier for us to share goods and services by increasing __________.

Answer 25

trust and efficiency

Question 26

Many companies have used better information flow (enabled by information systems) to

Answer 26

flatten their organization

Question 27

An online movie rental service has a database with a table called “Customer” for storing details about their customers. They also have a table named “DVD” to store details of each DVD (copy) that they own. The rental service would also like to store data on who has rented which DVD over time. The relationship between “Customer” and “DVD” tables is likely to be:

Answer 27

many to many

Question 28

Based on scenario presented in the previous question (#28), a customer is identified by Customer ID and a DVD is identified by DVD ID. A table that stores details of who has rented which DVD over time will have:

Answer 28

a. Customer ID as a foreign key
b. DVD ID as a foreign key
c. Customer ID and DVD ID as a part of the primary key
d. All of the above

Question 29

Companies can use data collected from customers during transactions to understand the customers’ preferences. This knowledge about customers can be used to better target and personalize the company’s sales and marketing efforts. It also helps to decrease the:

Answer 29

potential threat of new entrants

Question 30

What is the output of the following formula in Excel? IF(1>=1, IF(21,1,3,),2)+1

Answer 30

2

Question 31

What is the output of the following formula in Excel? IF(NOT(AND(1>1, 2>1)), 1, 2) + IF(NOT(OR(1>1, 2>1)), -1, 1)

Answer 31

2

Question 32

If a restaurant starts delivering food to customers using drones which of the primary activities of their value chain will they be directly effecting:

Answer 32

outbound logistics

Question 33

Which of these is not an advantage of using databases as opposed to spreadsheets?

Answer 33

analyzing and visualizing data

Question 34

There are __________ parameters in the following URL http://finance.yahoo.com/q/hp?s=AAPL*g=d

Answer 34

2

Question 35

In the online talk titled “The key to growth? Race with the machine”, Erik Brynjolfsson mentions ________ as the most important invention.

Answer 35

machine learning