Data Warehouses Questions

MCQ bookmark_border

1.

OLAP stands for

A

Online analytical processing

B

Online analysis processing

C

Online transaction processing

D

Online aggregate processing

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

2.

Data that can be modeled as dimension attributes and measure attributes are called _______ data.

A

Multidimensional

B

Singledimensional

C

Measured

D

Dimensional

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

3.

tab which is represented visually is ____________ which is also called as data cube.

A

Two dimensional cube

B

Multidimensional cube

C

N

D

Cuboid

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

4.

tab (Single dimensional) with a fixed value of one attribute is

A

Slicing

B

Dicing

C

Pivoting

D

Both Slicing and Dicing

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

5.

granularity data to a coarser granularity (by means of aggregation) is called a ________

A

Rollup

B

Drill down

C

Dicing

D

Pivoting

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

6.

tabs are created using

A

Slice

B

Dice

C

Pivot

D

All of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

7.

This can be achieved by using which of the following ?

A

group by rollup

B

group by cubic

C

group by

D

none of the mentioned

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

8.

What do data warehouses support?

A

OLAP

B

OLTP

C

OLAP and OLTP

D

Operational databases

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

9.

How many grouping is possible in this rollup?

A

8

B

4

C

2

D

1

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

10.

Which one of the following is the right syntax for DECODE?

A

DECODE

B

DECODE

C

DECODE

D

DECODE

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion