Download PTU B.Tech 2020 March CSE-IT 6th Sem BTCS 602 Rdbms Ii Question Paper

Download PTU (I.K. Gujral Punjab Technical University Jalandhar (IKGPTU) ) BE/BTech CSE/IT (Computer Science And Engineering/ Information Technology) 2020 March 6th Sem BTCS 602 Rdbms Ii Previous Question Paper

1 | M-71108 (S2)-1793
Roll No. Total No. of Pages : 02
Total No. of Questions : 18
B.Tech. (CSE) (2012 to 2017) (Sem.?6)
RDBMS-II
Subject Code : BTCS-602
M.Code : 71108
Time : 3 Hrs. 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.

SECTION-A
Write briefly :
1. Write advantages of databases over file oriented system.
2. What do you mean by validation?
3. What is the role of replication in distributed database system?
4. What is 4NF?
5. What do you mean by DDL?
6. What are the features of mySQL?
7. Describe shadow paging.
8. Discuss the various components of DBMS environment and how do they relate to each
other.
9. What is OLTP?
10. What is data mining?
FirstRanker.com - FirstRanker's Choice
1 | M-71108 (S2)-1793
Roll No. Total No. of Pages : 02
Total No. of Questions : 18
B.Tech. (CSE) (2012 to 2017) (Sem.?6)
RDBMS-II
Subject Code : BTCS-602
M.Code : 71108
Time : 3 Hrs. 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.

SECTION-A
Write briefly :
1. Write advantages of databases over file oriented system.
2. What do you mean by validation?
3. What is the role of replication in distributed database system?
4. What is 4NF?
5. What do you mean by DDL?
6. What are the features of mySQL?
7. Describe shadow paging.
8. Discuss the various components of DBMS environment and how do they relate to each
other.
9. What is OLTP?
10. What is data mining?
2 | M-71108 (S2)-1793
SECTION-B
11. What do you understand by transaction? What are the properties of transactions?
12. How is cost estimated in query optimization?
13. Compare OOD and ORD.
14. What are the advantages and disadvantages of distributed database systems?
15. What is the two-phase locking protocol? Explain with suitable example.

SECTION-C
16. What do you mean by normalization? Explain with a suitable example showing
normalization till 3NF.
17. Compare the Deferred update technique and immediate update recovery technique.
18. Describe the three schema architecture. How does the schema definition language support
this structure?









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.
FirstRanker.com - FirstRanker's Choice