We have been working very hard since 2009 to facilitate in learning Read More. We can't keep up without your support. Donate.

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

# CS614 Current MID Term Papers Fall 2012 Date: 08-December-2012 to 19-December-2012

CS614 Current MID Term Papers Fall 2012 Date: 08-December-2012 to 19-December-2012

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Views: 4922

### Replies to This Discussion

mc110404712 thanks for sharing

Note for All Members: You don’t need to go any other site for current Mid Term papers fall 2012, Because All discussed data/sharing of our members in this discussion are going from here to other sites. You can judge this at other sites yourself. So don’t waste your precious time with different links.

My cs614 paper

Mcqs:

 Grain is the ________ level of data stored in the warehouse. ► Atomic ► Summarized ► Aggregated ► Cube

 During ETL process of an organization, suppose you have data which can be transformed using any of the transformation method. Which of the following strategy will be your choice for least complexity? ► One-to-One Scalar Transformation ► One-to-Many Element Transformation ► Many-to-Many Element Transformation ► Many-to-One Element Transformation

Change Data Capture is one of the challenging technical issues in _____________

► Data Extraction

► Data Transformation

► Data Cleansing

 ______ is class of Decision Support Environment. ► OLTP ► OLAP ► DBMS ► Network

 Horizontal splitting breaks a table into multiple tables based upon_______ ► Common Row values ► Range of Data. ► Redundant data. ► Common column values.

The most common use of range partitioning is on ______.

► Date

► Rows

► DSS

► None of these

All data is ______________ of something real.

IAn Abstraction

IIA Representation

Which of the following option is true?

► I Only

► II Only

► Both I & II

► None of I & II

 Pre-computed _______ can solve performance problems ►Aggregates ►Facts ►Dimensions

 Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ . ►Linear ►Quadratic ►Exponential ►logarithmic

Experience showed that for a single pass of a magnetic tape that scanned 100% of the records, only ________of the records

• 5%
• 50%
• 8%
• 60%

To handle dimensions that requires the aggregation of multiple data quality indicators

,the _____can be applied.

• Min or max operation
• Complex ratio
• Average weight

In the Information Age, the______ learning organization is at a distinct disadvantage. The term dysfunctional means "impaired or abnormal functioning."

• Functional
• Dysfunctional

ETL is _____steps.

• Independent and interrelated
• Independent or interrelated
• Dependent and interrelated

Insurance data warehouses are similar to other data warehouses with a few exceptions: such as the length of time that insurance data warehouses exists, in terms of the dates found in the business,

How Much Data is that? 1GB

• 230 or 109 bytes
• 240 or 1012 bytes
• 220 or 106 bytes

The effects of denormalization on database performance are _____

• Unpredictable
• Predictable

OLAP is Analytical Processing instead of Transaction Processing. It is also NOT a physical database design or implementation technique, but a framework.

The classic statement of ____is “decision making is an iterative process; which must involve the users”.

• OLAP
• DWH
• OLTP

ER is a _____design technique that seeks to remove the redundancy in data.

• Logical
• Physical

Subject questions:

Write to reason of increase in cube size in MOLAP. 2 marks

Write first two steps of Basic Sorted Neighborhood (BSN) Method. 2 marks

Justify this statement either correct or incorrect

“if defect are found in process of Attribute Domain Validation it is better to fix error in DWH and leave the data source as it is”. 3 marks

Justify the statement valid or invalid with reasons

“Dimension are quantitative and numerical measurements such as sales \$".(3 marks)

Identify the given statement as correct and incorrect

1."in Molap the complexity cannot go beyond o(1) in any case"

2."Drill down is a cube operation and its basic purpose is to select and project".5 marks

Identify the given statement as correct and incorrect

1.“Lexical error is a type of coverage anomaly”

2.“Data cleansing process is describe as semi automatic but can be performed without the involvement of a domain expert”. 5 marks

✿Bîã✿ Thanks for sharing

Note for All Members: You don’t need to go any other site for current Mid Term papers fall 2012, Because All discussed data/sharing of our members in this discussion are going from here to other sites. You can judge this at other sites yourself. So don’t waste your precious time with different links.

jazak allah ✿Bîã✿

Exact wording in not ensured:
1. Benefits of CDC in modern systems? 2
2. List 4 techniques of handling "Multi-Dimensions"? 2
3. In MOLAP, the aggregates are large, but is it possible that some aggregates have null value, give example to justify? 3
4. 5th Orr's law ? 3
1. STDDEV is a distributive aggregate? 2.5
2. The data that is not used is correct? 2.5

okay dears keep it up plz share answers too MAY ALLAH HELP US

plz in questions k answer b share kr dain yahan........

kuch solve kiye hain mere ini mein se ay thy ...

Attachments:

brother WAQI thanks lekn plz references bhi den jo koi bhi share kry plz reference bhi dy i wl also gv sme reference

see this
"offline extraction is a type of logical extraction" FALSE page # 132
plz ap bhi isi tra reference btaya kren mje to nai ml rhy kch questions plz hlp friends..........

1

2

3

4

5

## Latest Activity

2 hours ago
2 hours ago
Zoha n liked + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion !!!!TRUE LOVE NEVER DIES!!!!
3 hours ago
Zoha n liked + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion !!!!TRUE LOVE NEVER DIES!!!!
3 hours ago
Zoha n liked + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion !!!! !!!!!!
3 hours ago
Zoha n liked D\$OuLoVeRwHeLm€d's discussion dildar❤
3 hours ago
Zoha n liked + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion !!!! !!!!!!
3 hours ago
Zoha n liked + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion !!!indeedl!!!!
3 hours ago
Zoha n liked + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion !!!! bilkul!!!!
3 hours ago
Zoha n liked D\$OuLoVeRwHeLm€d's discussion Mohabbat
3 hours ago
3 hours ago
3 hours ago