CS614 Data Warehousing Quiz No.01 Spring Semester 2012

[Vuhelper]

CS614 Data Warehousing Quiz No.01 Spring Semester 2012

1st Quiz will be open for one day (24 hours) on 12th of NOVEMBER.

Lecture no 1 to Lecture no 8 will be included in the Quiz.
Please Share your online Quizzes here to help each other.thanks



Question # 1 of 10 ( Start time: 02:39:46 PM ) Total Marks: 1
The growth of master files and magnetic tapes exploded around the mid- _______.
Select correct option:
1950s.
1960s.
1970s.
1980s.


Question # 2 of 10 ( Start time: 02:40:24 PM ) Total Marks: 1
A single database, couldn’t serve both operational high performance transaction processing and DSS, analytical processing, all at the same time.
Select correct option:
True
False

Question # 3 of 10 ( Start time: 02:41:43 PM ) Total Marks: 1
In _________ system, the contents change with time.
Select correct option:
OLTP OLTP
ATM
DSS
OLAP
Question # 4 of 10 ( Start time: 02:43:10 PM ) Total Marks: 1
The input to the data warehouse can come from OLTP or transactional system but not from other third party database.
Select correct option:
True
False

Question # 5 of 10 ( Start time: 02:43:42 PM ) Total Marks: 1
Ad-hoc access means to run such queries which are known already.
Select correct option:
True
False

Question # 6 of 10 ( Start time: 02:43:58 PM ) Total Marks: 1
________ gives total view of an organization
Select correct option:
OLAP
OLTP
Data Warehouse
Database
Question # 7 of 10 ( Start time: 02:44:45 PM ) Total Marks: 1
Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ .
Select correct option:
Linear
Quadratic
Exponential
Logarithmic

Question # 8 of 10 ( Start time: 02:45:26 PM ) Total Marks: 1
The users of data warehouse are knowledge workers in other words they are _________ in the organization.
Select correct option:
DWH Analyst
Decision maker
Database Administrator
Manager
B-Tree is used as an index to provide access to records
Select correct option:
Without scanning the entire table
By scanning the entire meta data
By scanning the entire table
None of these
Question # 10 of 10 ( Start time: 02:46:04 PM ) Total Marks: 1
_______ is an application of information and data.
Select correct option:
Knowledge
Intelligence
Power
Education