CS614 Midterm Solved MCQs with References by Moaaz

Solved MCQS · From Midterm Papers · Nov 30,2012 · PSMD01 · Spring 2011

The automated, prospective analyses offered by data mining move beyond the analysis of past events provided by respective tools typical of ___________.

1. OLTP
2. OLAP
3. None of these

As apposed to the out come of classification, estimation deal with ____________ valued outcome.

1. Discrete
2. Isolated
3. Continuous (Page 260)
4. Distinct

Correct answer: Continuous (Page 260)

The goal of ideal parallel execution is to completely parallelize those parts of a computation that are not constrained by data dependencies. The __________ the portion of the program that must be executed sequentially, the greater the scalability of computation.

1. Larger
2. Smaller (Page 204)
3. Unambiguous
4. Superior

Correct answer: Smaller (Page 204)

_____________, if fits into memory , costs only one disk I/O access to locate a record by given key.

1. An inverted index
2. A sparse index
3. A dense index (Page 223)
4. none of these

Correct answer: A dense index (Page 223)

The goal of ______is to look at as few block as possible to find the matching records.

1. Indexing (Page 222)
2. Partitioning
3. Joining
4. none of these

Correct answer: Indexing (Page 222)

There are many variants of the traditional nested-loop join, if there is an index is exploited, then it is called……

1. Naïve nested loop join
2. index nested loop join (Page 243)
3. temporary index nested loop join
4. none of these

Correct answer: index nested loop join (Page 243)

The technique that is used to perform these feats in data mining modeling, and this act of model building is something that people have been doing for long time, certainly before the _______ of computers or data mining technology.

1. Access
2. Ascent
3. Avowal

Data mining is a/an ______ approach , where browsing through data using mining techniques may reveal something that might be of interest to the user as information that was unknown previously.

1. Non-Exploratory
2. Exploratory (Page 249)
3. Compute Science
4. none of these

Correct answer: Exploratory (Page 249)

Data mining evolve as mechanism to cater the limitations of _____ systems to deal massive data sets with high dimensionality, new data types, multiple heterogeneous data resources etc...

1. OLTP (Page 254)
2. OLAP
3. DSS
4. DWH

Correct answer: OLTP (Page 254)

Spring 2010

CS614- Data Warehousing (Session - 6)

The need to synchronize data upon update is called

1. Data Manipulation
2. Data Replication
3. Data Coherency (Page 12)
4. Data Imitation

Correct answer: Data Coherency (Page 12)

Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as

1. Distributed Systems Architecture
2. Legacy Systems Architecture (Page 14)
3. Online Systems Architecture
4. Intranet Systems Architecture
5. Owner‟s Perspective
6. Customer’s Perspective (Page 16)
7. Decision Maker‟s Perspective
8. Employee's Perspective