www.vustudents.ning.com

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.

# 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

Views: 1237

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

1

2

3

4

5

5 hours ago
5 hours ago
7 hours ago
7 hours ago
7 hours ago
7 hours ago
7 hours ago
7 hours ago