[CS-704C] DATA WAREHOUSING AND DATA MINING [2013-14]

Computer Science and Engineering(CSE) / Information Technology(IT)

CS/B.TECH/CSE(New)/SEM-7/CS-704C/2013-14

2013

DATA WAREHOUSING AND DATA MINING

Time Allotted : 3 Hours                                    Full Marks : 70

The figures in the margin indicate full marks.

Candidates are required to give their answers in their own words

as far as practicable.

GROUP – A

(Multiple Choice Type Question)

1.       Choose the correct alternatives for the following:     10 x 1 = 10

          i)        A Data Warehouse should be

                   a)       subject oriented             b)       integrated

                   c)       time variant                    d)       All of these.

          ii)       In ………………………. Type of schema Fact tables are                       normalized.

                   a)       Snow flake schema

                   b)       Star schema

                   c)       Fact constellation schema

                   d)       None of these.

          iii)      The ‘Dice’ operation is concerned with

                   a)       multiple runs of slice

                   b)       slice on more than one dimension

                   c)       selecting certain cells of more than one dimension

                   d)       two consecutive slice operations in two more                                     dimensions.