MIS Final - Quizzes

What would be the output of the following? corgtype = "Pembroke" print(corgtype[2:4])

mb

Because ERP systems are modular...

Companies can add a new process to their already-established ERP system *relatively* easily.

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?

1%

Four students take an exam (!). Their scores are 20, 22, 27, and 31. The mean score for the four students is [ 1] . The median score for the four students is [ 2] .

1. 25 2. (22+27)/2

What would be the output of the following? fred = 4 ** 2 print (fred)

16

John's Luxury Wagon-Hitchers made $1,500 in revenue last week and spent $1,245. What, therefore, was the company's profit?

255

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...

.37

Using the same information from above... 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?

.8

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

1

At a certain point in the flowchart, different next steps need to be taken depending on whether the sky is sunny vs. cloudy vs. rainy vs. full of burning sulfuric clouds (i.e., based on which of the four sky conditions are currently in effect, the process follows one of four wholly unique sets of steps). Which of the following would facilitate the flowchart moving off into the correct set of steps based on the sky condition?

3 different decisions symbols

What would be the output of the following? autocorrectisawful = 4 while (autocorrectisawful > 0): print(autocorrectisawful) if (autocorrectisawful == 2): break autocorrectisawful -= 1

4 3 2

Consider the table below, called Roster. If I wanted to determine what the average PtsPerGame value was by position (e.g., how many points per game are scored on average by those listed as chasers), which of the following would need to be part of my query?

A GROUP BY clause

Which of the following is true regarding environments?

A software project is coded in the dev environment and goes live into the production environment.

When I write a SELECT query via Python, each row of output is represented in the program as...

A tuple

Sometimes it's useful to "store information" within a flowchart (e.g., something that the user has inputted). We often do this by using which of the following?

A variable

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

Bias

Which aggregate function would you use (in the SELECT clause) if you wanted to know the total number of magicians in the Magician table who are from Albuquerque?

Count

In a balanced scorecard, Criterion 1 has a weight of 5, and Criterion 2 has a weight of 15. This means that, in the final calculation... (Choose the best answer.)

Criterion 2 is three times as important as Criterion 1.

Often, when data from the data warehouse is loaded into a specific data mart... (Choose the best answer.)

Data are denormalized into fewer tables.

Considering only the FROM clause of a query, which of the following would successfully assign aliases to the tables Article, Category, and Writer?

FROM Article A, Category C, Writer W

Which of the following best corresponds with the components that comprise a data ecosystem?

Data storage, hardware, processes, and reporting tools.

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?

Decision

A data dictionary... (Choose the best answer.)

Describes every field in each table.

A proper flowchart progresses in what direction(s)?

Down and to the right

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)...

Fork

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

Having been given a court order to do so, Walter writes a one-page letter to his friend in Ottawa.

After years of study, you find that, on average, there are 4.1 house flies that come to your indoor house fly feeder during the winter months, but only 0.7 during the summer months. Which of the following represents a reasonable hypothesis to make given this observation? (Choose the best answer.)

House flies have fewer outside food sources when it's cold.?

Which one of the following is true?

If there's not a GROUP BY clause, there shouldn't be a HAVING clause.

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 :(.)

KPIs

Which of the following best corresponds with the idea of a "time-appropriateness" data quality problem?

In trying to predict who would win this year's dog show, Eunice used a dataset from 1993 exclusively.

While creating a flowchart, you reach a step that seems like an action, but also requires input. This step should probably be shown as... (Choose the best answer.)

Input

he MIDDLE JOIN command...

Is not a SQL command.

When joining tables...

It is necessary to match the foreign key in one table to the primary key in another within the query.

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

Operational Database

After calculating the IRR, you compare the IRR value to the discount rate to determine whether the project makes sense. Why do you care about the discount rate? (Choose the best answer.)

It represents what the company would get back if they instead invested the money in an alternative investment such as the stock market.

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?

Lock-in

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...

Loose Data

What clause would you use in order to display a query's output alphabetically based on last name?

ORDER BY

When using Percent-of-Range normalization, ... (Choose the best answer.)

One criteria has a normalized value of 100% and another always has a value of 0%.

Sally performed an NPV calculation for her company's proposal to build a nuclear power plant on the ocean waters right above the Great Barrier Reef. Her calculation showed an NPV of -$10 (negative 10 dollars). This tells us that... (Choose the best answer.)

Over the time span considered, the project will create greater costs than can be accounted for using the discount rate.

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..

Record

Databases... (Select the most applicable answer.)

Rely on primary and foreign keys to relate records from different tables.

Which of the following SELECT clauses would you use if you wanted to show the average temperature (from the AvgTemp field) for each city in the City table, but with an additional 5% added to the average temperature to account for projected global warming? The correct answer should also rename the column of calculated outputs "AdjTemp".

SELECT AvgTemp * 1.05 AS [AdjTemp]

Assuming that table and fields referenced are valid, which of the following queries has appropriate syntax and would work without error?

SELECT PlayerName, Position, Height FROM Roster WHERE Height > 63 ORDER BY Position;

To validate user input against data included in the database... (Choose the best answer.)

Set up a while loop that continues until the user input matches the content outputted by the database.

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")

Should use %d instead of ix in the query.

When an IT department develops a major new software system, they follow which one of the following?

Systems development life cycle

What does the FROM clause do within a SQL SELECT query? (Select the best answer.)

Tells the database what table(s) to pull data from.

One reason that data must be transformed before being loaded from the operational database to the data warehouse is that... (Choose the best answer.)

The data in the operational database may use different fields than the data in the data warehouse.

When there is a relationship between records in two different tables...

The mandatory side donates its key to the many side.

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

The program doesn't need a user ID and password to access the database.

Which of the following is true regarding data marts? (Choose the best answer.)

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

One big reason that ERP systems are widely used in large organizations is...

To make it easier for top executives to know what's going on in the company.

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.

True

If we wanted to output every element of the list named atrociousness, what word would you put in place of the placeholder marked <answer> in the code below? atrociousness = [1, 3, 5, 7, 11, 13, 17, 19] <answer> y in atrociousness: print (y)

for

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?

for zog in cursor: print(zog)

Because ERPs aren't perfect, many very large companies...

Use ERPs for some processes, but not for others.

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?

formats.append("ultra-downhill")

Assuming that the user's input is the word "giraffe", what would be the output of the following? stopcorrectingmyvars = input("How old are you? ") try: x = int(stopcorrectingmyvars) print("Your age: ", x) except: print (stopcorrectingmyvars, "is not a valid age.")

giraffe is not a valid age

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, ...

Variables

Using a database that includes information about every opera ever written, I want to write a query that displays information about only those operas that were written prior to the year 1825. To do this, I would use which of the following?

WHERE Clause

Which of the following WHERE clauses would include only those records from the Customer table where the customer's last name (the LastName field) starts with Y and the customer's birthday (DOB field) falls some time after 1994?

WHERE LastName LIKE 'Y%' AND DOB > '1994-12-31'

During which phase does a new software project arrive in the production environment?

implementation

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... (Choose the best answer.)

include placeholder

When joining three tables within the same query, which of the following is true?

You create a "virtual table" that includes matching records from all three tables.

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

is one of the core functions of the database

Say you want to obtain an output of 10 using the code below. What should go in the place of <Answer> to obtain this output? gooficus = "troglodyte" print (<Answer>(gooficus))

len

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)? (You can use a calculator on this one.)

loses 5.9

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?

a == b

Which of the answers below best describes (a) a float, (b) an integer, and (c) a string?

a. any real number b. any whole number c. any text value

What would be the output of the following? formats = ["slalom", "giant slalom", "super-g", "downhill"] print(formats[4])

an error

You've just been made the requisitioner for a new software project at your company. During which of the following stages would you go about soliciting the wants and needs of people in the company who will be affected by the project's outcome? (Choose the best answer.)

analysis?

Unlike a tuple, a Python list allows...

appending additional items into it

A flowchart is particularly valuable in that it enables us to... (Choose the best answer.)

break a process into component parts

In a company's database, a given table... (Choose the best answer.)

can include millions of records

What would be the output of the following? print ("cat")

cat

Yolanda is designing a website. She has created, in Photoshop, a design that clearly depicts exactly what the website's homepage should look like. This design is commonly referred to as a...:

comp

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?

cost will go up and the scope will need to shrink

What would be the output of the following? formats = ["slalom", "giant slalom", "super-g", "downhill"] for x in formats: if (x == "super-g"): print("this one") else: print("nope")

nope nope this one nope

According to the Waterfall methodology...

once the planning phase is done it is not revistited

Because you decided to pursue a university education this semester, you therefore did not spend the semester teaching your nephew how to whistle. In this scenario, not teaching your nephew how to whistle can be seen as a(n)... (Choose the best answer.)

opportunity costs

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")

please re-check your z

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... (Choose the best answer.)

population

Some time after a new piece of developed software is completed and made available to end users, the development team (including the requisitioner) gets together to discuss how the project went. This meeting is referred to as... (Choose the best answer.)

post mortem

Using data to project an outcome that will happen in the future is referred to as [ 1] . 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 [ 2] . These two different ways of using data, taken together, represent forms of [ 3] .

predictive analysis descriptive analysis data analysis

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?

print(dog, cat,chicken)

Which of the following is NOT on the "client side" during an IT project's development?

project analysis

Failures per day, explosions per week, and average monthly rumblings are all examples of which of the following? (Choose the best answer.)

rates

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...

records

A primary key is...

required for each record

An IDE allows you to... (Choose the best answer.)

see your code as well as the output when you run it

When your program runs and the user is prompted to input something, the user's input... (Choose the best answer.)

should be assigned a variable

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

the client only has a fague sense of what the softwre should do

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...

the more the children's scores were far from the mean

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? (Choose the best answer.)

this accoutn does not have permission to make changes int he database

When completing a balanced scorecard analysis, all criteria values should... (Choose the best answer.)

use the same scale

What would be the output of the following? m, n = "dog", "cat" x = m + "|" + n print ("x is:", x)

x is: dog|cat

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

you must first execute a query, then commit it

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

you'll see details regarding the error in the console