wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Data warehouse unit 1

Total questions: 15

Worksheet time: 3mins

Name
Class
Date
1.

Which is not a property of data warehouse?

a)

subject oriented

b)

time variant

c)

collection from heterogeneous sources

d)

volatile

2.

data warehousing used in_______________

a)

transaction system

b)

decision support system

3.

What are the characeristics of OLAP systems?

a)

query driven

b)

integrated

c)

less users

d)

store current data

4.

Which system is application oriented?

a)

Online transaction processing system

b)

Online analytical processing system

5.

Which operation can perform on data warehouse?

a)

read/write

b)

modify

c)

alter

d)

scan

6.

data warehouse is based on_____________

a)

two dimensional model

b)

three dimensional model

c)

multidimensional model

d)

unidirectional model

7.

Data warehousing is related to______

a)

create data warehouse

b)

update data

c)

scan and load data for analysis

d)

write new data

8.

Data mining means______

a)

data fetching

b)

data accesing

c)

knowledge discovery

9.

Which book is suggested for reference?

a)

Pieter Adriaans

b)

Arun k Pujari

c)

Han and Kamber

d)

Margerat

10.

multidimensional model of data warehouse called as__

a)

data structure

b)

table

c)

data cube

d)

tree

11.

a data warehouse can include

a)

flat-files

b)

database table

c)

online data

d)

all

12.

OLAP usage

a)

repetitive

b)

adhoc

c)

none

13.

subject name

a)

DM

b)

DMDW

c)

DWDM

d)

DWM

14.

tool going to use in LAB

a)

Jupyter

b)

Weka

c)

Shawak

d)

Eclipse

15.

Do u like this subject?

a)

yes

b)

no