Database Processing for BIS - Database MCQ Questions and answers- Technical Aptitude Page-3 section-1

21.
Business Intelligence (BI) systems do not obtain data from operational databases.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

23.
A data warehouse is a database system that is optimized for operational transaction processing.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

24.
Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

25.
Most operational databases can be used for many BI applications.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

26.
The data warehouse DBMS needs to be the same DBMS used for the operational database.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

27.
RFM analysis is a BI reporting system.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

29.
Report types include static, dynamic, query and OLAP.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

30.
OLAP uses measures, dimensions and associations.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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

21. Business Intelligence (BI) systems do not obtain data from operational databases.

Answer & Solution

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.

Answer & Solution

23. A data warehouse is a database system that is optimized for operational transaction processing.

Answer & Solution

24. Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.

Answer & Solution

25. Most operational databases can be used for many BI applications.

Answer & Solution

26. The data warehouse DBMS needs to be the same DBMS used for the operational database.

Answer & Solution

27. RFM analysis is a BI reporting system.

Answer & Solution

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.

Answer & Solution

29. Report types include static, dynamic, query and OLAP.

Answer & Solution

30. OLAP uses measures, dimensions and associations.

Answer & Solution

21.
Business Intelligence (BI) systems do not obtain data from operational databases.

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.

23.
A data warehouse is a database system that is optimized for operational transaction processing.

24.
Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.

25.
Most operational databases can be used for many BI applications.

26.
The data warehouse DBMS needs to be the same DBMS used for the operational database.

27.
RFM analysis is a BI reporting system.

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.

29.
Report types include static, dynamic, query and OLAP.

30.
OLAP uses measures, dimensions and associations.