FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE

📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

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

This post was last modified on 21 March 2020

This download link is referred from the post: PTU B.Tech Question Papers 2020 March (All Branches)


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?
  5. --- Content provided by FirstRanker.com ---

  6. Give function of Joins?
  7. What is DML?
  8. Discuss different keys?
  9. Define the database security?
  10. What are views in SQL?
  11. --- Content provided by FirstRanker.com ---

  12. Define granularity in database?

SECTION-B

  1. Describe different types of databases and database languages?
  2. Write the importance of ER diagram by taking a suitable example?
  3. What are uses of update statements in SQL? Give example?
  4. --- Content provided by FirstRanker.com ---

  5. Give the concept of second and third normal forms?
  6. What is shadow paging in database recovery technique?

SECTION-C

  1. What are data models in DBMS? Discuss the uses of Data Base Management System?
  2. What is Relational Algebra? Explain various operators used in relational algebra?
  3. --- Content provided by FirstRanker.com ---

  4. 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.



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

This download link is referred from the post: PTU B.Tech Question Papers 2020 March (All Branches)