We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

CS614 Quiz No. 1 Solution and Discussion Fall 2015 Close Date Tuesday, 24th November, 2015

CS614 Quiz No. 1 Solution and Discussion Fall 2015 Close Date Tuesday, 24th November, 2015

Quiz No.1 Dated: Nov 16, 15
Dear Students

Quiz # 1 will start from Monday, 23rd November, 2015 and will remain open for two days the last day will be Tuesday, 24th November, 2015. The lectures included in this quiz will be from Lecture # 1 to Lecture # 10.

Read the following instructions carefully before attempting the Quiz.

Quiz will be based upon Multiple Choice Questions.
You have to attempt the quiz online.
You can start attempting the quiz any time within given date(s) of a particular subject by clicking the link for Quiz in LMS.
It will be opened only for Two days (48 Hours). All overseas students should manage their quiz time according to Pakistan Standard Time (PST).
The time to attempt the Quiz is limited. Once you login to attempt the quiz, the countdown will start and you have to complete the quiz in given amount of time. So always keep an eye on the remaining time.
Attempting quiz is unidirectional. Once you move forward to the next question, you cannot come back to the previous one. Therefore before moving to the next question, make sure that you have selected the best option.
If due to any reason, access to internet is lost (like power failure or disconnection of internet), you will be able to attempt the quiz again from the position where you left in last attempt. But remember that you have to complete the quiz before expiry of the deadline.

If any student failed to attempt the quiz in given time then no re-take or offline quiz will be held.

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..

..How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?..


See Your Saved Posts Timeline

Views: 939

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Replies to This Discussion

Please all students related this subject Share your online Quizzes here to help each other.thanks

Please share the question and their answers of this quiz if anyone has done.
Thanks.

today quize

Attachments:

CS614_Solved_Quiz

Attachments:

 

Data Ware house

Solved quisez…

 

 

 

A data warehouse implementation without an OLAP tool is always possible.
True
False 
 
_____modeling technique is more appropriate for data warehouses.
entity-relationship
dimensional
physical
None of the given 
 


The performance in a MOLAP cube comes from the O(1) look-up time for the array data structure. 
True
False 
 
Multi-dimensional databases (MDDs) typically use ___________ formats to store pre-summarized cube structures.
SQL
proprietary file
Object oriented
Non- proprietary file
 
Slice and Dice is changing the view of the data.
True
False
  
Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.
 Unusual
Essential
Optional
None of the given
 
Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a join between two cubes.
 True
False
 
Analytical processing uses ____________ , instead of record level access.
multi-level aggregates
Single-level aggregates
Single-level hierarchy
None of the Given

The divide&conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.
Flexibility
Maintainability
Security
Scalability

In a traditional MIS system, there is an almost linear sequence of queries.
True
False

Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
Mandatory
Whole
Analysis
Prediction

 

In a traditional MIS system, there is an almost linear sequence of queries.

True    

False

 

_____modeling technique is more appropriate for data warehouses.

Entity-relationship

Dimensional

Physical

None of the given

 

A data warehouse implementation without an OLAP tool is always possible.

True   

False

 

Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a join between two cubes.

 

True  

False

 

Multi-dimensional databases (MDDs) typically use ___________ formats to store pre-summarized cube structures.

 

SQL

Proprietary file

Object oriented

Non- proprietary file

 

Analytical processing uses ____________ , instead of record level access.

 

Multi-level aggregates

Single-level aggregates

Single-level hierarchy

None of the Given

 

Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.

Mandatory

Whole

Analysis

Prediction

 

Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.

 

Unusual

Essential

Optional

None

 

The STAR schema used for data design is a __________ consisting of fact and dimension tables

 

Network model

Relational model

Hierarchical data model

None

 

The performance in a MOLAP cube comes from the O (1) look-up time for the array data structure.

 

True

 False

 

the divide conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.

Flexibility

Maintainability

 Security

Scalability

 

DOLAP allows download of “cube” structures to a desktop platform with the need for shared relational or cube server.

 

True  

False


A data warehouse implementation without an OLAP tool is always possible.
True
False


_____modeling technique is more appropriate for data warehouses.
entity-relationship
dimensional
physical
None of the given


The performance in a MOLAP cube comes from the O(1) look-up time for the array data
structure.
True
False


Multi-dimensional databases (MDDs) typically use ___________ formats to store presummarized cube structures.
SQL
proprietary file
Object oriented
Non- proprietary file


Slice and Dice is changing the view of the data.
True
False


Data warehousing and on-line analytical processing (OLAP) are _______ elements of
decision support system.

Unusual
Essential
Optional
None of the given


Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a
join between two cubes.
True
False


Analytical processing uses ____________ , instead of record level access.
multi-level aggregates
Single-level aggregates
Single-level hierarchy
None of the Given


The divide&conquer cube partitioning approach helps alleviate the ____________
limitations of MOLAP implementation.
Flexibility
Maintainability
Security
Scalability


In a traditional MIS system, there is an almost linear sequence of queries.
True
False


Data Warehouse provides the best support for analysis while OLAP carries out the
_________ task.
Mandatory
Whole
Analysis

 

A data warehouse implementation without an OLAP tool is always possible.
True
False

_____modeling technique is more appropriate for data warehouses.
entity-relationship
dimensional
physical
None of the given

The performance in a MOLAP cube comes from the O(1) look-up time for the array data
structure.
True
False

Multi-dimensional databases (MDDs) typically use ___________ formats to store presummarized cube structures.
SQL
proprietary file
Object oriented
Non- proprietary file

Slice and Dice is changing the view of the data.
True
False

Data warehousing and on-line analytical processing (OLAP) are _______ elements of
decision support system.

Unusual
Essential
Optional
None of the given

Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a
join between two cubes.
True
False

Analytical processing uses ____________ , instead of record level access.
multi-level aggregates
Single-level aggregates
Single-level hierarchy
None of the Given

The divide&conquer cube partitioning approach helps alleviate the ____________
limitations of MOLAP implementation.
Flexibility
Maintainability
Security
Scalability

In a traditional MIS system, there is an almost linear sequence of queries.
True
False

Data Warehouse provides the best support for analysis while OLAP carries out the
_________ task.
Mandatory
Whole
Analysis

In a traditional MIS system, there is an almost linear sequence of queries.
True 
False

_____modeling technique is more appropriate for data warehouses.
Entity-relationship
Dimensional
Physical
None of the given

A data warehouse implementation without an OLAP tool is always possible.
True 
False

Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a join between two cubes.

True 
False

Multi-dimensional databases (MDDs) typically use ___________ formats to store pre-summarized cube structures.

SQL
Proprietary file
Object oriented
Non- proprietary file

Analytical processing uses ____________ , instead of record level access.

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

Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
Mandatory
Whole
Analysis
Prediction

Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.

Unusual
Essential
Optional
None

The STAR schema used for data design is a __________ consisting of fact and dimension tables

Network model
Relational model
Hierarchical data model
None

The performance in a MOLAP cube comes from the O (1) look-up time for the array data structure.

True
False

the divide conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.
Flexibility
Maintainability
Security
Scalability

DOLAP allows download of “cube” structures to a desktop platform with the need for shared relational or cube server.

True 
False

Quizz 02:
Question # 1 of 10 ( Start time: 12:14:39 PM ) Total Marks: 1 
In _________ system, the contents change with time. 
Select correct option:

OLTP

OLTP
ATM

DSS
OLAP 
Quiz Start Time: 12:14 PM Time Left 85
sec(s) 
Question # 2 of 10 ( Start time: 12:15:08 PM ) Total Marks: 1 
Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults. 
Select correct option:

O (n lg n)

O (lg n)

O (n)

O (n2)

Quiz Start Time: 12:14 PM Time Left 89
sec(s)

Question # 3 of 10 ( Start time: 12:15:34 PM ) Total Marks: 1 
Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as 
Select correct option:

Distributed Systems Architecture
Legacy Systems Architecture
Online Systems Architecture
Intranet Systems Architecture

Quiz Start Time: 12:14 PM Time Left 88
sec(s) 
Question # 4 of 10 ( Start time: 12:16:16 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

Question # 5 of 10 ( Start time: 12:16:49 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 # 6 of 10 ( Start time: 12:18:19 PM ) Total Marks: 1 
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 # 7 of 10 ( Start time: 12:19:42 PM ) Total Marks: 1 
_______ is an application of information and data. 
Select correct option:

Knowledge

Intelligence

Power
Education

Question # 8 of 10 ( Start time: 12:20:13 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 # 10 of 10 ( Start time: 12:21:01 PM ) Total Marks: 1 
The need to synchronize data upon update is called 
Select correct option:

Data Imitation

Data Manipulation

Data Replication

Data Coherency

Quiz 01:

The growth of master files and magnetic tapes exploded around the mid- _______. 
Select correct option:

1950s. 
1960s. 
1970s. 
1980s.

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

In _________ system, the contents change with time.
OLTP
ATM
DSS
OLAP

Relational databases allow you to navigate the data in ____________ that is appropriate using the primary, foreign key structure within the data model.
Only One Direction
Any Direction
Two Direction
None of these

Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.
Relaxed
Good
Not Relaxed
None

A single database, couldn’t serve both operational high performance transaction processing and DSS, analytical processing, all at the same time.
True 
False

Data Warehouse is about taking / colleting data from different Heterogeneous sources.
Harmonized
Identical
Homogeneous
Heterogeneous

________ gives total view of an organization
Select correct option:
OLAP
OLTP
Data Warehouse
Database

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

The need to synchronize data upon update is called

Select correct option:
Data Imitation
Data Manipulation
Data Replication
Data Coherency

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

For good decision making, data should be integrated across the organization to cross the LoB (Line of Business). This is to give the total view of organization from:

Select correct option:
Owner’s Perspective
Decision Maker Perspective
Customer’s Perspective
Employee's Perspective

________ gives total view of an organization

Select correct option:

OLAP
OLTP 
Data Warehouse
Database

Relational databases allow you to navigate the data in ____________ that is appropriate using the primary, foreign key structure within the data model.
Select correct option:

Only One Direction
Any Direction
Two Direction
None of these

B-Tree is used as an index to provide access to records 
Without scanning the entire table
By scanning the entire meta data
Scanning the entire table
None of these

In _________ system, the contents change with time. 
OLTP OLTP
ATM
DSS
OLAP

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

Ad-hoc access means to run such queries which are known already.
True
False

The need to synchronize data upon update is called
Data Imitation
Data Manipulation
Data Replication
Data Coherency

The users of data warehouse are knowledge workers in other words they are _________ in the organization.
DWH Analyst
Decision maker
Database Administrator
Manager

Data Warehouse is about taking / colleting data from different ________ sources.
Harmonized
Identical
Homogeneous
Heterogeneous

It is observed that every year the amount of data recorded in an organization
Doubles
Remains same as previous year
Triples

RSS

Latest Activity

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service