CS614-Midterm
1 / 50
NUMA stands for __________
2 / 50
The goal of ______is to look at as few block as possible to find the matching records.
3 / 50
The automated, prospective analyses offered by data mining move beyond the analysis of past events provided by respective tools typical of ___________.
4 / 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.
5 / 50
There are many variants of the traditional nested-loop join. If the index is built as part of the query plan and subsequently dropped, it is called
6 / 50
When performing objective assessments, companies follow a set of principles to develop metrics specific to their needs, there is hard to have “one size fits all” approach. Which of the following statement represents the pervasive functional forms?
7 / 50
.______ is class of Decision Support Environment.
8 / 50
In a traditional MIS system, there is an almost linear sequence of queries.
9 / 50
Horizontal splitting breaks a table into multiple tables based upon_______
10 / 50
11 / 50
The key idea behind ___________ is to take a big task and break it into subtasks that can be processed concurrently on a stream of data inputs in multiple, overlapping stages of execution.
12 / 50
The purpose of the House of Quality technique is to reduce ______ types of risk.
13 / 50
Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a join between two cubes.
14 / 50
________ is the technique in which existing heterogeneous segments are reshuffled, relocated into homogeneous segments.
15 / 50
If w is the window size and n is the size of data set, then the complexity of merging phase in BSN method is___________
16 / 50
The goal of star schema design is to simplify ________
17 / 50
It is observed that every year the amount of data recorded in an organization :
18 / 50
A data warehouse implementation without an OLAP tool is always possible.
19 / 50
In _________ system, the contents change with time. :
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
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 ___________
22 / 50
A single database, couldn‟t serve both operational high performance transaction processing and DSS, analytical processing, all at the same time.
23 / 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.
24 / 50
It is observed that every year the amount of data recorded in anorganization is
25 / 50
If every key in the data file is represented in the index file then index is :
26 / 50
Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.
27 / 50
DOLAP allows download of “cube” structures to a desktop platform with the need for shared relational or cube server.
28 / 50
Focusing on data warehouse delivery only often end up _________.
29 / 50
30.Data Warehouse is about taking / colleting data from different ________ sources:
30 / 50
As apposed to the out come of classification, estimation deal with ____________ valued outcome.
31 / 50
B-Tree is used as an index to provide access to records
32 / 50
Pre-join technique is used to avoid
33 / 50
To measure or quantify the similarity or dissimilarity, different techniques are available. Which of the following option represent the name of available techniques?
34 / 50
The performance in a MOLAP cube comes from the O(1) look-up time for the array data structure.
35 / 50
36 / 50
: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
37 / 50
_____________, if fits into memory , costs only one disk I/O access to locate a record by given key.
38 / 50
39 / 50
40 / 50
For a relation to be in 4NF it must be:-
41 / 50
During the application specification activity, we also must give consideration to the organization of the applications.
42 / 50
Ad-hoc access means to run such queries which are known already.
43 / 50
DSS queries do not involve a primary key
44 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
45 / 50
Cube is a __________ entity containing values of a certain fact at a certain aggregation level at an intersection of a combination of dimensions.
46 / 50
Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults.
47 / 50
in agriculture extension is that pest population beyond which the benefit of spraying outweighs levels
48 / 50
Investing years in architecture and forgetting the primary purpose of solving business problems, results in inefficient application. This is the example of _________ mistake.
49 / 50
Data mining uses _________ algorithms to discover patterns and regularities in data.
50 / 50
Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.
Your score is
The average score is 0%
Restart quiz