 |
|
#1
11-30-2011, 09:28 PM
|
||||
|
||||
cs614 midterm new paper
latest pare cs614, mid term
DATE : 19-05-20011 PAPER : MID TERM MCQ'S ............ MARKS 16. SHORT QUESTIONS:- Q1:- EXPLAIN INCREMENTED EXTRUCTION ? MARKS ( 2 ) Q2:- CLANSING CAN BE BREAK DOWN IN HOW MANY STEPS? MARKS ( 2 ) Q3:- HOW THE FOLLOWING DIMENSION CAN MAKE OF MAX OPERATOR IN THE MIN-MAX OPERATION ? MARKS ( 3 ) Q4:- LOOKING AT THE BENEFITS OF THE CUBE PARTITIONING ANALYZE WHEN IT IS REQUIRED TO PARTITON CUBE ? MARKS ( 3 ) Q5:- WRITE BENEFITS OF DOLAP AND HOLAP AND MOLAP AND ROLAP ? MARKS ( 5 ) Q6:- IN DATA WAREHOUSE, WE CASE DE-NORMALIZATION WHICH MEANS THERE IS REDUNDANT DATA. BUT IF THERE IS DUPLICATION IN SOURCE SYSTEM WE TRY TO REMOVE THIS DUPLICATION. HOW THE DATA DUPLICATION IN SOURCE SYSTEM HAVE AN EFFECT ON ANALYSIS PROCESS IN DATA WAREHOUSE SYSTEM MARKS ( 5 ) >>MCQ’s from past papers not at all • Define incremental Extraction.[2] • Define simple one-to-many transformation.[2] • In Round Robin the distribution.[3] • Define additive and non-additive of facts.[3] • What is ELT? Where and why it is used? [3] • Define Phaysical Extraction and difference between offline and online extraction.[5] • Relationship between quality and value of a particular application [5] Current CS614 Paper (14/5/11) why aggregration is one way?give example page 103 lecture14 define onte-to-many transformation? page132 lecture17 diff b/w knowledge drivenDSS and Modal driven DSS? what is distance function ? what are alternative distance function fot typorgaphical mistake? page 162 lecture20 good features of DOLAP that distinguish it from others? lecture 10 page 66 adverse features of MOLAP? realtionship b/w data quality and value of particular application? difference b/w full and incremental extraction. (5) describe orr's law of data quality (5) horizontal splitting technique: round robin and hash (3) define one to many transformation (2) fact table (2) active DWH ? lexical error ? other mcqs from old papers... todays paper questions why aggregration is one way?give example page 103 lecture14 define onte-to-many transformation? page132 lecture17 diff b/w knowledge drivenDSS and Modal driven DSS? what is distance function ? what are alternative distance function fot typorgaphical mistake? page 162 lecture20 good features of DOLAP that distinguish it from others? lecture 10 page 66 adverse features of MOLAP? realtionship b/w data quality and value of particular application? 
|
|
Linear Mode
