Download PTU B.Tech 2020 March CSE-IT 5th Sem CS 305 Database Management System Question Paper

Download PTU (I.K. Gujral Punjab Technical University Jalandhar (IKGPTU) ) BE/BTech CSE/IT (Computer Science And Engineering/ Information Technology) 2020 March 5th Sem CS 305 Database Management System Previous Question Paper

1 | M-2713 (S2)-2713
Roll No. Total No. of Pages : 02
Total No. of Questions : 18
B.Tech. (CSE) (Sem.?5)
DATABASE MANAGEMENT SYSTEM
Subject Code : CS-305
M.Code : 56525
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 DBMS?
2) Discuss schemas and instances?
3) What are records and files?
4) Define entry sets?
5) Give function of Joins?
6) What is DML?
7) Discuss different keys?
8) Define the database security?
9) What are views in SQL?
10) Define granularity in database?

FirstRanker.com - FirstRanker's Choice
1 | M-2713 (S2)-2713
Roll No. Total No. of Pages : 02
Total No. of Questions : 18
B.Tech. (CSE) (Sem.?5)
DATABASE MANAGEMENT SYSTEM
Subject Code : CS-305
M.Code : 56525
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 DBMS?
2) Discuss schemas and instances?
3) What are records and files?
4) Define entry sets?
5) Give function of Joins?
6) What is DML?
7) Discuss different keys?
8) Define the database security?
9) What are views in SQL?
10) Define granularity in database?

2 | M-2713 (S2)-2713
SECTION-B
11) Describe different types of databases and database languages?
12) Write the importance of ER diagram by taking a suitable example?
13) What are uses of update statements in SQL? Give example?
14) Give the concept of second and third normal forms?
15) What is shadow paging in database recovery technique?

SECTION-C
16) What are data models in DBMS? Discuss the uses of Data Base Management System?
17) What is Relational Algebra? Explain various operators used in relational algebra?
18) What is transaction? Mention the desirable properties of a transaction? Discuss about
transaction recovery techniques?








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