©THEBRIGHT 2024/2025 ALL RIGHTS RESERVED.
MIS 2100 Final Review Exam Questions And
Answers 100% Guaranteed Pass.
Anything that keeps a person from understanding the facts of a circumstance with perfect
objectivity is called... (Choose the best answer.) - Answer✔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... - Answer✔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, ... - Answer✔Variables
Which of the following best corresponds with the idea of a "time-appropriateness" data quality
problem? - Answer✔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. - Answer✔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... - Answer✔Records
A primary key is - Answer✔Required for each record
Databases - Answer✔Rely on primary and foreign keys to relate records from different tables.
In a company's database, a given table - Answer✔Can include millions of records
When there is a relationship between records in two different tables - Answer✔The mandatory
side donates its key to the many side
A data dictionary - Answer✔Describes every field in each table
What does the FROM clause do within a SQL SELECT query? - Answer✔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? - Answer✔ORDER BY
1|Page
, ©THEBRIGHT 2024/2025 ALL RIGHTS RESERVED.
T/F If there's not a GROUP BY clause, there shouldn't be a HAVING clause. - Answer✔True
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? - Answer✔WHERE clause
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? - Answer✔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 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" - Answer✔SELECT AvgTemp
* 1.05 AS [AdjTemp]
When joining tables - Answer✔It is necessary to match the foreign key in one table to the
primary key in another within the query.
Which of the following best corresponds with the components that comprise a data ecosystem? -
Answer✔Data storage, hardware, processes, and reporting tools.
Which of the following is most likely to have to handle hundreds of queries simultaneously,
some reading data and others writing data? - Answer✔Operational Database
One reason that data must be transformed before being loaded from the operational database to
the data warehouse is that - Answer✔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 - Answer✔Data are
denormalized into fewer tables
Which of the following is true regarding data marts? - Answer✔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.. -
Answer✔Loose data
One big reason that ERP systems are widely used in large organizations is - Answer✔To make it
easier for top executives to know what's going on in the company.
Because ERP systems are modular - Answer✔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? -
Answer✔Lock in
2|Page
MIS 2100 Final Review Exam Questions And
Answers 100% Guaranteed Pass.
Anything that keeps a person from understanding the facts of a circumstance with perfect
objectivity is called... (Choose the best answer.) - Answer✔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... - Answer✔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, ... - Answer✔Variables
Which of the following best corresponds with the idea of a "time-appropriateness" data quality
problem? - Answer✔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. - Answer✔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... - Answer✔Records
A primary key is - Answer✔Required for each record
Databases - Answer✔Rely on primary and foreign keys to relate records from different tables.
In a company's database, a given table - Answer✔Can include millions of records
When there is a relationship between records in two different tables - Answer✔The mandatory
side donates its key to the many side
A data dictionary - Answer✔Describes every field in each table
What does the FROM clause do within a SQL SELECT query? - Answer✔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? - Answer✔ORDER BY
1|Page
, ©THEBRIGHT 2024/2025 ALL RIGHTS RESERVED.
T/F If there's not a GROUP BY clause, there shouldn't be a HAVING clause. - Answer✔True
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? - Answer✔WHERE clause
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? - Answer✔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 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" - Answer✔SELECT AvgTemp
* 1.05 AS [AdjTemp]
When joining tables - Answer✔It is necessary to match the foreign key in one table to the
primary key in another within the query.
Which of the following best corresponds with the components that comprise a data ecosystem? -
Answer✔Data storage, hardware, processes, and reporting tools.
Which of the following is most likely to have to handle hundreds of queries simultaneously,
some reading data and others writing data? - Answer✔Operational Database
One reason that data must be transformed before being loaded from the operational database to
the data warehouse is that - Answer✔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 - Answer✔Data are
denormalized into fewer tables
Which of the following is true regarding data marts? - Answer✔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.. -
Answer✔Loose data
One big reason that ERP systems are widely used in large organizations is - Answer✔To make it
easier for top executives to know what's going on in the company.
Because ERP systems are modular - Answer✔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? -
Answer✔Lock in
2|Page
