PTU B.Tech CSE 6th Semester May 2019 71108 RDBMS II Question Papers

Roll No.

Total No. of Pages : 02

Total No. of Questions : 18

--- Content provided by​ FirstRanker.com ---

B.Tech.(CSE)(2011 Onwards) (Sem.-6)

RDBMS-II

Subject Code : BTCS-602

M.Code: 71108

Time: 3 Hrs.

--- Content provided by⁠ FirstRanker.com ---

Max. Marks : 60

INSTRUCTIONS TO CANDIDATES :

1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.
2. SECTION-B contains FIVE questions carrying FIVE marks each and students have to attempt any FOUR questions.
3. SECTION-C contains THREE questions carrying TEN marks each and students have to attempt any TWO questions.

--- Content provided by FirstRanker.com ---

SECTION-A

1. What are the four important properties of transaction that a DBMS must ensure to maintain database?
2. Discuss the two phase locking protocol.
3. Compare OLTP and OLAP systems.
4. Distinguish between ORDBMS and OODBMS.

--- Content provided by​ FirstRanker.com ---

5. What is data mart? How it differs from a data warehouse?
6. What do you mean by database independence? Discuss its types.
7. What is normalization? Discuss 1NF.
8. What do you mean by big data? Write its main properties.
9. Discuss types of database failure.

--- Content provided by​ FirstRanker.com ---

10. What do you mean by query optimization? Discuss.

SECTION-B

11. Compare DDL, DML and DCL. Give two examples of each.
12. What is a timestamp? How does the system generate timestamps? Discuss the timestamp ordering protocol for concurrency control.
13. What is Data Mining? Discuss different phases in the data mining process.

--- Content provided by​ FirstRanker.com ---

14. Explain the architecture of a data warehouse with the help of a diagram.
15. Explain the steps involved in query processing.

SECTION-C

16. Explain various recovery techniques in detail.
17. What is Normalization? Explain in detail different forms of normalization with suitable example.

--- Content provided by‍ FirstRanker.com ---

18. Explain the architecture of a distributed database system with the help of a diagram. Write advantages and disadvantages of Distributed databases in comparison to centralized database.

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.

Get Previous Years Question Papers From: FirstRanker.com