cs614 1st Quize 17 nov-2011

[msmunirm1]

Quiz Start Time: 10:55 AM Time Left 89
sec(s)


Question # 1 of 10 ( Start time: 10:55:43 AM ) Total Marks: 1
The STAR schema used for data design is a __________ consisting of fact and dimension tables.
Select correct option:

Network model
Relational model
Hierarchical data model
None of the given








Quiz Start Time: 10:55 AM Time Left 89
sec(s)


Question # 2 of 10 ( Start time: 10:57:07 AM ) Total Marks: 1
The performance in a MOLAP cube comes from the O(1) look-up time for the array data structure.
Select correct option:

True
False







Quiz Start Time: 10:55 AM Time Left 88
sec(s)


Question # 3 of 10 ( Start time: 10:57:50 AM ) Total Marks: 1
A data warehouse implementation without an OLAP tool is always possible.
Select correct option:

True
False







Quiz Start Time: 10:55 AM Time Left 89
sec(s)


Question # 4 of 10 ( Start time: 10:58:40 AM ) Total Marks: 1
In a traditional MIS system, there is an almost linear sequence of queries.
Select correct option:

True
False





Quiz Start Time: 10:55 AM Time Left 89
sec(s)


Question # 5 of 10 ( Start time: 10:59:11 AM ) Total Marks: 1
Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
Select correct option:

Mandatory
Whole
Analysis
Prediction








Quiz Start Time: 10:55 AM Time Left 89
sec(s)


Question # 6 of 10 ( Start time: 10:59:29 AM ) Total Marks: 1
The divide&conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.
Select correct option:

Flexibility
Maintainability
Security
Scalability








Quiz Start Time: 10:55 AM Time Left 89
sec(s)


Question # 7 of 10 ( Start time: 10:59:50 AM ) Total Marks: 1
_____modeling technique is more appropriate for data warehouses.
Select correct option:

entity-relationship
dimensional
physical
None of the given








Quiz Start Time: 10:55 AM Time Left 89
sec(s)


Question # 8 of 10 ( Start time: 11:00:56 AM ) Total Marks: 1
Multi-dimensional databases (MDDs) typically use ___________ formats to store pre-summarized cube structures.
Select correct option:

SQL
proprietary file
Object oriented
Non- proprietary file









Quiz Start Time: 10:55 AM Time Left 86
sec(s)


Question # 9 of 10 ( Start time: 11:01:19 AM ) Total Marks: 1
Analytical processing uses ____________ , instead of record level access.
Select correct option:

multi-level aggregates
Single-level aggregates
Single-level hierarchy
None of the Given







Quiz Start Time: 10:55 AM Time Left 89
sec(s)


Question # 10 of 10 ( Start time: 11:01:41 AM ) Total Marks: 1
Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.
Select correct option:

Unusual
Essential
Optional
None of the given