PTU Punjab Technical University B-Tech May 2019 Question Papers 6th Semester Computer Science Engineering (CSE)
Total No. of Pages : 02
Total No. of Questions : 18
B.Tech.(CSE)(2011 Onwards) (Sem.?6)
Subject Code : BTCS-602
M.Code : 71108
Time : 3 Hrs. Max. Marks : 60
INSTRUCTIONS TO CANDIDATES :
SECTION-A is COMPULSORY consisting of TEN questions carrying T WO marks
SECTION-B contains FIVE questions carrying FIVE marks each and students
have to attempt any FOUR questions.
SECTION-C contains T HREE questions carrying T EN marks each and students
have to attempt any T WO questions.
What are the four important properties of transaction that a DBMS must ensure to
Discuss the two phase locking protocol.
Compare OLTP and OLAP systems.
Distinguish between ORDBMS and OODBMS.
What is data mart? How it differs from a data warehouse?
What do you mean by database independence? Discuss its types.
What is normalization? Discuss 1NF.
What do you mean by big data? Write its main properties.
Discuss types of database failure.
What do you mean by query optimization? Discuss.
1 | M-71108
Compare DDL, DML and DCL. Give two examples of each.
What is a timestamp? How does the system generate timestamps? Discuss the timestamp
ordering protocol for concurrency control.
Q13 What is Data Mining? Discuss different phases in the data mining process.
Explain the architecture of a data warehouse with the help of a diagram.
Q15 Explain the steps involved in query processing.
Q16 Explain various recovery techniques in detail.
Q17 What is Normalization? Explain in detail different forms of normalization with suitable
Q18 Explain the architecture of a distributed database system with the help of a diagram.
Write advantages and disadvantages of Distributed databases in comparison to
NOTE : Disclosure of Identity by writing Mobile No. or Making of passing request on any
page of Answer Sheet will lead to UMC against the Student.
2 | M-71108
This post was last modified on 04 November 2019