Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

MIS 2100 & MIS CH 7 Final Exam Review with Newest Answers, Exams of Biological Psychology

A comprehensive review of key concepts and topics covered in mis 2100 and mis ch 7, including database management, data warehousing, erp systems, and flowcharting. It features multiple-choice questions with correct answers, offering valuable practice for students preparing for their final exam. A wide range of topics, including data quality, database design, sql queries, data transformation, and programming concepts in python.

Typology: Exams

2024/2025

Available from 01/13/2025

Martin-Ray-1
Martin-Ray-1 ๐Ÿ‡บ๐Ÿ‡ธ

5

(8)

6K documents

1 / 24

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1 | P a g e
MIS 2100 & MIS CH 7 Final Exam
Review with Newest Answers
Anything that keeps a person from understanding the facts of a
circumstance with perfect objectivity is called... (Choose the best
answer.) - Correct Ans: โœ… Bias
Within a dataset, all the information related to one instance of
interest (e.g., a specific customer within a dataset of customer data)
is referred to as a... - Correct Ans: โœ… Record
A dataset includes information about a retail company's 100
different retail products. For each product, the dataset shows the
product name, the number sold in the last month, the average price
at which each was sold, as well as the average cost of acquisition.
Product name, number sold, average price, and average cost are,
therefore, ... - Correct Ans: โœ… Variables
Which of the following best corresponds with the idea of a "time-
appropriateness" data quality problem? - Correct Ans: โœ… In trying
to predict who would win this year's dog show, Eunice used a dataset
from 1993 exclusively.
Enabling different data points to relate to one another. - Correct
Ans: โœ… Is one of the core functions of a database.
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18

Partial preview of the text

Download MIS 2100 & MIS CH 7 Final Exam Review with Newest Answers and more Exams Biological Psychology in PDF only on Docsity!

MIS 2100 & MIS CH 7 Final Exam

Review with Newest Answers

Anything that keeps a person from understanding the facts of a circumstance with perfect objectivity is called... (Choose the best

answer.) - Correct Ans: โœ… Bias

Within a dataset, all the information related to one instance of interest (e.g., a specific customer within a dataset of customer data)

is referred to as a... - Correct Ans: โœ… Record

A dataset includes information about a retail company's 100 different retail products. For each product, the dataset shows the product name, the number sold in the last month, the average price at which each was sold, as well as the average cost of acquisition. Product name, number sold, average price, and average cost are,

therefore, ... - Correct Ans: โœ… Variables

Which of the following best corresponds with the idea of a "time-

appropriateness" data quality problem? - Correct Ans: โœ… In trying to predict who would win this year's dog show, Eunice used a dataset from 1993 exclusively.

Enabling different data points to relate to one another. - Correct

Ans: โœ… Is one of the core functions of a database.

A company includes information about its customers in a database table called Customer. Each line within this table includes a customer's name, phone number, address, and date of birth. These

lines are called... - Correct Ans: โœ… Records

A primary key is - Correct Ans: โœ… Required for each record

Databases - Correct Ans: โœ… Rely on primary and foreign keys to relate records from different tables.

In a company's database, a given table - Correct Ans: โœ… Can include millions of records

When there is a relationship between records in two different tables

  • Correct Ans: โœ… The mandatory side donates its key to the many side

A data dictionary - Correct Ans: โœ… Describes every field in each table

What does the FROM clause do within a SQL SELECT query? - Correct

Ans: โœ… Tells the database what table(s) to pull data from

What clause would you use in order to display a query's output

alphabetically based on last name? - Correct Ans: โœ… ORDER BY

Which of the following is most likely to have to handle hundreds of queries simultaneously, some reading data and others writing data? -

Correct Ans: โœ… Operational Database

One reason that data must be transformed before being loaded from

the operational database to the data warehouse is that - Correct

Ans: โœ… The data in the operational database may use different fields than the data in the data warehouse.

Often, when data from the data warehouse is loaded into a specific

data mart - Correct Ans: โœ… Data are denormalized into fewer tables

Which of the following is true regarding data marts? - Correct Ans:

โœ… They usually contain data specific to one function or group within the organization.

A professor who doesn't fully trust Canvas keeps students' actual grades in a spreadsheet saved on his desktop computer. From the

university's perspective, this spreadsheet is an example of.. - Correct

Ans: โœ… Loose data

One big reason that ERP systems are widely used in large

organizations is - Correct Ans: โœ… To make it easier for top executives to know what's going on in the company.

Because ERP systems are modular - Correct Ans: โœ… Companies can add a new process to their already-established ERP system relatively easily.

I just bought a brand new video game console as well as 30 new games that go with it and that are exclusive to my console. As a result, I'm pretty hesitant to switch my gaming away from my current console and onto a competitor console. This is an example of

which of the following? - Correct Ans: โœ… Lock in

Because ERPs aren't perfect, many very large companies - Correct

Ans: โœ… Use ERPs for some processes, but not for others.

A proper flowchart progresses in what direction(s) - Correct Ans: โœ… Down and to the right.

What is the maximum number of lines that can flow OUT of a

process symbol? - Correct Ans: โœ… 1

My process needs to do one thing if I see a rabbit, but do something else entirely if there are no rabbits to be seen. What symbol handles

this situation? - Correct Ans: โœ… Decision

And then, if I DO see a rabbit, then I follow 10 very specific steps. If I don't see a rabbit, then I follow an entirely different set of 23 steps.

This is an example of a(n) - Correct Ans: โœ… Fork

I have three variables: dog, cat, and chicken. I want to output the values of each of them. Which of the following (if entered on a single

line as shown) would you expect to do so? - Correct Ans: โœ… print(dog, cat,chicken)

What would be the output of the following?

m, n = "dog", "cat"x = m + "|" + nprint ("x is:", x) - Correct Ans: โœ… x is: dog|cat

What would be the output of the following?

fred = 4 ** 2print (fred) - Correct Ans: โœ… 16

If you wanted to write a conditional statement that would be true whenever the integer variables a and b have the same value, which

of the following would work? - Correct Ans: โœ… a == b

Say you want to obtain an output of 10 using the code below. What should go in the place of to obtain this output?

gooficus = "troglodyte"print ((gooficus)) - Correct Ans: โœ… len

What would be the output of the following?

z = 30

if (z > 30):

print ("z is very great")

elif (z < 30):

print ("z is not so great")

else:

print ("please re-check your z") - Correct Ans: โœ… please re-check your z

When your program runs and the user is prompted to input

something, the user's input - Correct Ans: โœ… Should be assigned to a variable

What would be the output of the following?

formats = ["slalom", "giant slalom", "super-g", "downhill"]

print(formats[4]) - Correct Ans: โœ… An error, since there's no value that corresponds to formats[4].

Given formats = ["slalom", "giant slalom", "super-g", "downhill"], if we wanted to add the value "ultra-downhill" to become the last element in formats, which of the following would accomplish that? -

Correct Ans: โœ… formats.append("ultra-downhill")

What would be the output of the following?

corgtype = "Pembroke"

print(corgtype[2:4]) - Correct Ans: โœ… mb

What would be the output of the following?

autocorrectisawful = 4

for x in formats:

if (x == "super-g"):

print("this one")

else:

print("nope") - Correct Ans: โœ… nope, nope, this one, nope

When establishing the connection between Python and SQL Server in your Python code, indicating "yes" for a trusted connection means

that - Correct Ans: โœ… The program doesn't need a user ID and password to access the database.

When I tried to write Python code to run SELECT queries, it worked, but when I tried to use INSERT, I got an error back. Which of the

following might have caused this? - Correct Ans: โœ… The account I connected with doesn't have permission to make changes to the database.

If I want to write a SELECT query that pulls records in which a certain field's value matches the value of a variable I declared in my

program, the query I type into my Python code must - Correct Ans:

โœ… Include a placeholder.

In the Python code shown below, assuming that tables and fields references are valid, what mistake, if any, is present?

ix = 7cursor.execute("SELECT * FROM Dogfood WHERE Qty > ix") -

Correct Ans: โœ… Should use %d instead of ix in the query.

When the query you wrote via your Python IDE causes an error in

SQL Server - Correct Ans: โœ… You'll see details regarding the error in the console.

When I write a SELECT query via Python, each row of output is

represented in the program as - Correct Ans: โœ… A Tuple

Python list allows - Correct Ans: โœ… Appending additional items to it.

Your program includes the following line:

cursor.execute("SELECT dogfname, doglname, dogage, dogspeed FROM Dog")

What code shown below would print (to the console) each line out

output returned by the query? - Correct Ans: โœ… for zog in cursor: print(zog)

In Python, to cause a new record to be created in a table - Correct

Ans: โœ… You must first execute the query, then commit it.

To validate user input against data included in the database - Correct

Ans: โœ… Set up a while loop that continues until the user input matches the content outputted by the database.

Which one of the following is the best example of a project? -

Correct Ans: โœ… Having been given a court order to do so, Walter writes a one-page letter to his friend in Ottawa.

requisitioner) gets together to discuss how the project went. This

meeting is referred to as - Correct Ans: โœ… Post-Mortem

According to the Waterfall methodology - Correct Ans: โœ… Once the planning phase is done, the phase is not revisited.

Which of the following, if true, would make it MORE LIKELY that Agile would be a better methodology to pursue rather than Waterfall? -

Correct Ans: โœ… The client has only a vague sense of what the software should do.

A development project is originally scheduled to take 12 months to complete. During month three, however, the CEO is told by the board of directors that she needs to show that she can get things done and that she has six months to prove it to them. As a result, she insists that this important project be done in only four more months.

Given this new, accelerated timeline, which of the following is likely

to occur? - Correct Ans: โœ… The cost will go up and/or the scope of the project will need to shrink.

Using data to project an outcome that will happen in the future is referred to as

Using data regarding things that have already happened in order to understand what the factors were that caused them to happen is referred to as

These two different ways of using data, taken together, represent

forms of - Correct Ans: โœ… predictive analysis

diagnostic analysis

data analysis

As a professor, I receive an annual bonus based on the number of students I coerce into majoring in MIS, the amount of donations made by parents and families of students who take my class, and the percentage of students who say that my class was "good" (or better) in end-of-semester evaluations. These three measurements, then, could probably be considered... (Choose the best answer. Also, this doesn't really happen -- I don't get a bonus no matter what I do -

Correct Ans: โœ… KPIs

I want to know what my brother's four kids think about Disneyworld. I therefore administer a survey to those four kids, with no intention of using the information to understand anything other than how those specific four kids feel. Therefore, in this context, these four

kids represent a - Correct Ans: โœ… Population

For a midterm exam, student scores from Section 1 have a standard deviation of 15.5%, while student scores from Section 2 have a standard deviation of 38.9%. This tells us that, as compared to

Section 1, in Section 2 - Correct Ans: โœ… More students' scores were probably further away from than the mean.

Failures per day, explosions per week, and average monthly

rumblings are all examples of which of the following? - Correct Ans:

โœ… Rates

After running a balanced scorecard analysis, the balanced scorecard showed that Option 1 had a slightly higher score than Option 2. After considering the analysis, the company chose Option 2 anyway. This

analysis nevertheless likely represents a good use of time - Correct

Ans: โœ… True

When completing a balanced scorecard analysis, all criteria values

should - Correct Ans: โœ… Use the same scale

When using Percent-of-Range normalization - Correct Ans: โœ… One criteria has a normalized value of 100% and another always has a value of 0%.

After flipping an old coin from the Soviet Union 100 times, the coin comes up heads 37 times and hammer-and-sickle 63 times. The

probability of the coin coming up heads is therefore - Correct Ans:

โœ….

The probability of Frank passing this class is 20%, the probability of Emma June passing is 10%, and the probability of Delbert passing is 50%. What is the probability that ALL THREE will pass the class? -

Correct Ans: โœ… 1%

The probability of Frank passing this class is 20%, the probability of Emma June passing is 10%, and the probability of Delbert passing is 50%.

To the nearest tenth of a student, how many of these three students

do you expect to pass the class? - Correct Ans: โœ….

One day, an elf jumps out at you from behind a garbage can and proposes a wager. He says that if the weather in Leipzig, Germany tomorrow is sunny, he'll give you $10, if it's cloudy (but dry) he'll give you $1, but if neither of those are the case you owe him $20. Helpfully, he also provides you data that indicates that the probability of sunny weather in Leipzig tomorrow is 40% and cloudy- but-dry is 10%. How much do you expect to win or lose from this

wager (if you accept it) - Correct Ans: โœ… Lose 5.

True or false: IT Infrastructures are always the result of detailed,

intentional planning. - Correct Ans: โœ… False

When I use Google Docs, I create, edit, save, and share documents through my Web browser. In this situation, my Web browser is acting

as a(n). - Correct Ans: โœ… Client

I've found some really cool software that will help save our company billions of dollars. Unfortunately, it only runs on MacOS and most of the company uses Windows computers. One way to enable most of the company to use this really cool software would be through -

Correct Ans: โœ… Virtualization

Which of the following is a DISADVANTAGE of internally-managed

infrastructure? - Correct Ans: โœ… Your IT personnel need to be aware of all security updates and ensure that they are installed as soon as possible.

If you ever take a job on campus (!), thereafter (almost) every time you try to log in to Canvas, you'll have to enter your A-number and password, then check your phone (or other device) to approve your

own attempt to log in. This is an example of - Correct Ans: โœ… Two- Factor Authentication

How is spearphishing different from phishing - Correct Ans: โœ… Spearphishing attempts to acquire the credentials of a specific individual.

Which of the following is NOT a forced entry threat that a company's

IT security team needs to consider? - Correct Ans: โœ… Malicious Insiders

Imogene is a bad person. Just for fun, she writes code that commandeers thousands of other computers connected to the Internet, then uses them to make fake requests of different Internet celebrities' websites such that these websites can't really provide information to the people who (for some reason) actually want to

visit them. In doing this, Imogene is perpetrating - Correct Ans: โœ… DDOS Attacks

You and I both go to the cryptography store on Main Street (near the breakfast district) and purchase identical decoder rings. This way, I can send you a coded message and you can decode it using your ring.

This is an example of - Correct Ans: โœ… Symmetric Cryptography

Because the university is worried about unauthorized access to its networks, in order for you to access some university resources while

at home, you first need to log in through the ________. - Correct

Ans: โœ… VPN

An advantage that enterprise systems have over standalone

applications is the __________. - Correct Ans: โœ… availability of a single database to store information from multiple sources

Which of the following is an ERP extended component? - Correct

Ans: โœ… Supply chain management

Goods and Supply, a retail outlet, uses an enterprise resource planning system for capturing product data, modifying its sale prices, and processing card payments.

Which of the following process types is associated with selling a

product or service? - Correct Ans: โœ… order to cash process

Which of the following is the primary reason why enterprise system

implementations fail? - Correct Ans: โœ… Lack of top-level management support

__________ is ERP software designed to operate according to industry-standard business processes, and vendors offer many industry-specific versions that have already been customized for

particular industries based on best practices. - Correct Ans: โœ… Best practices-based software