CS614-Midterm
1 / 50
Pakistan is one of the five major ________ countries in the world.
2 / 50
The automated, prospective analyses offered by data mining move beyond the analyses of past events provided by _____________ tools typical of decision support systems.
3 / 50
Collapsing tables can be done on the ___________ relationships
4 / 50
De-Normalization normally speeds up
5 / 50
Data mining uses _________ algorithms to discover patterns and regularities in data.
6 / 50
To measure or quantify the similarity or dissimilarity, different techniques are available. Which of the following option represent the name of available techniques?
7 / 50
For a DWH project, the key requirement are ________ and product experience.
8 / 50
The goal of star schema design is to simplify ________
9 / 50
Companies collect and record their own operational data, but at the same time they also use reference data obtained from _______ sources such as codes, prices etc.
10 / 50
The growth of master files and magnetic tapes exploded around the mid- _______. :
11 / 50
NUMA stands for __________
12 / 50
Data mining evolve as a mechanism to cater the limitations of ________ systems to deal massive data sets with high dimensionality, new data types, multiple heterogeneous data resources etc.
13 / 50
14 / 50
Focusing on data warehouse delivery only often end up _________.
15 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
16 / 50
_______ is an application of information and data.
17 / 50
For a given data set, to get a global view in un-supervised learning we use
18 / 50
19 / 50
: The goal of ___________ is to look at as few blocks as possible to find the matching records(s).
20 / 50
Data mining derives its name from the similarities between searching for valuable business information in a large database, for example, finding linked products in gigabytes of store scanner data, and mining a mountain for a _________ of valuable ore.
21 / 50
In a traditional MIS system, there is an almost linear sequence of queries.
22 / 50
23 / 50
24 / 50
_________ breaks a table into multiple tables based upon common column values.
25 / 50
Horizontal splitting breaks a table into multiple tables based upon_______
26 / 50
For good decision making, data should be integrated across the organization to cross the LoB (Line of Business). This is to give the total view of organization from:
27 / 50
The divide & conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.
28 / 50
We must try to find the one access tool that will handle all the needs of their users.
29 / 50
: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
30 / 50
Many data warehouse project teams waste enormous amounts of time searching in vain for a _______.
31 / 50
________ gives total view of an organization
32 / 50
_____________ is a process which involves gathering of information about column through execution of certain queries with intention to identify erroneous records.
33 / 50
________ is the technique in which existing heterogeneous segments are reshuffled, relocated into homogeneous segments.
34 / 50
Grain is the ________ level of data stored in the warehouse.
35 / 50
Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as
36 / 50
Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults.
37 / 50
_____ contributes to an under-utilization of valuable and expensive historical data, and inevitably results in a limitedcapability to provide decision support and analysis.
38 / 50
The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.
39 / 50
Pre-computed _______ can solve performance problems
40 / 50
During the application specification activity, we also must give consideration to the organization of the applications.
41 / 50
42 / 50
_____modeling technique is more appropriate for data warehouses.
43 / 50
The _________ is only a small part in realizing the true business value buried within the mountain of data collected and stored within organizations business systems and operational databases.
44 / 50
Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
45 / 50
Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.
46 / 50
With data mining, the best way to accomplish this is by setting aside some of your data in a vault to isolate it from the mining process; once the mining is complete, the results can be tested against the isolated data to confirm the model's _______.
47 / 50
The performance in a MOLAP cube comes from the O(1) look-up time for the array data structure.
48 / 50
49 / 50
Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ .
50 / 50
Execution can be completed successfully or it may be stopped due to some error. In case of successful completion of execution all the transactions will be ___________
Your score is
The average score is 0%
Restart quiz
