MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 45 Mcqs, each offering curated multiple-choice questions to sharpen your Data Mining knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In data mining, the dice operation performs a selection on |
| A. | Single dimension |
| B. | Only on Two dimension |
| C. | Two or more dimension |
| D. | None of the above |
| Answer» D. None of the above | |
| 2. |
In star schema there is __ relationship between fact table and dimension table |
| A. | M:N |
| B. | 1:N |
| C. | 2:N |
| D. | 3:N |
| Answer» C. 2:N | |
| 3. |
In data mining, the slice operation performs a selection on __ |
| A. | One dimension |
| B. | Two dimension |
| C. | Multi dimension |
| D. | None of the above |
| Answer» B. Two dimension | |
| 4. |
Which operation mainly used to access the live data online and analyse it |
| A. | ROLAP |
| B. | OLAP |
| C. | MOLAP |
| D. | HOLAP |
| Answer» C. MOLAP | |
| 5. |
Fact constellation is a good alternative to the |
| A. | Galaxy Schema |
| B. | Snowflake schema |
| C. | Star Schema |
| D. | None of the above |
| Answer» D. None of the above | |
| 6. |
Which is not considered as data mining technique |
| A. | Parsing |
| B. | Decision tree |
| C. | Artificial neural network |
| D. | Regression |
| Answer» B. Decision tree | |
| 7. |
Which one algorithm is developed by Ross Quinlan |
| A. | C4.5 |
| B. | k-means |
| C. | Apriori |
| D. | AdaBoost |
| Answer» B. k-means | |
| 8. |
Which one is not a data reduction strategy |
| A. | Data Generalization |
| B. | Dimension reduction |
| C. | Data compression |
| D. | Data cube aggregation |
| Answer» B. Dimension reduction | |
| 9. |
Which one is the last step of Data Mart Implementation process |
| A. | Designing |
| B. | Acessing |
| C. | Managing |
| D. | Populating |
| Answer» D. Populating | |
| 10. |
A subset of the data warehouse that contains all the data about a particular topic is known as |
| A. | Data Pocket |
| B. | Metadata |
| C. | Data Mart |
| D. | Data Mining |
| Answer» D. Data Mining | |
| 11. |
Which one is not a Data Transformation strategy |
| A. | Aggregation |
| B. | Normalization |
| C. | Generalization |
| D. | Compression |
| Answer» E. | |
| 12. |
ODS stands for |
| A. | Online Data Store |
| B. | Online Data Storage |
| C. | Operational Data Stand |
| D. | Operational Data Store |
| Answer» E. | |
| 13. |
Which type of database can be used for optimizing data warehousing and OLAP (online analytical processing) |
| A. | Retional |
| B. | Relational |
| C. | Structural |
| D. | Multidimensional |
| Answer» E. | |
| 14. |
The data is stored, retrieved and updated in |
| A. | OLTP |
| B. | OLAP |
| C. | DBMS |
| D. | MPP |
| Answer» B. OLAP | |
| 15. |
In OLAP cubes, data (measures) are categorized by |
| A. | Length |
| B. | Angles |
| C. | Dimensions |
| D. | Breadth |
| Answer» D. Breadth | |
| 16. |
Data warehouse architecture is based on |
| A. | DBMS |
| B. | RDBMS |
| C. | SQL |
| D. | ORACLE |
| Answer» C. SQL | |
| 17. |
Which one is a method of incremental conceptual clustering |
| A. | DBWEB |
| B. | OLAD |
| C. | COBWEB |
| D. | CATWEB |
| Answer» D. CATWEB | |
| 18. |
A decision tree where the target variable takes a continuous value, usually numbers, are called |
| A. | Classification Trees |
| B. | Regression Trees |
| C. | Agression Tree |
| D. | Expanded Tree |
| Answer» C. Agression Tree | |
| 19. |
Which one is true about a Fact Table |
| A. | Contains Hierarchies |
| B. | Contains Descriptive attributes |
| C. | Contains Quantitative information |
| D. | Located at the edges of the star schema |
| Answer» D. Located at the edges of the star schema | |
| 20. |
The process of upgrading the existing quality of data before it is moved into a data warehouse is known as |
| A. | Data Scrubbing |
| B. | Data Polishing |
| C. | Data Auditing |
| D. | Data Aggregation |
| Answer» B. Data Polishing | |
| 21. |
In Transient data, after changes with the the records, the previous version of the records will be |
| A. | Added |
| B. | Eliminated |
| C. | Separately stored |
| D. | Remain same |
| Answer» C. Separately stored | |
| 22. |
In the data warehouse, which data have the greatest level of details stored |
| A. | Micro Data |
| B. | Atomic Data |
| C. | Macro Data |
| D. | Dimensional Data |
| Answer» C. Macro Data | |
| 23. |
Total number of stages in KDD is |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 6 |
| Answer» D. 6 | |
| 24. |
Which one is not a Knowledge Discovery in Databases (KDD) process |
| A. | Selection |
| B. | Transformation |
| C. | Data Mining |
| D. | Understanding |
| Answer» E. | |
| 25. |
What is the full form of OLTP |
| A. | Online Transaction Processing |
| B. | Online Transaction Program |
| C. | Oracle Transaction Processing |
| D. | Online Terminal Processing |
| Answer» B. Online Transaction Program | |
| 26. |
Which databases are owned by particular departments or business groups |
| A. | Operational |
| B. | Transactional |
| C. | Rational |
| D. | Informational |
| Answer» B. Transactional | |
| 27. |
The time horizon in operational environment is |
| A. | 10-30 days |
| B. | 30-60 days |
| C. | 60-90 days |
| D. | 90-120 days |
| Answer» D. 90-120 days | |
| 28. |
The number of fact table in star schema is |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» B. 2 | |
| 29. |
Which metadata consists of information in the enterprise that is not in classical form |
| A. | Linear metadata |
| B. | Star metadata |
| C. | Mushy metadata |
| D. | Increamental metadata |
| Answer» D. Increamental metadata | |
| 30. |
Which type of metadata is held in the catalog of the warehouse database system |
| A. | Algorithmic level metadata |
| B. | Right management metadata |
| C. | Application level metadata |
| D. | Structured level metadata |
| Answer» B. Right management metadata | |
| 31. |
Which one is the heart of the warehouse |
| A. | Data mining database servers |
| B. | Data warehouse database servers |
| C. | Data mart database servers |
| D. | Relational database servers |
| Answer» C. Data mart database servers | |
| 32. |
Usually __ years is the time horizon in data warehouse |
| A. | 1-3 |
| B. | 3-5 |
| C. | 5-10 |
| D. | 10-15 |
| Answer» D. 10-15 | |
| 33. |
What is the full form of DSS in Data Warehouse |
| A. | Decisive selection system |
| B. | Decision support system |
| C. | Decision support solution |
| D. | Decision solution system |
| Answer» C. Decision support solution | |
| 34. |
Which one is true |
| A. | The data Warehouse is write only |
| B. | The data warehouse is read only |
| C. | The data warehouse is read write only |
| D. | None of the above is true |
| Answer» C. The data warehouse is read write only | |
| 35. |
The full form of OLAP is |
| A. | Online Advanced Program |
| B. | Online Analytical Program |
| C. | Online Advanced Processing |
| D. | Online Analytical Processing |
| Answer» E. | |
| 36. |
Which one is not a kind of data warehouse application |
| A. | Information processing |
| B. | Analytical processing |
| C. | Transaction processing |
| D. | Data mining |
| Answer» D. Data mining | |
| 37. |
State which one is correct |
| A. | The data warehouse view exposes the information being captured, stored, and managed by operational systems |
| B. | The top-down view exposes the information being captured, stored, and managed by operational systems |
| C. | The business query view exposes the information being captured, stored, and managed by operational systems |
| D. | The data source view exposes the information being captured, stored, and managed by operational systems |
| Answer» E. | |
| 38. |
Which one is a data mining function that assigns items in a collection to target categories or classes |
| A. | Selection |
| B. | Classification |
| C. | Integration |
| D. | Reduction |
| Answer» C. Integration | |
| 39. |
The full form of KDD is |
| A. | Knowledge Data Developer |
| B. | Knowledge Develop Database |
| C. | Knowledge Discovery Database |
| D. | None of the above |
| Answer» D. None of the above | |
| 40. |
Strategic value of data mining is |
| A. | Case sensitive |
| B. | Time sensitive |
| C. | System sensitive |
| D. | Technology sensitive |
| Answer» C. System sensitive | |
| 41. |
Preprocessing step is used in Data __ |
| A. | cleaning |
| B. | integration |
| C. | transformation |
| D. | reduction |
| Answer» B. integration | |
| 42. |
Which one referes to the finding of relevant and useful information from databases |
| A. | Data mining |
| B. | Data warehouse |
| C. | Data management |
| D. | Data query |
| Answer» B. Data warehouse | |
| 43. |
__ is the bridge between data warehouse and decision support application. |
| A. | Logical data |
| B. | Complex data |
| C. | Nominal data |
| D. | Metadata |
| Answer» E. | |
| 44. |
Fact constellation is also known as |
| A. | Star Schema |
| B. | Snowflake Schema |
| C. | Micro Schema |
| D. | Galaxy Schema |
| Answer» E. | |
| 45. |
__ is a subject-oriented, integrated,time-varying, nonvolatile collection of data in support of management decisions –making process. |
| A. | Data structure |
| B. | Data warehouse |
| C. | Data base |
| D. | Data analytics |
| Answer» C. Data base | |