MIS 2100 Final Review WITH 104 QUESTIONS AND
ANSWERS NEWEST RATED A+ 2025/2026 100% VERIFIED
CORRECT
Anything that keeps a person from understanding the facts of a circumstance with perfect
objec vity is called... (Choose the best answer.) - Ans Bias
Within a dataset, all the informa on related to one instance of interest (e.g., a specific
customer within a dataset of customer data) is referred to as a... - Ans Record
A dataset includes informa on 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 acquisi on. Product name, number
sold, average price, and average cost are, therefore, ... - Ans Variables
Which of the following best corresponds with the idea of a " me-appropriateness" data quality
problem? - 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. - Ans Is one of the core func ons of a
database.
A company includes informa on 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... - Ans Records
A primary key is - Ans Required for each record
, Databases - Ans Rely on primary and foreign keys to relate records from different tables.
In a company's database, a given table - Ans Can include millions of records
When there is a rela onship between records in two different tables - Ans The mandatory side
donates its key to the many side
A data dic onary - Ans Describes every field in each table
What does the FROM clause do within a SQL SELECT query? - Ans Tells the database what
table(s) to pull data from
What clause would you use in order to display a query's output alphabe cally based on last
name? - Ans ORDER BY
T/F If there's not a GROUP BY clause, there shouldn't be a HAVING clause. - Ans True
Using a database that includes informa on about every opera ever wriAen, I want to write a
query that displays informa on about only those operas that were wriAen prior to the year
1825. To do this, I would use which of the following? - Ans WHERE clause
Which aggregate func on 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? - Ans COUNT
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 addi onal 5%
added to the average temperature to account for projected global warming? The correct answer
should also rename the column of calculated outputs "AdjTemp" - Ans SELECT AvgTemp * 1.05
AS [AdjTemp]
ANSWERS NEWEST RATED A+ 2025/2026 100% VERIFIED
CORRECT
Anything that keeps a person from understanding the facts of a circumstance with perfect
objec vity is called... (Choose the best answer.) - Ans Bias
Within a dataset, all the informa on related to one instance of interest (e.g., a specific
customer within a dataset of customer data) is referred to as a... - Ans Record
A dataset includes informa on 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 acquisi on. Product name, number
sold, average price, and average cost are, therefore, ... - Ans Variables
Which of the following best corresponds with the idea of a " me-appropriateness" data quality
problem? - 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. - Ans Is one of the core func ons of a
database.
A company includes informa on 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... - Ans Records
A primary key is - Ans Required for each record
, Databases - Ans Rely on primary and foreign keys to relate records from different tables.
In a company's database, a given table - Ans Can include millions of records
When there is a rela onship between records in two different tables - Ans The mandatory side
donates its key to the many side
A data dic onary - Ans Describes every field in each table
What does the FROM clause do within a SQL SELECT query? - Ans Tells the database what
table(s) to pull data from
What clause would you use in order to display a query's output alphabe cally based on last
name? - Ans ORDER BY
T/F If there's not a GROUP BY clause, there shouldn't be a HAVING clause. - Ans True
Using a database that includes informa on about every opera ever wriAen, I want to write a
query that displays informa on about only those operas that were wriAen prior to the year
1825. To do this, I would use which of the following? - Ans WHERE clause
Which aggregate func on 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? - Ans COUNT
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 addi onal 5%
added to the average temperature to account for projected global warming? The correct answer
should also rename the column of calculated outputs "AdjTemp" - Ans SELECT AvgTemp * 1.05
AS [AdjTemp]
