Dataware Housing Mcqs
Q.1: Which of the following statements is incorrect regarding Data Mining?E
A. It is the process of turning data into information2
B. It is a collection of many techniques%
C. It is a replacement for OLAP
D. It is based on machine generated hypothesis+
Q.2: The modification of data as it is moved into the data warehouse is:C
A. Data Transformation
B. Replication
C. Data Transformation
D. Data migration
Q.3: A datawarehouse should be able to implement advanced query functionality. This means :V
A. The RDBMS must provide a complete set of analytic operations including core sequential and statistical operationsq
B. The RDBMS must not have any architectural limitations5
C. The RDBMS must provide a complete set of analytic operations including core sequential and statistical operationsq
D. Query performance must not be dependent on the size of the database, but rather on the complexity of the queryn
Q.4: Which technique of Data Mining involves developing mathematical structures with the ability to learn?e
A. Clustering and Segmentation
B. Neural Networks
C. Neural Networks
D. Linear Regression Analysis
Q.5: Which Data Mining function/technique is used to analyse a collection of records over a period of time?f
A. Classification
B. Associations
C. Sequential/Temporal patterns
D. Clustering
Q.6: A structure that stores multi-dimensional information, having one cell for each possible combination of dimensions is known as:
A. Table
B. Section
C. Cube
D. Cube
Q.7: HOLAP stands for:
A. Hierarchical On-line Analytical Processing*
B. Hybrid On-line Analytical Processing$
C. Hybrid On-line Analytical Processing$
D. Hyper On-line Analytical Processing#
Q.8: Which of the following would not be an application of Data Mining in the banking field?W
A. Detect patterns of fraudulent credit card use-
B. Ascertaining the number of transactions made in a day5
C. Ascertaining the number of transactions made in a day5
D. Find hidden correlation between different financial indicators>
Q.9: In a star schema, a table which contains data about one of the dimensions is called a:V
A. Fact table
B. Meta table
C. Meta table
D. Pivot table
Q.10: ROLAP stands for:
A. Recyclic On-line Analytical Processing&
B. Relational On-line Analytical Processing(
C. Relational On-line Analytical Processing(
D. Rotated On-line Analytical Processing%

Related Mcqs

All Subject Mcqs