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 2021 Jan IT 5th Sem 78257 Database Management Systems Question Paper

Download PTU (Punjab Technical University) B.Tech (Bachelor of Technology) / BE (Bachelor of Engineering) 2021 January IT 5th Sem 78257 Database Management Systems Previous Question Paper

This post was last modified on 26 June 2021

This download link is referred from the post: PTU B.Tech 5th Semester Last 10 Years 2011-2021 Previous Question Papers|| Punjab Technical University


FirstRanker.com

Roll No. Total No. of Pages : 02
Total No. of Questions : 18

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

B.Tech (IT) (Sem.-5)
DATABASE MANAGEMENT SYSTEMS
Subject Code : BTIT-502-18
M.Code : 78257
Time : 3 Hrs. Max. Marks : 60

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

INSTRUCTION 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 ---

Answer briefly :

  1. What is data independence? What are its types?
  2. Write various data manipulation operations that can be performed on data.
  3. Differentiate between char and varchar2 data-types in oracle.
  4. What is Transitive Dependency?
  5. --- Content provided by FirstRanker.com ---

  6. What is difference between primary index and secondary index?
  7. What is a checkpoint in DBMS?
  8. What is a transaction?
  9. Why security is required in DBMS?
  10. What are Web databases?
  11. --- Content provided by FirstRanker.com ---

  12. What are advantages of OODBMS?

SECTION-B

  1. What is ER Diagram? What are the symbols used in it? Design and Draw an ER diagram for a banking system.
  2. What is the difference between relational algebra and relational calculus?
  3. Discuss the Shadow Paging Recovery Technique. Under what circumstances does it not require a log?
  4. --- Content provided by FirstRanker.com ---

  5. How can you manage access control to different data in database?
  6. Explain distributed database with its advantages.

SECTION-C

  1. What is normalization? Why do we need to normalize our database? Explain various normal forms by taking proper example.
  2. What is Hashing? How Hash Codes Work? Explain with Examples.
  3. --- Content provided by FirstRanker.com ---

  4. Discuss various concurrency control technique.

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


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


This download link is referred from the post: PTU B.Tech 5th Semester Last 10 Years 2011-2021 Previous Question Papers|| Punjab Technical University