Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

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

Quiz No. 2Dated:Jan 29, 20

Dear Students,


As you know that VU has initiated online quiz system. Therefore your Quiz # 02 of CS614 (Data Warehousing) for your Final term exam preparation will be held on February 06, 2020 (Thursday) to February 07, 2020 (Friday) (Quiz open for Two days) containing Lessons from Lecture # 23 to Lecture # 40.


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.


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 can not come back to the previous one. Therefore before moving to the next question, make sure that you have selected the best option.


If for any reason, you lose access to internet (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.


Best of Luck!

Views: 1679

Replies to This Discussion

My Quiz (solved) attempted on 6th Feb 2020

    1. _____ says that as far as company goals are concerned, the entire company pursues in the same direction


    1. Westerman (Pg 285)
    2. Bill inmon
    3. Kimball
    4. Bohnlein


    1. In context of data mining definition, the term “value” means:


    1. The primary key of table
    2. The index location of record
    3. importance of hidden parameters discovered (Pg 250)
    4. Numerical or string measure assigned to an attribute


    1. In B-tree index, the lowest level index blocks are called leaf blocks, and these blocks contain:


    1. NULL value to make the leaf terminal node
    2. Every indexed data value and a corresponding ROWID (Pg 225)
    3. Every indexed data value and pointer to next level block
    4. Every indexed data value and pointer to root block


    1. Waterfall is a/an ______ model


    1. Iterative
    2. Simple linear sequential (Pg 284)
    3. Object Oriented
    4. Rapid development


    1. In ___________ phase of kimball's approach, we identify the components needed now and in future.


    1. Project Planning
    2. Requirements Definition (Pg 294)
    3. Technical Architecture Design
    4. Maintenance & Growth


    1. Bill Inmon argues that requirements are well understood only after


    1. They are documented
    2. They extracted and verified
    3. Data warehouse is populated (Pg 285)
    4. All schemes are defined


    1. In ________learning you don’t know the number of clusters and no idea about their attributes.


    1. Supervised learning
    2. Un-Supervised learning (Pg 269)
    3. Multi Dimension modeling
    4. None of the given options


    1. Horizontally wide data means:


    1. Dataset has large no. of attributes
    2. Dataset has large no. of records
    3. Dataset has attribute skews
    4. Dataset has partitioning skews


    1. Normally the term “DWH face to the business user” refers to:
    2. Lifecycle Technology Track
    3. Lifecycle Data Track
    4. Lifecycle Analytical Applications track (Pg 306)
    5. Lifecycle Maintenance Track


    1. A top down implementation approach is useful when:


    1. Technology is mature and well understood (Pg 283)
    2. Organization cannot implement latest technologies
    3. Business objectives are unclear
    4. Problem to be solved are not well documented




Students having same subject can start discussion here to solve assignment, GDB & Quiz and can clear their concepts until solution is provided. 

You can search the Past CS614 Solved Quiz Mega Files From below link 

Click Here to Search (Looking For something at

1.In context of data parallelism, the work done by query processor should be
Ans Maximum

2.Goal driven approach of data warehouse development was result of ______ work
Ans: Böhnlein and Ulbrich-vom

3.A top down implementation approach is useful when
Ans: Technology is mature and well understood 

4. What means What”. The phrase refers to: Select correct option:
Ans: Meta data

5. Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development?
Ans: Not being an accommodating person

6. In context of requirement definition phase of Kimball’s DWH development approach, ________ is positioned as a findings review and prioritization meeting.

Ans: Requirements wrap-up presentation

7.Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development?
Ans: Not being an accommodating person

8.Horizontally wide data means:
Ans: Dataset has large no. of attributes

9.In contrast to statistics, data mining is ______ driven.
Ans: Knowledge

10.In nested-loop join case, if there are ‘M’ rows in outer table and ‘N’ rows in inner table, time complexity is

Ans: O (MN)
           BEST OF LUCK


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

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