CS614 Final Term Current Papers 2018-2020

CS614 Current Final Term Papers 2018 To 2020 2020

Paper 1

CS614 current paper | 10-09-2020

36 Mcqs from past ppr...

1. Saprse Index correct or incorrect statement...3
2. Kimball's Approach-name of three parallel Tracks...3
3. Identify Atleast two attributes that r performing horizontal partition...3
4. Identify All The entities from ERD...3
5. Indentify correct incorrect state-about DTS tools ...3
6. Writr the types Of Queries for which B-tree and hash index...5
7. Predict the un-known Gender of the person from table... 5
8. Selectivity of OLTP ANd DWH 5
9. Following is the Header (column names with description)of students table stored in Sql server...5
10. Data Warehouse agriculture sector identify ty static and dnyamic attributes from table... 5

Paper 2

Paper 3

CS614 current paper | 11-09-2020 | 05:00 PM

1-Planning phase of DHW development?

2- Five attribute of Webpage?

3- Characteristics of Data warehouse?

4Apply Run length encoding on the given input streams and mention the output stream? 5In context of Kimball’s approach for data warehouse development, name the three parallel tracks after “business requirement definition phase”? 6Identify and mention the name of quality Management Maturity? 7Cost of hash-join in Pakistan?

Paper 4

CS614 current paper | 13-09-2020 | 11:00 AM MCQs were from handouts and past papers. Past about 70%. Write any two Implementation strategies of data warehouse project. (3) What are the load tasks using import/export wizard. Write any 3 (3) Wisdom is the application of which two entities? (3) Write any two parallel software architectures. (3) Name three major approaches for accessing information stored on the web. (3) Write names of DTS items. (5) Four categories Data Quality improvement (5) Identify additive and non additive facts from given table (5) The example of join cost given in the handouts. Ditto copy (5) Some statements were given. We had to identify them as correct or wrong. (5)

2019

Paper 1

Done with cs614 paper 11 am

Paper 2

Done with cs614 Mcqs were 90% from arslan arshad file.. No idea about moaaz file bcz mne prhi ni wo. Subj. Ak statemnt thi sparce index ki identify krna tha correct or incorrect.

Q2. 5 statements were given and asked to identify supervised or un supervised learning

Q3. Scenario was given and asked that which should use for it.. SQL queries or manual checking

Q4. Three major ways of accessing web

Q5. Why web warehousing is needed three reasons

Ak table given tha SQL commands likhni thi Another table was given and asked to create a bitmap indexed table.