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

www.vustudents.ning.com

 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 online quiz no 01 solution and discussion due date Nov 21, 2014

CS614 online quiz no 01 solution and discussion due date Nov 21, 2014

CS614 Data Warehousing Quiz No. 1 Solution and Discussion Fall 2014 Close Date Nov 21, 2014

CS614 Quiz-1 Nov 20, 2014 12:00 AM Nov 21, 2014

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

+ VU Students Reserves The Right to Delete Your Profile, If?

Views: 1126

.

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

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

### 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.

It is observed that every year the amount of data recorded in an organization

Select correct option:

Doubles

Remains same as previous year

Triples

Quartiles

Question # 2 of 10 ( Start time: 06:50:55 PM )  Total M a r k s: 1

_______ is an application of information and data.

Select correct option:

Knowledge

Intelligence

Power

Education

Question # 3 of 10 ( Start time: 06:52:16 PM )  Total M a r k s: 1

Data Warehouse is about taking / colleting data from different ________ sources.

Select correct option:

Harmonized

Identical

Homogeneous

Heterogeneous

Question # 4 of 10 ( Start time: 06:53:46 PM )  Total M a r k s: 1

The need to synchronize data upon update is called

Select correct option:

Data Imitation

Data Manipulation

Data Replication

Data Coherency

Question # 5 of 10 ( Start time: 06:54:29 PM )  Total M a r k s: 1

________ gives total view of an organization

Select correct option:

OLAP

OLTP

Data Warehouse

Database

Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ .

Select correct option:

Linear

Exponential

Logarithmic

Question # 8 of 10 ( Start time: 06:57:45 PM )  Total M a r k s: 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)

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

cs 614

Attachments:

1. ________ gives total view of an organization

OLAP

OLTP

Data Warehouse

Database

2. The input to the data warehouse can come from OLTP or transactional system but not from other third party database.

True

False

3. In _________ system, the contents change with time.

OLTP

ATM

DSS

OLAP

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

True

False

5. 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:

Owner’s Perspective

Decision Maker Perspective

Customer’s Perspective

Employee's Perspective

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

True

False

7. A Data Warehouse implementation without an OLAP tool is always possible.

True

False

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

True

False

9. Query performance in DSS significantly __________ on physical data model.

Dependent

Independent

10. ________ is a rule of thumb in DBMS, but in DSS ease of use is achieved by way of __________.

Normalization, Denormalization

Denormalization, Normalization

Normalization, Pre-joining

Splitting, Pre-joining

thnqs for sharing

My today's Quiz....

Attachments:

thx budy is main say hi thy sary question to jesy ap nain kiy huy thy isi trha main nain bhi kar diy

What's the problem with LMS. Tomorrow it was not working and same now LMS is not opening have any body face the same problem?

 Extension in due date for Quiz#01 Dated: Nov 24, 14 Dear Students, Due to some technical problem and inaccessibility of VULMS on 21 November, 2014, the due date for Quiz#01 is extended and now due date for Quiz#01 is 26, November, 2014. Those students who missed their quiz previously can attempt Quiz#01 on or before November 26, 2014.

## Latest Activity

+++STUDENT+++ posted discussions
1 minute ago
+++STUDENT+++ liked Azhar Sagar's discussion Learn complete HTML IN 40 Minutes
7 minutes ago
+ "AS" replied to + "AS"'s discussion Neelam Mat Karna ...
12 minutes ago
+ ! Ryan replied to + "AS"'s discussion Neelam Mat Karna ...
18 minutes ago
+ ! Ryan replied to + "AS"'s discussion Neelam Mat Karna ...
18 minutes ago
Azhar Sagar posted a discussion

### Learn complete HTML IN 40 Minutes

24 minutes ago
+ M.Tariq Malik liked + "AS"'s discussion Neelam Mat Karna ...
40 minutes ago
+ M.Tariq Malik liked + Adeeena's discussion har shakhas muhabt krta hae !!!
41 minutes ago
45 minutes ago
+ "AS" liked + "AS"'s discussion Neelam Mat Karna ...
46 minutes ago
+ "AS" posted discussions
46 minutes ago
+ M.Tariq Malik liked + Adeeena's discussion sometimes......
47 minutes ago
Usama Rao is now a member of Virtual University of Pakistan
49 minutes ago
+ "AS" liked + "AS"'s discussion Zabt Sabhi ...
54 minutes ago
+ "AS" liked + "AS"'s discussion Jo Ghair Thy..
1 hour ago
+ ! Ryan replied to + "Jɨyą's discussion me esi hon...!
1 hour ago
2 hours ago
2 hours ago
2 hours ago
2 hours ago

1

2

3