wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

DWDM Unit1 Quiz

Total questions: 21

Worksheet time: 11mins

Name
Class
Date
1.

operational database system is also called as

a)

OLMP

b)

OLAP

c)

OLTP

d)

OLNP

2.

Data warehouse system is also called as

a)

OLMP

b)

OLAP

c)

OLTP

d)

OLNP

3.

Multidimensional data model can exist in ........................forms

a)

star model

b)

sowflake model

c)

fact constellation model

d)

All the above

4.

........................collects all of the information about subjects spanning the entire organization

a)

Enterprise warehouse

b)

datamart

c)

virtual warehouse

d)

none

5.

............................is defined as a subset of data warehouse

a)

enterprise warehouse

b)

data mart

c)

virtual warehouse

d)

none

6.

....................is a set of views over operational databases

a)

enterprise warehouse

b)

datamart

c)

virtual warehouse

d)

none

7.

Top tier of 3-tier data warehouse architecture contains................

a)

front end tools

b)

OLAP server

c)

OLTP server

d)

backendtools

8.

Middle tier of a 3-tier data warehouse architecture contains...........

a)

front-end tools

b)

OLAP server

c)

OLTP server

d)

backend tools

9.

................is defined as data about data

a)

datamart

b)

metadata

c)

consistent data

d)

rawdata

10.

..............operator is used to compute cube.

a)

"create cube"

b)

"perform cube"

c)

"compute cube"

d)

"calculate cube"

11.

If there are 3 dimensions,then a cube generated using "compute cube operator" contains.......................number of cuboids.

a)

8

b)

16

c)

3

d)

6

12.

.................is the drawback of "compute cube" operator

a)

"Cure of fact"

b)

"Huge Dimensionality"

c)

"curse of functionality"

d)

"curse of dimensionality"

13.

................is the solution for "curse of dimensionality" problem.

a)

preprocessing

b)

Indexing

c)

Partial materialization

d)

cube materialization

14.

The.......................... is an alternative representation of the record ID (RID) list.

a)

Bitmap-Index

b)

Join-Index

c)

Tree-index

d)

Hash index

15.

............... registers the joinable rows of two relations from a relational database.

a)

bitmap indexing

b)

join indexing

c)

hash indexing

d)

tree indexing

16.

roll up operation is also called as...........

a)

roll on

b)

drill up

c)

drill on

d)

roll on

17.

drill-down operation is reverse of ............

a)

dice

b)

slice

c)

roll-up

d)

roll-on

18.

pivot operation is also called as...........

a)

select

b)

interact

c)

rotate

d)

multiply

19.

.................operation performs a selection on one dimension of the give cube ,resulting in a sub cube

a)

slice

b)

dice

c)

mice

d)

lice

20.

...................are OLAP operations

a)

roll-on

b)

slice

c)

dice

d)

roll-up

e)

drill-down

21.

...............operation defines a sub-cube by performing a selection on two or more dimensions .

a)

slice

b)

dice

c)

lice

d)

mice