This download link is referred from the post: PTU B.Tech Question Papers 2020 March (All Branches)
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 :
- SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.
- SECTION-B contains FIVE questions carrying FIVE marks each and students have to attempt any FOUR questions.
- 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 :
- Write advantages of DBMS?
- Discuss schemas and instances?
- What are records and files?
- Define entry sets?
- Give function of Joins?
- What is DML?
- Discuss different keys?
- Define the database security?
- What are views in SQL?
- Define granularity in database?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
SECTION-B
- Describe different types of databases and database languages?
- Write the importance of ER diagram by taking a suitable example?
- What are uses of update statements in SQL? Give example?
- Give the concept of second and third normal forms?
- What is shadow paging in database recovery technique?
--- Content provided by FirstRanker.com ---
SECTION-C
- What are data models in DBMS? Discuss the uses of Data Base Management System?
- What is Relational Algebra? Explain various operators used in relational algebra?
- What is transaction? Mention the desirable properties of a transaction? Discuss about transaction recovery techniques?
--- Content provided by FirstRanker.com ---
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.
--- Content provided by FirstRanker.com ---
This download link is referred from the post: PTU B.Tech Question Papers 2020 March (All Branches)