CS614 Midterm Past Paper

You have come here while searching for CS614 midterm past papers. But before going to download the CS614 midterm past paper. I have a better option for you. That is, that you can attempt the online quiz of CS614.

Practice Quiz from CS614 Midterm Past Paper

This quiz will evaluate your preparation for the CS614 midterm examination and it is based on the past papers of CS614. The purpose of this quiz is to evaluate your performance in this subject. If you can pass this quiz, then there is a great chance that you can secure good marks in your exams.

0 votes, 0 avg

Your Time starts now

Times Up

Created on January 15, 2022 By

faisal_faisi

CS614

CS614 Midterm Past Papers Practice Quiz

Welcome to CS614 Midterm Online Practice Quiz.

You can check your preparation of CS614 for your Exams here.

Questions Will be different every time you will attempt.

1 / 30

Category: CS614-mid

For large record spaces and large number of records, the run time of the clustering algorithms is

a. Prohibitive

b. Exponential

c. Numerical

d. Static

2 / 30

Category: CS614-mid

Assume a company with a multi million row customer table i.e. n rows. Checking for referential integrity (RI) using a naive approach would takes

a. O(log n)

b. None of the given

c. O(1)

d. O(n)

3 / 30

Category: CS614-mid

Which is not an issue of ROLAP in the following?

a. Non slandered conventions

b. Maintenance

c. Aggregations pitfalls

d. Slandered hierarchy of dimensions

4 / 30

Category: CS614-mid

OLTP implementations are fully .

a. Demoralized

b. Additive

c. Normalized

d. Predictive

5 / 30

Category: CS614-mid

The min operator is conservative in that it assign to the dimension an aggregate value on higher than the value of its weakest data quality.

a. Min

b. None of give

c. Max

d. Min and max

6 / 30

Category: CS614-mid

In context of data mining definition, the term "value" means

a. Importance of hidden patterns discovered

b. Numerical of string measure assigned to an attribute

c. Index location of the record

d. The primary key of table

7 / 30

Category: CS614-mid

In data mining, initially you what you are looking for. Know

a. May or may not know

b. know

c. Don't Know

d. None of the given options

8 / 30

Category: CS614-mid

Identify data warehouse query from the following

a. Total number of students that have 3.5 CGPA

b. Factors which can affect student performance

c. Number of students studding CS614 Course

d. List of students belong to Lahore City

9 / 30

Category: CS614-mid

Which of the following is NOT one of the activities of “Maintenance and Growth” phase in Kimball’s DWH development approach?

a. Interface Deployment

b. Program Support

c. Technical education

d. Education

10 / 30

Category: CS614-mid

Which of the following is NOT one of the advantages of changed data capture (CDC) technique.

a. Extraction of Change Data occurs immediately

b. No incremental online I/O required for log tape

c. Flat Files are not required.

d. Limited Query interface is required for data extraction

11 / 30

Category: CS614-mid

Improper documentation results the problem(s) like:

a. New developers unable to configure already existing code

b. Maintenance issue

c. Lot of time required for enhancing the code

d. All of the given options

12 / 30

Category: CS614-mid

We should follow a proper cycle to implement a change even if it is smaller one.

a. Development -> QA -> Production

b. Development -> Production -> QA Production-

c. Development -> QA

d. Production -> QA ->Development

13 / 30

Category: CS614-mid

In case of multiple sources for the same data element, we need to prioritize the source systems per element bases, the process is called:

a. Prioritization

b. Measurement Selection

c. Element Selection

d. Ranking

14 / 30

Category: CS614-mid

In contrast to data mining, statistics is driven.

a. Knowledge

b. Database

c. human

d. Assumption

15 / 30

Category: CS614-mid

Which of the following is not a task of Data Transformation?

a. Conversion

b. Enrichment

c. Full Data Refresh

d. Summarization

16 / 30

Category: CS614-mid

Normally it is recommended to have

a. All of the given options

b. Interference while having different database environments on a single server

c. Different servers for development and production environment

d. Same server for development and production environment

17 / 30

Category: CS614-mid

Waterfall model is appropriate when

a. When resources are limited

b. When the deadline is strict

c. Requirements are clearly defined

d. When budget is low

18 / 30

Category: CS614-mid

Technical architecture design supports the communication about technical requirements: I) within the team II) Upward to management III) Outward to vendors

a. only (II)

b. (I), (II) and (III)

c. only (I)

d. only (III)

19 / 30

Category: CS614-mid

In phase of kimballs approach, we identify the components needed now and in future.

a. Product development

b. Architectural design

c. Requirement definition

d. Analytical application development

20 / 30

Category: CS614-mid

Three parallel tracks in kimbal’s DWH development approach converge at Phase

a. Business requirement definition

b. Project planning

c. Maintenance and growth

d. Deployment

21 / 30

Category: CS614-mid

most common use of range partitioning is on

a. Date

b. Color

c. phoneNo

d. Name

22 / 30

Category: CS614-mid

Grain of a fact table means:

a. Summary of aggregates in all fact tables

b. Summary of aggregates in all dimension tables

c. The meaning of one dimensional table row

d. The meaning of one fact table row

23 / 30

Category: CS614-mid

Which of the following activity/activities is/are part of project planning phase in Kimballs DWH development approach?

a. All of the given options

b. Assess organization's readiness for a data warehouse initiative

c. Obtain resources

d. Establish the preliminary scope and justification

24 / 30

Category: CS614-mid

Flat files are one of the prevalent structures used in data extraction.

a. Incremental

b. Online

c. Full

d. Offline

25 / 30

Category: CS614-mid

One of the drawbacks of waterfall model is that:

a. Customers can not review the product during development

b. It does not define the project timeline/schedule

c. All of the given options

d. It does not work when the resources are limited

26 / 30

Category: CS614-mid

Normally the term "DWH face to the business user" refers to:

a. Lifecycles technology track

b. Lifecycle Analytical Applications track

c. Lifecycle Maintenance track

d. Lifecycle Data track

27 / 30

Category: CS614-mid

Bill Inmon argues that requirements are well understood only after

a. They extracted and verified

b. Data warehouse is populated

c. All schemes are defined

d. They are documented

28 / 30

Category: CS614-mid

A relation is said to be in first normal for (1NF) if it does not contain .

a. Single value column

b. Derived Column

c. Multivalve column

d. Composite Column

29 / 30

Category: CS614-mid

A bottom up implementation approach is useful when

a. Technology is matured and well understands

b. The business objectives are very much clear

c. Organizationcannot implement latest technologies

d. All requirements are well documented

30 / 30

Category: CS614-mid

Suppose in system A, the possible values of “marital status” attribute were “Male” & “Female”, however in data warehouse, the values stored were “M” for male and “F” for female. The above scenario is an example of:

a. Many-to-one element transformation

b. One-to-many element transformation

c. Many-to-Many element transformation

d. One-to-One scalar transformation

Your score is

The average score is 0%

Exit

Note before downloading CS614 midterm past paper

One thing to note dear fellows that you must don’t rely on these papers only. They can be a source of help but not an ultimate solution. If you want to get good marks in your exams you are advised to go through all of your handouts and must watch all of the video lectures.

Golden rules for good marks in VU Exams.

As per my experience, I have developed some golden rules for getting good marks in Virtual University Exams based on experience. I got 3.96 CGPA by following these rules. So here they are:

Never miss your Quiz, Assignment, or GDB.
Always try to do your Assignment on your own.
Try your best to finish your video lectures 10 days before exams.
Try your best to read your handouts twice before exams.
Read forward attempt backward.
Never schedule more than one paper on the same day.
Your most difficult paper should have a gap of 1 or more days.
Toughest paper must be scheduled first.
Read questions forward and attempt backward.
Don’t waste your time during a paper on illegal activities.

You can also download the Latest VU Handouts

To download the CS614 midterm past paper click here.

CS614 Midterm Past Paper online Practice Quiz

CS614 Midterm Past Paper

Practice Quiz from CS614 Midterm Past Paper

Note before downloading CS614 midterm past paper

Golden rules for good marks in VU Exams.

Leave a Comment Cancel Reply