ExamVeda
Login
Home

Database Processing for BIS - Database MCQ Questions and answers- Technical Aptitude

Database Processing for BIS(Database) mcq questions and answers with easy and logical explanations for various competitive examination, interview and entrance test. Database Mcq question are important for technical exam and interview. Page-3 section-1

21
Business Intelligence (BI) systems do not obtain data from operational databases.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
22
Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
23
A data warehouse is a database system that is optimized for operational transaction processing.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
24
Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
25
Most operational databases can be used for many BI applications.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
26
The data warehouse DBMS needs to be the same DBMS used for the operational database.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
27
RFM analysis is a BI reporting system.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
28
In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
29
Report types include static, dynamic, query and OLAP.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
30
OLAP uses measures, dimensions and associations.
Discuss
Answer & Solution
Answer: Option A
Solution:
OLAP (Online Analytical Processing) is a category of database processing that supports multidimensional analysis of data for business intelligence purposes.

Measures refer to the numeric data values that users want to analyze, such as sales, profit, or revenue.

Dimensions are perspectives or entities with respect to which an organization wants to keep records, like time, geography, or product.

Associations refer to the relationships between dimensions and measures, allowing users to perform complex queries and drill-down analysis.

Therefore, OLAP uses measures, dimensions, and associations to help in effective data analysis and decision-making.