CS614 Current Subjective Paper final spring 17 July 2011

[Vuhelper]

Q1
why a pilot project strategy is highly recommended in DWH construction? 5
Q2
define nested loop join list and describe its variants? 5
Q3
describe how business rule are validated using student database in lab lecture? 5
Q4
keeping view the uniform distribution in hash based partition .if the partitions are not
uniformly distributed across the process? 3
Q5
what are the task performed through import export data wizard to load data? 3
Q6
what is mean by click stream? how it can be useful in a web DWH environment? 3
Q7
what is mean by the classification process?how we measure the accuracy of classifiers? 3
Q8
discuss need for indexing with reference to i/o speed? 3
Q9
IN ROUND ROBIN THE DISTRIBUTION IS Pre DEFINED. DO YOU AGREE OR NOT SUPPORT YOUR ANSWER WITH REASON? 2
Q10
what are major operation of data mining? 2
Q11
which scripting language are used to perform complex transformation in DST package? 2
Q12
a person wanted to visit and understand the data warehouse implementation strategies adopted in that organization has refused to allow . what may be the carrier of this refusal?
Q13
how the application of parallelism differ for OLTP and DSS environment? 2