Data Warehouse and Data Mining
MCQ questions and answers
- 4.5/5.0
- 1k Enrolled
- All levels
- Last updated 11/2023
- English
Data Warehouse and Data Mining MCQ (20)
| 1. | ______ is used to discover the knowledge from the large dataset. |
| A | Data mining |
| B | Data warehouse |
| C | Query |
| D | Knowledge engineering |
| Answer: A | |
| 2. | ____________ is a repository of information which is gathered from the multiple sources and it stored under the unified schema at a single site. |
| A | Data mining |
| B | Data warehouse |
| C | Web server |
| D | None |
| Answer: B | |
| 3. | The task of correcting and preprocessing data is called ____________. |
| A | data analysis |
| B | data processing |
| C | data cleansing |
| D | data mining |
| Answer: C | |
| 4. | Address list collected from the multiple sources which may have a duplicate value that need to be eliminated by the ____________ operation. |
| A | marge purge |
| B | deduplication |
| C | A and B as same |
| D | data cleansing |
| Answer: C | |
| 5. | Records of many individuals in the house which are the grouped together so that only one mail is sent to each house such type of application is called ____________. |
| A | house holding |
| B | deduplication |
| C | store schema |
| D | none |
| Answer: A | |
| 6. | Which of the following table contains the multidimensional data in the data warehouse? |
| A | Lookup table |
| B | Inode table |
| C | Split table |
| D | Fact table |
| Answer: D | |
| 7. | Huge dataset is also known as? |
| A | scalar data |
| B | big data |
| C | very big data |
| D | massive data |
| Answer: B | |
| 8. | Which tool is used for data mining? |
| A | Excel |
| B | ENVI |
| C | Hadoop |
| D | ERDAS |
| Answer: C | |
| 9. | Traditionally the database store the tuples in a sequential order in the files, such type of the storage layout is referred as ____________ layout. |
| A | row oriented |
| B | column oriented |
| C | table oriented |
| D | snowflake schema |
| Answer: A | |
| 10. | Which storage has the drawback of storing or fetching a single tuple in a multiple I/O operations? |
| A | Row oriented |
| B | Column oriented |
| C | A and B |
| D | None |
| Answer: B | |
| 11. | The term ____________ is used to refer the process of analyzing a useful patterns from the large databases. |
| A | data analysis |
| B | data warehouse |
| C | data mining |
| D | knowledge discovery |
| Answer: C | |
| 12. | _______ technique is used for classification of data in the data mining? |
| A | Descriptive pattern |
| B | Associations |
| C | Decision tree classifiers |
| D | Regression |
| Answer: C | |
| 13. | Which algorithm is used to perform the decision tree classification using the set of training instances? |
| A | Greedy alogorithm |
| B | Bayes algorithm |
| C | ETL algorithm |
| D | None |
| Answer: A | |
| 14. | In the information retrieval the relevance of a document to the term is known as ____________. |
| A | Inverse document frequency (IDF) |
| B | Term frequency (TF) |
| C | Vector space model |
| D | Spider trap |
| Answer: B | |
| 15. | The google was developed ___________ algorithm which is used to measure the popularity of a page based on the public interest. |
| A | spider |
| B | crawlers |
| C | page rank |
| D | web agent |
| Answer: C | |
| 16. | ______ program is used to locate and collect the information from the web pages? |
| A | Web spider |
| B | Search engine |
| C | Autobots |
| D | Web crawlers |
| Answer: D | |
| 17. | Which program is used to access the information that is not accessible to web crawlers? |
| A | Advance web crawlers |
| B | Spider traps |
| C | Autobots |
| D | Deep web crawlers |
| Answer: D | |
| 18. | ____________ and ____________ are two measure of the effectiveness of an information retrieval system. |
| A | Precision, sysonyms |
| B | Homonyms, ontologies |
| C | Web crawler, spider |
| D | Precision, recall |
| Answer: D | |
| 19. | ____________ deal with the prediction of a value rather than the class. |
| A | Regression |
| B | Precision |
| C | Recall |
| D | Multiway splits |
| Answer: A | |
| 20. | Which of the following is a type of classifier that provide the very accurate classification across a range of application? |
| A | Binary split |
| B | Multiway split |
| C | Overfitting |
| D | Support vector machine |
| Answer: D |
Video Lectures of C Language
