OPIM 3103 HW 2

7 September 2022
4.7 (114 reviews)
25 test answers

Unlock all answers in this set

Unlock answers (21)
question
Which of the following statements is true about business intelligence? A) It is the act of outsourcing tasks, traditionally performed by an employee or contractor, to an undefined, large group of people or community, through the use of information technology. B) It is the process by which a customer-owned mutual organization or co-operative changes legal form to a joint stock company. C) It is the use of information systems to gather and analyze information from internal and external sources in order to make better business decisions. D) It is an organization's process of defining its strategy, or direction, and making decisions on allocating its resources to pursue this strategy, including its capital and people. E) It is the use of human resources to gather and analyze information from external sources in order to make better business decisions.
answer
C) It is the use of information systems to gather and analyze information from internal and external sources in order to make better business decisions.
question
Responding to threats and opportunities and continuous planning are based on analyzing internal data primarily from the ________ level of the organization. A) operational B) executive C) tactical D) business E) strategic
answer
A) operational
question
When we consider entities as tables, each column is a(n) ________. A) attribute B) record C) form D) bot E) query
answer
A) attribute
question
When we consider entities as tables, each row is a(n) ________. A) field B) record C) attribute D) form E) query
answer
B) record
question
In DBMS, data are kept separate from the application's programming code. This means that ________. A) an application cannot be changed without making changes to the database B) an application's programming code needs to be updated continuously to keep up with the database C) an application needs to be changed when database is changed D) a database does not need to be changed if a change is made to an application E) a database needs to be changed when a change is made to an application
answer
D) a database does not need to be changed if a change is made to an application
question
One of the advantages of the database approach is program-data independence, which means that it is ________. A) easier to deploy and control data access using a centralized system B) easier to evolve and alter software to changing business needs when data and programs are independent C) a centralized system, making it easier to enforce access restrictions D) a centralized system, making it much easier to enforce standards and rules for data creation, modification, naming, and deletion E) useful for eliminating redundancy, greatly reducing the possibilities of inconsistency
answer
B) easier to evolve and alter software to changing business needs when data and programs are independent
question
Once the data model is created, the format of the data is documented in a(n) ________. A) data warehouse B) data mart C) expert system D) data type E) data dictionary
answer
E) data dictionary
question
Treston, an automobile manufacturer, has recently implemented a new database system. It is confident that this system will help enhance the company's internal (employees) and external (customers and channel partners) communication. Treston is planning to pursue a just-in-time inventory system soon after the database system is implemented. After the implementation of the database system, however, Treston realized that the database system was not effective. Which of the following, if true, can be cited as a reason for the failure of Treston's database system? A) Microsoft launched a new version of Enterprise Microsoft Access which is better than Treston's database system. B) The maintenance cost of Treston's new database system was less than the one it was previously using. C) Treston's new database system was not supported by the database system of its suppliers and distributors. D) Treston's competitors implemented its database a few days prior to Treston's implementation date. E) Treston had internally trained personnel managing its new database system, keeping costs low.
answer
C) Treston's new database system was not supported by the database system of its suppliers and distributors.
question
Business rules are captured by the designers of the database and included in the data dictionary to ________. A) organize and sort the data, complete calculations, and allocate storage space B) prevent illegal or illogical entries from entering the database C) eliminate data duplication D) make sure that each table contains only attributes that are related to the entity E) capture the structure of the database
answer
B) prevent illegal or illogical entries from entering the database
question
A query is used to ________. A) organize and sort the data in a database B) allocate storage space for a database C) eliminate data duplication D) retrieve data from a database E) prevent illegal or illogical entries from entering the database
answer
D) retrieve data from a database
question
Which of the following statements is true about query by example (QBE) capabilities in a database? A) It helps to create a query quickly and easily. B) It refers to immediate automated responses to the requests of users. C) It is designed to handle multiple concurrent transactions from customers. D) It is primarily used in gathering new information. E) It prevents illegal entries into a database.
answer
A) It helps to create a query quickly and easily.
question
The systems that are used to interact with customers and run a business in real time are called ________. A) tactical systems B) strategic systems C) operational systems D) informational systems E) executive systems
answer
C) operational systems
question
________ integrates data from various operational systems. A) A data warehouse B) A metadata repository C) Data modeling D) Master data E) Data mining
answer
A) A data warehouse
question
________ involves standardizing the format of data retrieved from different systems. A) Data cleansing B) Data mining C) Normalization D) Content mining E) Clustering
answer
A) Data cleansing
question
A ________ is a data warehouse that is limited in scope. A) metadata repository B) master data C) data model D) data reduction E) data mart
answer
E) data mart
question
Which of the following statements is true about key-indicator reports? A) They provide a summary of critical information on a recurring schedule. B) They help analyze why a key indicator is not at an appropriate level or why an exception occurred. C) They are produced at predefined intervals to support routine decisions. D) They highlight situations that are out of the normal range. E) They answer unplanned information requests to support a nonroutine decision.
answer
A) They provide a summary of critical information on a recurring schedule.
question
Which of the following statements is true about ad hoc queries? A) They are produced at predefined intervals to support routine decisions. B) They provide a summary of critical information on a recurring schedule. C) They help analyze why a key indicator is not at an appropriate level or why an exception occurred. D) They answer unplanned information requests to support a nonroutine decision. E) They highlight situations that are out of the normal range.
answer
D) They answer unplanned information requests to support a nonroutine decision.
question
________ refers to the process of quickly conducting complex, multidimensional analyses of data stored in a database that is optimized for retrieval, typically using graphical software tools. A) Inferencing B) Online analytical processing C) Normalization D) Data mining E) Predictive analysis
answer
B) Online analytical processing
question
Which of the following statements is true about association discovery? A) It is a technique used to find correlations among sets of items. B) It is the process of grouping related records together on the basis of having similar values for attributes. C) It is the use of analytical techniques for extracting information from textual documents. D) It is a type of intelligent system that uses reasoning methods based on knowledge about a specific problem domain in order to provide advice. E) It makes sure that each table contains only attributes that are related to the entity.
answer
A) It is a technique used to find correlations among sets of items.
question
Which of the following is a recording of a user's path through a Web site? A) clustering B) normalization C) slicing and dicing D) clickstream data E) inferencing
answer
D) clickstream data
question
Business analytics augments business intelligence by using ________ analysis to help identify trends or predict business outcomes. A) what-if B) visual C) predictive D) multivariate E) time-series
answer
C) predictive
question
Which of the following analyses involves making hypothetical changes to the data associated with a problem and observing how these changes influence the results? A) predictive analysis B) time-series analysis C) linear regression analysis D) what-if analysis E) multivariate analysis
answer
D) what-if analysis
question
The processing in an expert system (ES) is called ________. A) clustering B) inferencing C) normalizing D) recommending E) data cleansing
answer
B) inferencing
question
________ refers to the display of complex data relationships using a variety of graphical methods. A) Normalization B) Visualization C) Clustering D) Inferencing E) Textual mining
answer
B) Visualization
question
Digital dashboards provide the decision makers with a quick overview of key performance indicators and other key operational statistics and trends. This usage model is known as ________. A) exception reporting B) pull reporting C) ad hoc reporting D) drill-down reporting E) push reporting
answer
E) push reporting