Font size
WorksheetsDWDM Unit1 Quiz
Total questions: 21
Worksheet time: 11mins
operational database system is also called as
OLMP
OLAP
OLTP
OLNP
Data warehouse system is also called as
OLMP
OLAP
OLTP
OLNP
Multidimensional data model can exist in ........................forms
star model
sowflake model
fact constellation model
All the above
........................collects all of the information about subjects spanning the entire organization
Enterprise warehouse
datamart
virtual warehouse
none
............................is defined as a subset of data warehouse
enterprise warehouse
data mart
virtual warehouse
none
....................is a set of views over operational databases
enterprise warehouse
datamart
virtual warehouse
none
Top tier of 3-tier data warehouse architecture contains................
front end tools
OLAP server
OLTP server
backendtools
Middle tier of a 3-tier data warehouse architecture contains...........
front-end tools
OLAP server
OLTP server
backend tools
................is defined as data about data
datamart
metadata
consistent data
rawdata
..............operator is used to compute cube.
"create cube"
"perform cube"
"compute cube"
"calculate cube"
If there are 3 dimensions,then a cube generated using "compute cube operator" contains.......................number of cuboids.
8
16
3
6
.................is the drawback of "compute cube" operator
"Cure of fact"
"Huge Dimensionality"
"curse of functionality"
"curse of dimensionality"
................is the solution for "curse of dimensionality" problem.
preprocessing
Indexing
Partial materialization
cube materialization
The.......................... is an alternative representation of the record ID (RID) list.
Bitmap-Index
Join-Index
Tree-index
Hash index
............... registers the joinable rows of two relations from a relational database.
bitmap indexing
join indexing
hash indexing
tree indexing
roll up operation is also called as...........
roll on
drill up
drill on
roll on
drill-down operation is reverse of ............
dice
slice
roll-up
roll-on
pivot operation is also called as...........
select
interact
rotate
multiply
.................operation performs a selection on one dimension of the give cube ,resulting in a sub cube
slice
dice
mice
lice
...................are OLAP operations
roll-on
slice
dice
roll-up
drill-down
...............operation defines a sub-cube by performing a selection on two or more dimensions .
slice
dice
lice
mice
