Search
RELATED TITLES
Data Mining Mcq
Uploaded by Sk Reddy
Save Embed Print
Solved MCQ of Data Warehouse
Computer Data Mining -
http://grdmcqonline/printqp.php?heading=II M.Sc(IT) [2012-2014], Se...
Dr.G.R.Damodaran College of Science
(Autonomous, affiliated to the Bharathiar University, recognized by the UGC)Re-
accredited at the 'A' Grade Level by the NAAC and ISO 9001:2008 Certified
CRISL rated 'A' (TN) for MBA and MIB Programmes
II M.Sc(IT) [2012-2014]
Semester III
Core: Data Warehousing and Mining - 363U1
Multiple Choice Questions.
1. __________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support
of management decisions.
A. Data Mining.
B. Data Warehousing.
C. Web Mining.
D. Text Mining.
ANSWER: B
2. The data Warehouse is__________.
A. read only.
B. write only.
C. read write only.
D. none.
ANSWER: A
3. Expansion for DSS in DW is__________.
A. Decision Support system.
B. Decision Single System.
C. Data Storable System.
D. Data Support System.
ANSWER: A
4. The important aspect of the data warehouse environment is that data found within the data
warehouse is___________.
A. subject-oriented.
B. time-variant.
C. integrated.
D. All of the above.
ANSWER: D
5. The time horizon in Data warehouse is usually __________.
A. 1-2 years.
B. 3-4years.
C. 5-6 years.
D. 5-10 years.
ANSWER: D
6. The data is stored, retrieved & updated in ____________.
A. OLAP.
B. OLTP.
C. SMTP.
1 of 34 8/20/2013 2:47 PM
Read books, audiobooks, and more
Scribd, Inc INSTALL
Try Scribd s to access over 125 million titles
Cancel Anytime.
http://grdmcqonline/printqp.php?heading=II M.Sc(IT) [2012-2014], Se...
D. FTP.
ANSWER: B
7. __________describes the data contained in the data warehouse.
A. Relational data.
B. Operational data.
C. Metadata.
D. Informational data.
ANSWER: C
8. ____________predicts future trends & behaviors, allowing business managers to make proactive,
knowledge-driven decisions.
A. Data warehouse.
B. Data mining.
C. Datamarts.
D. Metadata.
ANSWER: B
9. __________ is the heart of the warehouse.
A. Data mining database servers.
B. Data warehouse database servers.
C. Data mart database servers.
D. Relational data base servers.
ANSWER: B
10. ________________ is the specialized data warehouse database.
A. Oracle.
B. DBZ.
C. Informix.
D. Redbrick.
ANSWER: D
11. ________________defines the structure of the data held in operational databases and used by
operational applications.
A. User-level metadata.
B. Data warehouse metadata.
C. Operational metadata.
D. Data mining metadata.
ANSWER: C
12. ________________ is held in the catalog of the warehouse database system.
A. Application level metadata.
B. Algorithmic level metadata.
C. Departmental level metadata.
D. Core warehouse metadata.
ANSWER: B
13. _________maps the core warehouse metadata to business concepts, familiar and useful to end
users.
A. Application level metadata.
B. User level metadata.
C. Enduser level metadata.
D. Core level metadata.
ANSWER: A
2 of 34 8/20/2013 2:47 PM
http://grdmcqonline/printqp.php?heading=II M.Sc(IT) [2012-2014], Se...
14. ______consists of formal definitions, such as a COBOL layout or a database schema.
A. Classical metadata.
B. Transformation metadata.
C. Historical metadata.
D. Structural metadata.
ANSWER: A
15. _____________consists of information in the enterprise that is not in classical form.
A. Mushy metadata.
Differential metadata.
Read books, audiobooks,
mining and more
Scribd, Inc INSTALL
Operational.
D. data warehouse
ANSWER: D
22. The source of all data warehouse data is the________
A. operational environment.
B. informal environment.
C. formal environment.
D. technology environment.
ANSWER: A
23. Data warehouse contains_____________data that
A. normalized.
B. informational.
C. summary.
D. denormalized.
ANSWER: C
24. Data redundancy between the environments results in
A. one.
B. two.
C. three.
D. four.
ANSWER: A
Read books, audiobooks, and more
25. Bill Inmon has estim _____of the
Scribd, Inc INSTALL
A.
Read books, audiobooks, and more
Scribd, Inc INSTALL
Titles you can't find anywhere else
Try Scribd FREE for 30 days to access over 125 million titles
without ads or interruptions!
Start Free Trial
Cancel Anytime.
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Titles you can't find anywhere else
Try Scribd FREE for 30 days to access over 125 million titles
without ads or interruptions!
Start Free Trial
Cancel Anytime.
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Titles you can't find anywhere else
Try Scribd FREE for 30 days to access over 125 million titles
without ads or interruptions!
Start Free Trial
Cancel Anytime.
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Titles you can't find anywhere else
Try Scribd FREE for 30 days to access over 125 million titles
without ads or interruptions!
Start Free Trial
Cancel Anytime.
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Titles you can't find anywhere else
Try Scribd FREE for 30 days to access over 125 million titles
without ads or interruptions!
Start Free Trial
Cancel Anytime.
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Titles you can't find anywhere else
Try Scribd FREE for 30 days to access over 125 million titles
without ads or interruptions!
Start Free Trial
Cancel Anytime.
Read books, audiobooks, and more
Scribd, Inc INSTALL
Read books, audiobooks, and more
Scribd, Inc INSTALL
Reward Your Curiosity
Everything you want to read.
Anytime. Anywhere. Any device.
Read For Free
Cancel Anytime
Share this document
Related Interests
Data Warehouse Cluster Analysis
Neuron Metadata
Regression Analysis
Documents Similar To Data …
Read books, audiobooks, and more
Scribd, Inc INSTALL
Solved MCQ of Data Warehouse Solutions to II Unit
Computer Security Data Mining - Exercises From
UPLOADED BY UPLOADED BY UPLOADED BY
nooti Tetelo Vincent jyothibellaryv
Popular in Artificial Neural …
1412.2306v2 IEEEXplore Decision Support
UPLOADED BY UPLOADED BY System in Heart
nagu323 Azerilatama UPLOADED BY
IJSTR Researc
Read books, audiobooks, and more
Scribd, Inc INSTALL
About Scribd Help / FAQ
Press Accessibility
Our blog Purchase help
Join our team! AdChoices
Contact Us Publishers
Join today
Invite Friends
Gi�s
LEGAL
Terms
Privacy
Copyright
Copyright © 2019 Scribd Inc. . Browse Books . Site Directory . Site Language: English
Read books, audiobooks, and more
Scribd, Inc INSTALL
