Database - Database Processing for BIS

Exercise : Database Processing for BIS - General Questions
11.
Business Intelligence (BI) reporting analyses can be performed using ________ .
standard SQL only
extensions to SQL only
OLAP only
both standard SQL and extensions to SQL
Answer: Option
Explanation:
No answer description is available. Let's discuss.

12.
We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .
dirty data
inconsistent data
non-integrated data
a "wrong format" problem
Answer: Option
Explanation:
No answer description is available. Let's discuss.

13.
The reports generated by a reporting system are usually not delivered in which of the following media?
Web portal
Commercial courier service
Digital dashboard
E-Mail
Answer: Option
Explanation:
No answer description is available. Let's discuss.

14.
Data mining applications are used accomplish which of the following tasks?
Process transactions only
Do RFM analysis only
Do what-if analysis only
Do both RFM and what-if analysis
Answer: Option
Explanation:
No answer description is available. Let's discuss.

15.
Which of the following is an unsupervised data mining technique?
Cluster analysis only
Regression Analysis only
RFM Analysis only
Both Regression Analysis and RFM Analysis
Answer: Option
Explanation:
No answer description is available. Let's discuss.