MGMT 107 Midterm Sample Questions ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
(Moulik) with accurate solutions ||\\//|| ||\\//|| ||\\//||
One problem that prevented MIS from becoming a complete success was that
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) It only used Access to generate reports.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
B) By using MIS, middle managers often felt like "driving by rear view mirror."
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) It could only generate simple reports.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
D) It did not target top management. - correct answer✔✔B) By using MIS, middle
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
managers often felt like "driving by rear view mirror." ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
Which of the following statements is true? ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) The use of computer in businesses started from DSS
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
B) EDP failed and is no longer in use today
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) Strategic Information Systems target middle level managers
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
D) EIS still does not make decisions for top level executives - correct answer✔✔D) EIS still
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
does not make decisions for top level executives
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
Which of the following must you use for data mining?
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Operational database
||\\//|| ||\\//||
B) Entity Relationship Diagram
||\\//|| ||\\//|| ||\\//||
C) Informational data
||\\//|| ||\\//||
D) Forms - correct answer✔✔C) Informational data
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
Which of the following is designed to help an entire company?
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Enterprise collaboration system
||\\//|| ||\\//|| ||\\//||
,B) Strategic Information System
||\\//|| ||\\//|| ||\\//||
C) Decision Support System
||\\//|| ||\\//|| ||\\//||
D) Executive Information System - correct answer✔✔B) Strategic Information System
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A record corresponds to:
||\\//|| ||\\//|| ||\\//||
A) One character.
||\\//|| ||\\//||
B) A column in a table.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) A table. ||\\//|| ||\\//||
D) A row in a table. - correct answer✔✔D) A row in a table.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
Which of the following is a data mining task? ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Performing large scale customer profiling.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
B) Finding out why a particular order was canceled.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) Finding out the stock prices of our competitors.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
D) Calculating the total revenue of last quarter. - correct answer✔✔A) Performing large
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
scale customer profiling. ||\\//|| ||\\//||
What is the job of a database administrator (DBA)?
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Write SQL statements for each user.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
B) Entering data using forms.
||\\//|| ||\\//|| ||\\//|| ||\\//||
C) Create the data that fills the database.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
D) Control enterprise wide database development. - correct answer✔✔D) Control
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
enterprise wide database development. ||\\//|| ||\\//|| ||\\//||
Which of the following is a means of data output? ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Report ||\\//||
, B) Entity Relationship Diagram
||\\//|| ||\\//|| ||\\//||
C) Form ||\\//||
D) Table - correct answer✔✔A) Report
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
The goal of a data warehouse is to:
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Hold all the data needed by managers to make decisions.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
B) Keep all data instantly up to date.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) Contain all the company's data in one single location.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
D) Define the metadata. - correct answer✔✔A) Hold all the data needed by managers to
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
make decisions. ||\\//||
Which of the following can serve as the primary key for the order table?
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Date of order
||\\//|| ||\\//|| ||\\//||
B) Social security number of the buyer
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) Order number
||\\//|| ||\\//||
D) The combination of SSN and the order date - correct answer✔✔C) Order number
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A system that generates payroll record would be classified as a:
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Transaction Processing System
||\\//|| ||\\//|| ||\\//||
B) Management Information System
||\\//|| ||\\//|| ||\\//||
C) Decision Support System
||\\//|| ||\\//|| ||\\//||
D) Workflow System - correct answer✔✔A) Transaction Processing System
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
The failure of which type of system will leave you without scheduled report?
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Strategic Information System
||\\//|| ||\\//|| ||\\//||
B) Management Information System
||\\//|| ||\\//|| ||\\//||
(Moulik) with accurate solutions ||\\//|| ||\\//|| ||\\//||
One problem that prevented MIS from becoming a complete success was that
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) It only used Access to generate reports.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
B) By using MIS, middle managers often felt like "driving by rear view mirror."
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) It could only generate simple reports.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
D) It did not target top management. - correct answer✔✔B) By using MIS, middle
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
managers often felt like "driving by rear view mirror." ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
Which of the following statements is true? ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) The use of computer in businesses started from DSS
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
B) EDP failed and is no longer in use today
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) Strategic Information Systems target middle level managers
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
D) EIS still does not make decisions for top level executives - correct answer✔✔D) EIS still
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
does not make decisions for top level executives
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
Which of the following must you use for data mining?
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Operational database
||\\//|| ||\\//||
B) Entity Relationship Diagram
||\\//|| ||\\//|| ||\\//||
C) Informational data
||\\//|| ||\\//||
D) Forms - correct answer✔✔C) Informational data
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
Which of the following is designed to help an entire company?
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Enterprise collaboration system
||\\//|| ||\\//|| ||\\//||
,B) Strategic Information System
||\\//|| ||\\//|| ||\\//||
C) Decision Support System
||\\//|| ||\\//|| ||\\//||
D) Executive Information System - correct answer✔✔B) Strategic Information System
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A record corresponds to:
||\\//|| ||\\//|| ||\\//||
A) One character.
||\\//|| ||\\//||
B) A column in a table.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) A table. ||\\//|| ||\\//||
D) A row in a table. - correct answer✔✔D) A row in a table.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
Which of the following is a data mining task? ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Performing large scale customer profiling.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
B) Finding out why a particular order was canceled.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) Finding out the stock prices of our competitors.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
D) Calculating the total revenue of last quarter. - correct answer✔✔A) Performing large
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
scale customer profiling. ||\\//|| ||\\//||
What is the job of a database administrator (DBA)?
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Write SQL statements for each user.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
B) Entering data using forms.
||\\//|| ||\\//|| ||\\//|| ||\\//||
C) Create the data that fills the database.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
D) Control enterprise wide database development. - correct answer✔✔D) Control
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
enterprise wide database development. ||\\//|| ||\\//|| ||\\//||
Which of the following is a means of data output? ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Report ||\\//||
, B) Entity Relationship Diagram
||\\//|| ||\\//|| ||\\//||
C) Form ||\\//||
D) Table - correct answer✔✔A) Report
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
The goal of a data warehouse is to:
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Hold all the data needed by managers to make decisions.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
B) Keep all data instantly up to date.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) Contain all the company's data in one single location.
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
D) Define the metadata. - correct answer✔✔A) Hold all the data needed by managers to
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
make decisions. ||\\//||
Which of the following can serve as the primary key for the order table?
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Date of order
||\\//|| ||\\//|| ||\\//||
B) Social security number of the buyer
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
C) Order number
||\\//|| ||\\//||
D) The combination of SSN and the order date - correct answer✔✔C) Order number
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A system that generates payroll record would be classified as a:
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Transaction Processing System
||\\//|| ||\\//|| ||\\//||
B) Management Information System
||\\//|| ||\\//|| ||\\//||
C) Decision Support System
||\\//|| ||\\//|| ||\\//||
D) Workflow System - correct answer✔✔A) Transaction Processing System
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
The failure of which type of system will leave you without scheduled report?
||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//|| ||\\//||
A) Strategic Information System
||\\//|| ||\\//|| ||\\//||
B) Management Information System
||\\//|| ||\\//|| ||\\//||
