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

FirstRanker.com

Roll No. EEEEEEEE [ ] Total No. of Pages : 02
Total No. of Questions : 18

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

B.Tech. (CSE) (Sem.-5)

DATABASE MANAGEMENT SYSTEM
Subject Code : CS-305
M.Code : 56525

Time : 3 Hrs. Max. Marks : 60

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

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

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

Write briefly :

1. Write advantages of DBMS?
2. Discuss schemas and instances?
3. What are records and files?
4. Define entry sets?

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

5. Give function of Joins?
6. What is DML?
7. Discuss different keys?
8. Define the database security?
9. What are views in SQL?

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

10. Define granularity in database?

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?

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

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?

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

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.