
















Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
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
1 / 24
This page cannot be seen from the preview
Don't miss anything!
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
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
gooficus = "troglodyte"print (
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