NEW
Font size
WorksheetsDMDW - Quiz1
Total questions: 8
Worksheet time: 4mins
The data Warehouse is__________.
Read only.
write only
read write only
none.
Expansion for DSS in DW is__________.
decision support system.
decision single system.
data storable system.
data support system.
The important aspect of the data warehouse environment is that data found within the data warehouseis___________.
subject-oriented.
time-variant.
integrated.
all of the above.
The time horizon in Data warehouse is usually __________.
1-2 years.
3-4years.
5-6 years.
5-10 years.
The data is stored, retrieved & updated in ____________.
olap.
oltp.
smtp.
ftp.
__________ is the heart of the warehouse.
data mining database servers.
data warehouse database servers.
data mart database servers.
relational data base servers.
________________ is held in the catalog of the warehouse database system.
application level metadata.
algorithmic level metadata.
departmental level metadata.
core warehouse metadata.
______________databases are owned by particular departments or business groups.
informational.
operational.
both informational and operational.
flat.
