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


+ Link For Assignments, GDBs & Online Quizzes Solution


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

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

CS614 ALL Current Final Term Papers Spring 2016 And Past Final Term Papers at One Place from 20 August 2016 to 2 September 2016

+ How to Follow the New Added Discussions at Your Mail Address?

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

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

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

See Your Saved Posts Timeline

Views: 7198


+ 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?)

+ Click Here To Join (Our facebook study Group)


Replies to This Discussion

ALL Current Final Term Papers Spring 2016 And Past Final Term Papers at One Place from 20 August 2016 to 2 September 2016


Share Your Current Mid Term Papers (Questions/Pattern) 20 August 2016 to 02 September2016  to help each other. Thanks


Solved Mid Terms Papers By MOAAZ & Other Students


Click On the below link to download


Solved Final Term Papers

Note: (This is Featured Discussion)

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.


.•°How to Download past papers from study groups°•.


All Questions was from Past Papers…..
 37 Mcqs was from Past paper + Quizzes

Subjective Totally from Past Papers

MCQS are:

The goal of ___________ is to look at as few blocks as possible to find the matching records(s).

Indexing (Right Answer)



None of above


The automated, prospective analyses offered by data mining move beyond the analysis of past events provided by respective tools typical of ___________.



Decision Support systems

None of these


Pre-computed _______ can solve performance problems





Data mining uses _________ algorithms to discover patterns and regularities in data.




None of these


To identify the __________________ required we need to perform data profiling Degree of Transformation (Right Answer)





Execution can be completed successfully or it may be stopped due to some error. If some error occurs, execution will be terminated abnormally and all transactions will be ___________ Committed to the database (Right Answer)

Rolled back


All data is ______________ of something real. I An Abstraction II A Representation Which of the following option is true?

I Only (Right Answer)

 II Only

 Both I & II

 None of I & II


For a DWH project, the key requirement are ________ and product experience.


Industry (Right Answer)


None of these


_________________ contributes to an under-utilization of valuable and expensive historical data, and inevitably results in a limited capability to provide decision support and analysis.

The lack of data integration and standardization (Right Answer)

Missing Data Data Stored in Heterogeneous Sources


DTS allows us to connect through any data source or destination that is supported by ____________ OLE DB (Right Answer)



 Data Warehouse


If some error occurs, execution will be terminated abnormally and all transactions will be rolled back. In this case when we will access the database we will find it in the state that was before the ____________. Execution of package (Right Answer)

 Creation of package

 Connection of package


To judge effectiveness we perform data profiling twice.

 One before Extraction and the other after Extraction

One before Transformation and the other after Transformation (Right Answer)

One before Loading and the other after Loading


Pre-computed _______ can solve performance problems

Aggregates (Right Answer)





De-Normalization normally speeds up ► Data Retrieval (Page 51)

► Data Modification

► Development Cycle

► Data Replication


For a given data set, to get a global view in un-supervised learning we use ► One-way Clustering (Page 271)

► Bi-clustering

► Pearson correlation

► Euclidean distance




_____________ is a process which involves gathering of information about column through execution of certain queries with intention to identify erroneous records.

► Data profiling (Page 439)

► Data Anomaly Detection

 ► Record Duplicate Detection

► None of these




The automated, prospective analyses offered by data mining move beyond the analyses of past events provided by retrospective tools typical of ______________ .



►Decision Support Systems Click here for detail

►None of these


It is called a _____________ violation, if we have null values for attributes where NOT NULL  constraint exists

  • Load
  • Transform
  • Constraint page 161
  • Extraction

UAT stands for

  • User acceptance testing page 193

The application development quality assurance activities  cannot be completed until the data is _____________

  • Stabilized page 308
  • Identified
  • Finalized
  • Computerized

Product selection phase fall in Kimball

  • Lifecycle Technology Track page 290
  • Lifecycle Data Track
  • Lifecycle Analytic Applications Track
  • None of the given

Which is not an issue of “Click stream data”.

  • Identifying the Visitor Origin
  • Identifying the Session
  • Identifying the Visitor
  • Identifying the server .


HTTP true statement

  • Is stateless page 364
  • Non world wide web protocol
  • Used to maintain session
  • Message routing protocol

The ith bit is set to 1, if ith row of the base table has the value for the indexed column. The statement refer to

  • Inverted
  • Bitmap page 233
  • Dense
  • Sparse index

In context of web data ware house. Which is NOT one of way to identify session

  • Using asynchronous session tracking protocol
  • Using Time-contiguous Log Entries
  • Using Transient Cookies
  • Using HTTP's secure sockets layer (SSL)
  • Using session ID Ping-pong
  • Using Persistent Cookies

The application development quality assurance activities cannot be completed until the data is


  • Stabilized page 308
  •  Identified
  •  Finalized
  •  Computerized

Others Mcqs from Midterm + 3, 4 was from Handouts but very easy ….



2 Marks Questions


There are four categories of data quality improvement. Write any two. (2 marks)


 The four categories of Data Quality Improvement

• Process

• System

• Policy & Procedure

• Data Design

Write two unsupervised learning?  2 marks


One way clustering

Two way clustering

Statement meaning “be a Diplomat not technologist “ 2 marks

Answer: The biggest problem you will face during a warehouse implementation will be people, not the technology or the development.

1. Management: You’re going to have senior management complaining about completion dates and unclear objectives.

2. Development Team: You’re going to have development people protesting that everything takes too long and why can’t they do it the old way?

3. Users: You’re going to have users with outrageously unrealistic expectations, who are used to systems that require mouse-clicking but not much intellectual investment on their part.

4. And you’re going to grow exhausted, separating out Needs from Wants at all levels. Commit from the outset to work very hard at communicating the realities, encouraging investment, and cultivating the development of new skills in your team and your users (and even your bosses).


Most of all, keep smiling. When all is said and done, you’ll have a resource in place that will do magic, and your grief will be long past. Eventually, your smile will be effortless and real.

Define click stream? 2marks


 Clickstream is every page event recorded by each of the company's Web servers

 Web-intensive businesses

 Although most exciting, at the same time it can be the most difficult and most frustrating.

 Not JUST another data source.



3 Marks Questions

As the number of processes increase, the speedup should also increase. Thus theoretically there should be a linear speedup; however this is not the case in real. List at least 2 barrier of linear speedup. 3 marks


  • Amdahl’ Law
  • Startup
  • Interference
  • Skew

Common Dimensions in context with Web data warehouse.  3marks

Answer: -------


Name of three DWH development methodologies? 3 marks


Development methodologies

 Waterfall model

Spiral model

 RAD Model

Structured Methodology

  • Data Driven
  • Goal Driven
  •  User Driven

One question was to identify statement is correct or not (was from Midterm) 3 marks

5 Marks Question:

Before sitting down with the business community to gather information, it is suggested to set you up for a productive session. Write three activities requirement preplanning phase 5 marks


Requirements preplanning: This phase consists of activities like choosing the forum,  identifying and preparing the requirements team and finally selecting, scheduling and preparing the business representatives.


This query was given SELECT*FROM R WHERE A= 5 and we have to tell which

Technique is appropriate from dense, sparse, B-tree and has indexing. 5 marks

Answer: Hash Indexing is appropriate for the given query, because hash indexing is good for matching queries.

According to Amdahl’s Law prove that the speedup does not remain same if the fraction of the problem and number of processors are doubled. Please note that 0 overhead and “perfect” parallelism is used. Use following examples  5 marks

a)      Fraction of the problem that must be computed sequentially is 5% and number of processors is 100.

b)      Fraction of the problem that must be computed sequentially is 10% and number of processors is 200.

Ans: REF (Handouts Page # 204,205)

Amdahl’s law: S ≤ 1 / f + ( 1 – f ) / N

a)      1 / 0.05 + ( 1 – 0.05 ) / 100 = 16.81

b)      1 / 0.10 + ( 1 – 0.10 ) / 100 = 9.57

Hence it is evident that the speedup does not remain same if we double the fraction and number of processors.


Attributes of Page Dimension:  5 marks

Answer: Page no : 362 Ch# 40

My CS-614 Paper:
1) Issues of Click stream
2) Lexical error
3) Limitation of HTTP
4) Name of Activities in DWH lifecycle
5) Issues of Data Acquisition cleansing n agriculture
6) Table of Bitmap index
7) Gender guidelines
8) Choose tha Data mining metrics
9) Agree with the statistic algorithm
10) statement is corrct/incorrect abut Orr's Law

boht boht sshukria wasifa n nazeer

please baki members b cs614 ka paper share krn ..God bless u all...

CS614 FinalTerm MCQs With Refrence Solved By Zain Nasar(Arslan Arshad)



Wasfa Baig (MIT 3rd)

all objective was from past papers...subjective was from last chapters

and some questions were from old subjectives papers e.g

Identify the given statement as correct or incorrect and justify your answer in either
“The problem of Referential Integrity always occurs in traditional OLTP system as
well as in DWH”. 3m

My today CS614 paper

45% paper from past papers

2 question asked correct or not..and explain reason? ek question m ye 2 statements thi(Orr's law statement )and (Inteligent learning organization share thier information.)

mostly question and MCQs of K-means algorithm.

Software architecture name btany thy 2 marks

In K-means algorithm O(tkn) what is t,k and n?

context dimention for web data ware house 2 marks ka tha

Data Parallelism

Data mining vs statistics btana tha

Requirements Definition ka short question tha

My current cs614 paper 2016

Q.What may be possible implications if the developing organization never freezes the requirements throughout the DWH development i.e. it always behaves like an accommodating person. 5

Write down any two drawbacks if “Date” is stored in text format rather than using proper date format like “dd-MMM-yy” etc. 5

There are different data mining techniques e.g. “clustering”, “description” etc. Each of the following statement corresponds to some data mining technique. For each statement name the technique the statement corresponds to. 5

a) Assigning customers to predefined customer segments (i.e. good vs. bad)

b) Assigning credit applicants to predefined classes (i.e. low, medium, or high risk)

c) Guessing how much customers will spend during next 6 months

d) Building a model and assigning a value from 0 to 1 to each member of the set. Then classifying the members into categories based on a threshold value.

e) Guessing how much students will score more than 65% grades in midterm.

There are two justifications for a task to be performed in parallel, either it manipulates significant amount of data (i.e. size) or it can be solved by divide and conquer (D&C) strategy. From the given list, provide the justification for each of the task to perform it in parallel. 5

a) Large table scans and joins

b) Creation of large indexes

c) Partitioned index scans

d) Bulk inserts, updates, and deletes

e) Aggregations and copying

What are the tasks performed through import / export data wizard to load data?Write any three 3

In context of Four Cell Quadrant Technique, which business process (from the diagram below) will have highest priority? Justify with reason. [Marks 3]

Consider the following two statements. Specify that each statement correspond to which activity of data quality analysis project. 3

a) Identify functional user data quality requirements and establish data quality metrics.

b) Measure conformance to current business rules and develop exception reports.

Identify the given statement as correct or incorrect and justify your answer in either case.

“Bayesian Modeling is an example of Unsupervised Learning”. 3

The problems associated with the extracted data can correspond to non-primary keys. List down any four problems associated with the non-primary key.5

What is Reverse Proxy?2

Why analytics track is called as the “fun part" while designing a data warehouse?2

List two main types of unsupervised learning.2


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

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