MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 37 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 2. |
Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 3. |
Market basket analysis primarily uses the technique of conditional probabilities. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 4. |
A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 5. |
The term neural networks as used in data mining is a misnomer. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 6. |
Data warehouse data are usually normalized. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 7. |
Report types include static, dynamic, query and OLAP. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 8. |
OLAP uses measures, dimensions and associations. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 9. |
BI reporting systems summarize the current status of business activities in order to predict future activities. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 10. |
OnLine Analytical Processing (OLAP) is a BI reporting system. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 11. |
RFM analysis is a BI reporting system. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 12. |
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. | 1 |
| B. | |
| Answer» B. | |
| 13. |
One popular classification technique in Business Intelligence (BI) reporting is ________ . |
| A. | cluster analysis only |
| B. | regression analysis only |
| C. | RFM analysis only |
| D. | both cluster analysis and regression analysis |
| Answer» D. both cluster analysis and regression analysis | |
| 14. |
In unsupervised data mining, explanations are created after patterns are found. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 15. |
Which of the following is an unsupervised data mining technique? |
| A. | Cluster analysis only |
| B. | Regression Analysis only |
| C. | RFM Analysis only |
| D. | Both Regression Analysis and RFM Analysis |
| Answer» B. Regression Analysis only | |
| 16. |
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. | 1 |
| B. | |
| Answer» C. | |
| 17. |
A data warehouse is a database system that is optimized for operational transaction processing. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 18. |
The reports generated by a reporting system are usually not delivered in which of the following media? |
| A. | Web portal |
| B. | Commercial courier service |
| C. | Digital dashboard |
| D. | |
| Answer» C. Digital dashboard | |
| 19. |
The data warehouse DBMS needs to be the same DBMS used for the operational database. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 20. |
Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 21. |
Most operational databases can be used for many BI applications. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 22. |
We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ . |
| A. | Has ordered recently, orders frequently, and places a large order when she orders. |
| B. | Hasn't ordered recently, orders infrequently, but places a large order when she orders. |
| C. | Has ordered recently, orders frequently, but doesn't place a large order when she orders |
| D. | Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders. |
| Answer» D. Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders. | |
| 23. |
Data mining applications are used accomplish which of the following tasks? |
| A. | Process transactions only |
| B. | Do RFM analysis only |
| C. | Do what-if analysis only |
| D. | Do both RFM and what-if analysis |
| Answer» D. Do both RFM and what-if analysis | |
| 24. |
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 ________ . |
| A. | dirty data |
| B. | inconsistent data |
| C. | non-integrated data |
| D. | a "wrong format" problem |
| Answer» D. a "wrong format" problem | |
| 25. |
We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ . |
| A. | the basic probability |
| B. | support |
| C. | lift |
| D. | confidence |
| Answer» E. | |
| 26. |
The "F" in RFM analysis stands for ________ . |
| A. | frequently |
| B. | freshness |
| C. | fast food |
| D. | fantasy |
| Answer» B. freshness | |
| 27. |
Which of the following is not a reason that operational data are difficult to read? |
| A. | Non-duplicated data |
| B. | Dirty data |
| C. | Missing values |
| D. | Non-integrated data |
| Answer» B. Dirty data | |
| 28. |
Formatting the report is part of authoring a report. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 29. |
We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ . |
| A. | the basic probability |
| B. | support |
| C. | lift |
| D. | confidence |
| Answer» C. lift | |
| 30. |
Which of the following are not done by Business Intelligence (BI) systems? |
| A. | Analyze past and current activities only |
| B. | Process and record transactions only |
| C. | Both of the above are correct. |
| D. | Neither of the above is correct. |
| Answer» C. Both of the above are correct. | |
| 31. |
Business Intelligence (BI) reporting analyses can be performed using ________ . |
| A. | standard SQL only |
| B. | extensions to SQL only |
| C. | OLAP only |
| D. | both standard SQL and extensions to SQL |
| Answer» B. extensions to SQL only | |
| 32. |
RFM analysis uses customers' purchasing patterns to ________ . |
| A. | record transactions |
| B. | analyze and rank customers |
| C. | predict future sales using regression techniques |
| D. | perform OLAP |
| Answer» C. predict future sales using regression techniques | |
| 33. |
Business Intelligence (BI) systems do not obtain their data by which of the following means? |
| A. | Read and process data from an operational database |
| B. | Process transactions |
| C. | Process extracts from operational databases |
| D. | Process data purchased from data vendors |
| Answer» C. Process extracts from operational databases | |
| 34. |
Business Intelligence (BI) systems do not obtain data from operational databases. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 35. |
The "curse of dimensionality" relates to which problem of using operational data for BI reporting? |
| A. | Dirty data |
| B. | Inconsistent data |
| C. | Too much data |
| D. | Non-integrated data |
| Answer» D. Non-integrated data | |
| 36. |
In OLAP, we are interested in ________ . |
| A. | levels only |
| B. | dimensions only |
| C. | measures only |
| D. | measures and dimensions |
| Answer» E. | |
| 37. |
A BI reporting system does not ________ . |
| A. | create meaningful information |
| B. | deliver information to users on a timely basis |
| C. | use statistical procedures to predict future events |
| D. | use disparate data sources |
| Answer» D. use disparate data sources | |