Rajasthan Polytechnic Third Year Paper 2016 – Data Warehouse & Mining

Rajasthan Polytechnic Third Year Paper 2016 – Data Warehouse & Mining

The data ware house is
(a) read only
(b) write only
(c) read-write only
(d) None

Expansion for DSS in Data warehouse is
(a) Decision Single System
(b) Decision Support system
(c) Data Storable System
(d) Data Support System

Data found in the data warehouse are of following type
(a) Subject oriented
(b) Time-variant
(c) Integrated
(d) All of above

The time horizon in Data Warehouse is usually
(a) 1-2 years
(b) 3-4 years
(c) 5-6 years
(d) 5-10 years

The Data is stored, retrieved and updated in
(a) OLAP
(b) OLTP
(c) SMTP
(d) FTP

Dta contained in data warehouse is described by
(a) Relatinal data
(b) Operational data
(c) Meta data
(d) Informational data

___________is used to predict future trends and behaviour
(a) Data warehouse
(b) Data mining
(c) Data mart
(d) Meta data

____________is the specialized data warehouse database.
(a) Oracle
(b) Informix
(c) DBZ
(d) Red brick

__________is held in the catelog of the warehouse database system.
(a) Application level meta data
(b) Algorithm level meta data
(c) Departmental level meta data
(d) Core warehouse meta data

Detail data in single fact table is also known as
(a) Monoatomic data
(b) Diatomatic data
(c) Atomic data
(d) Multiatomic data