CS614 Midterm Online Quiz

0%

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

De-Normalization normally speeds up

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

Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.

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

For a DWH project, the key requirement are ________ and product experience.

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

_________ 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

The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.

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

: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is

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%

0%

Qunoot e Nazilah
Dua e Hajat
4 Qul
6 Kalma
Dua-e-Akasha
Darood Akbar
Surah Fatiha
Dua-e-Ganj Ul Arsh
Dua-e-Jamilah
Ayat-ul-Kursi