Quiz Start Time: 10:55 AM Time Left 89View more random threads:
- MKT501 Marketing Management quiz fall 2010
- CS403 Database Management Systems Quiz Fall Semester 2012
- FINALTERM EXAMINATION Fall 2011 ENG101 English Comprehensi
- cs504 software engineering all mcq's fall 2010
- Which of the following is true about primitive data types...
- cs605 mid term paper spring 2011
- With URL rewriting, the information appended to URL can be...
- ISL201-Islamic Studies VU Online Quiz 3 Solution Last Date...
- cs302 quiz by Saira Qamar
- cs601 mid term paper 2011 virtual university of pakistan
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
Sponsored Links
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
There are currently 1 users browsing this thread. (0 members and 1 guests)