Data Warehousing And Data Mining
PART A
1. Training a Neural Network to balance a pole is a part of
A. Inductive learner
B. Machine learning
C. Knowledge discovery in databases
D. Both a) and b)
2. The normal life cycle of a data mart is generally
A. 10 years
B. 5 years
C. 3 years
D. 7 years
3. The SQL construct that is used to create a partition view is ____
A. UNION
B. UNION ALL
C. CREATE
D. None of these
4. Confidence Factor is used in ______
A. Clustering
B. Classification
C. Association
D. None of these
5. ______ must have intimate knowledge of the current legacy system
A. Infrastructure specialist
B. Trainer
C. Power user
D. Data mart development leader
6. Strong political skills is a requirement for ______
A. Project Manager
B. Project Director
C. Database Administrator
D. None of these
7. The most common cause of warehouse failure is
A. Inability to meet business objectives
B. Financial constraints
C. Technical unfeasibility
D. None of these
8. Competence in legacy tools is a requirement for ______
A. System administrator
B. Data Transformation Specialist
C. Data Migration Specialist
D. All of these
9. Which of the following domains must be managed by a data professional?
A. Development Environment
B. Execution Environment
C. Data Warehouse
D. All of these
10. Which of the following is not an application of neural networks?
A. Sales forecasting
B. Customer research
C. Risk management
D. None of these
11. _____ is a set of objects grouped together because of their similarity or proximity.
A. Segment
B. Cluster
C. Pattern
D. All of the above
12. Which of the following table spaces cannot be made read-only?
A. MASTER
B. ADMIN
C. SYSTEM
D. None of these
13. The minimum number of log files used by an oracle database is _____
A. 1
B. 3
C. 4
D. 2
14. Which of the following tool is used for data propagation and transformation?
A. Data mirror
B. Visualize
C. Dan Guide
D. None of these
15. Which of the following architecture involves multiple processors share common memory and disk storage and running under a single operating system?
A. Symmetric Multi Processing
B. Massively Parallel Processing
C. Synchronized Modular Processing
D. None of these
16. _____ is ideal for large data sets
A. M O L A P
B. R O L A P
C. Both A) and B)
D. None of these
17. Which of the following data mining techniques uses the principles of mutation and natural selection to analysis data?
A. Artificial Neural Network
B. Generic Algorithms
C. Decision Trees
D. None of these
18. Who must have strong organizational and planning skills
A. Project Director
B. Chief Executive
C. Project Manager
D. Data Provision Specialist
19. Which of the following system deals with pre-defined events?
A. Informational System
B. Operational System
C. Both A) and B)
D. None of these
20. The process of deliberately ignoring partitions if they are not accessed during execution is called ____
A. Partition Transparency
B. Partition Algorithms
C. Decision trees
D. None of these
21. ______ handles mission-critical production data accepted through simple queries
A. OLTP
B. OLAP
C. Neural Network
D. None of these
22. A description of why a project is being done is the concern of ______
A. Project Objective
B. Project Justification
C. Project Description
D. None of these
23. Project estimation can get delayed because of the reason
A. Wrong assumption
B. Constraints
C. Unknown factor
D. All of the above
24. Preserving the security and integrity of mission- critical OLTP application data is called _____
A. Synthesis
B. Insulation
C. Transparency
D. None of these
25. Controlling the project scope is the responsibility of ____
A. Project manager
B. Data Warehousing Architect
C. Data Mart Development Leader
D. None of these
26. Which of the following is not a component of the data warehouse project team?
A. Programmer
B. DSS Analyst
C. Background Expert
D. None of these
27. ____ is a collection of one or more data files that serve as a repository for data
A. Bitmapped Index
B. Table space
C. Star Queries
D. All of the above
28. The type of data model that is used in a data warehouse is usually ____
A. Multi-dimensional
B. Normalized
C. Transactional
D. None of these
29. Operations like data conversion, filtering and formatting are the concern of ____
A. Load Performance
B. Load Processing
C. Mass User Scalability
D. None of these
30. The building block for parallel processing are
A. Query servers
B. CPU
C. Indexes
D. None of the above
31. A set of data items grouped according to logical relationships is called a
A. Cluster
B. Class
C. Set
D. None of these
32. Star scheme is preferred method for
A. Analytical processing
B. Parallel programming
C. Both of the above
D. None of the above
33. Which of the following qualities must be present in a project manager?
A. Administrative ability
B. Business experience
C. Problem solving ability
D. All of these
34. Bitmapped indexing is ideal when there is ____ cardinality
A. Low
B. Moderate
C. High
D. None of these
35. The degree of summarization of data is called ____
A. Cardinality
B. Granularity
C. Density
D. None of these
36. The ability of an organization to save money is defined in terms of _____
A. Operating Efficiency
B. Change Management
C. Methodology and Tools
D. None of these
37. The integrated plan for project is used to
A. Combine various phases involved
B. Monitor and control the project
C. Cut costs
D. All of the above
38. The ability to support fact-based management and ad-hoc analysis is measured by ____
A. Query Performance
B. Terabyte Scalability
C. Load performance
D. None of these
39. Competence in legacy tools is a requirement for ____
A. System Administrator
B. Data Transformation Specialist
C. Data Migration Specialist
D. None of these
40. ____ test is a reasonable and understandable definition of the goals OLAP is meant to achieve
A. SMFI
B. FASMI
C. ASMI
D. FSAMI
PART B
41. Table and index creation are the common SQL statements used for
i) creating data
ii) extracting data
iii) transforming data
iv) optimizing data
i) creating data
ii) extracting data
iii) transforming data
iv) optimizing data
A. i) and ii)
B. ii) and iii)
C. iii) and iv)
D. i) and iii)
42. Which of the following statement(s) are true?
i) Bitmaps are inappropriate for heavy OLTP systems
ii) Updating a bitmapped index involves more overheads
iii) Bitmaps are appropriate for heavy OLTP systems
iv) Updating a bit
i) Bitmaps are inappropriate for heavy OLTP systems
ii) Updating a bitmapped index involves more overheads
iii) Bitmaps are appropriate for heavy OLTP systems
iv) Updating a bit
A. i) and iv)
B. i) and ii)
C. ii) and iii)
D. only i)
43. Neural Networks are well suited for
i) industrial process control
ii) floating point arithmetic
iii) customer research
iv) data validation
i) industrial process control
ii) floating point arithmetic
iii) customer research
iv) data validation
A. i), ii) and iii)
B. ii), iii) and iv)
C. i), iii) and iv)
D. All of the above
44. Which of the following information must be present in the metadata of a data warehouse?
1. The structure of the data
2. The algorithm used for summarization
3. The mapping from the operational
environment to the data warehouse
1. The structure of the data
2. The algorithm used for summarization
3. The mapping from the operational
environment to the data warehouse
A. 1 and 2
B. 1, 2 and 3
C. 2 and 3
D. 1 and 3
45. Which of the following are the processes of creating a partition, so that all the member of each set of the partition is similar according to some data?
i) Data Mining
ii) Classification
iii) Clustering
iv) Segmentation
i) Data Mining
ii) Classification
iii) Clustering
iv) Segmentation
A. i) and iv)
B. i), ii) and iii)
C. ii) and iii)
D. iii) and iv)
46. Which of the following qualities are desirable in a project manager?
1. The ability to work with others
2. A good understanding of issue management
3. Effective application of the lessons learnt
4. Business experience and the ability
1. The ability to work with others
2. A good understanding of issue management
3. Effective application of the lessons learnt
4. Business experience and the ability
A. 1, 2 and 3
B. 2, 3 and 4
C. 1, 2 and 4
D. 1, 2, 3 and 4
47. Which of the products represent Multidimensional analysis tool?
i) RODIN
ii) AMIS/400
iii) MIT/400
iv) Showcase strategy with ESS BASE/400
i) RODIN
ii) AMIS/400
iii) MIT/400
iv) Showcase strategy with ESS BASE/400
A. i), iii) and iv)
B. i), ii) and iii)
C. ii), iii) and iv)
D. i), ii) and iv)
48. Which of the following qualities are desirable in a project manager?
1. The ability to work with others
2. A good understanding of issue management
3. Effective application of the lessons learnt
4. Business experience and the ability
1. The ability to work with others
2. A good understanding of issue management
3. Effective application of the lessons learnt
4. Business experience and the ability
A. 1, 2 and 3
B. 2, 3 and 4
C. 1, 2 and 4
D. 1, 2, 3 and 4
49. The characteristics of OLAP are:
A. Fast, Analytical, Single, Integrated
B. Fast, Analysis, Shared, Information
C. Fixed, Analog, Simple, Input
D. Feasibility, Adjustability, Simplicity, Indivisibility
50. Which of the following statements are true regarding star scheme?
1. The fact table contains the object that is
being analyzed
2. The fact table normally contains numeric
data/
3. The dimension table contains descriptive
4. The
1. The fact table contains the object that is
being analyzed
2. The fact table normally contains numeric
data/
3. The dimension table contains descriptive
4. The
A. 1, 2 and 3
B. 2, 3 and 4
C. 1, 2 and 4
D. 1, 2, 3 and 4
51. Which of the following information must be present in the metadata of a data warehouse?
1. The structure of the data
2. The algorithm used for summarization
3. The mapping from the operational environment to the data warehouse
1. The structure of the data
2. The algorithm used for summarization
3. The mapping from the operational environment to the data warehouse
A. 1 and 2
B. 1, 2 and 3
C. 2 and 3
D. 1 and 3
52. Which of the following(s) is not a requirement of data server?
i) Capacity
ii) Performance
iii) security
iv) closed interfaces
i) Capacity
ii) Performance
iii) security
iv) closed interfaces
A. i), ii) and iv)
B. i) and ii)
C. ii), iii) and iv)
D. iii) and iv)
53. Which of the following statements are true regarding data warehouse architect?
1. He must have good business analysis skills
2. He must possess a thorough knowledge of data base design and associated tools
3. He must determine the performance
1. He must have good business analysis skills
2. He must possess a thorough knowledge of data base design and associated tools
3. He must determine the performance
A. 1 and 2
B. 2 and 3
C. 1 and 3
D. 1, 2 and 3
54. Table and index creation are the common SQL statements used for
i) creating data
ii) extracting data
iii) transforming data
iv) optimizing data
i) creating data
ii) extracting data
iii) transforming data
iv) optimizing data
A. i) and ii)
B. ii) and iii)
C. iii) and iv)
D. i) and iii)
55. Which of the following is not an external risk?
A. Currency Rate Change
B. Pollution
C. Customer
D. None of these
56. Which of the following characteristics reflects the unchanging nature of data in a data warehouse?
A. Subject-oriented
B. Integrated
C. Non-volatile
D. None of these
57. Which of the following is not a part of the project life cycle?
A. Maintenance
B. Initiation
C. Planning
D. None of these
58. The Fact table usually consists of ____ data
A. Descriptive
B. Numeric
C. Both A) and B)
D. None of these
59. Data Marts
A. Are essentially used by one user
B. Can have more than one user
C. Cannot be accessed by user
D. None of the above
60. ____ process ensures data moved into data mart conform to a standard system
A. Extraction
B. Loading
C. Transformation
D. Both A) and B)
61.
