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

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


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

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

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)


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 Loading

► 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
Justify your answer as TRUE or FALSE:
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........

jee plz share answers too

emiahmad thanks

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..........

RSS

© 2021   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.