This download link is referred from the post: PTU B.Tech 5th Semester Last 10 Years 2011-2021 Previous Question Papers|| Punjab Technical University
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 :
- 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 ---
Answer briefly :
- What is data independence? What are its types?
- Write various data manipulation operations that can be performed on data.
- Differentiate between char and varchar2 data-types in oracle.
- What is Transitive Dependency?
- What is difference between primary index and secondary index?
- What is a checkpoint in DBMS?
- What is a transaction?
- Why security is required in DBMS?
- What are Web databases?
- What are advantages of OODBMS?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
SECTION-B
- What is ER Diagram? What are the symbols used in it? Design and Draw an ER diagram for a banking system.
- What is the difference between relational algebra and relational calculus?
- Discuss the Shadow Paging Recovery Technique. Under what circumstances does it not require a log?
- How can you manage access control to different data in database?
- Explain distributed database with its advantages.
--- Content provided by FirstRanker.com ---
SECTION-C
- What is normalization? Why do we need to normalize our database? Explain various normal forms by taking proper example.
- What is Hashing? How Hash Codes Work? Explain with Examples.
- Discuss various concurrency control technique.
--- 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 5th Semester Last 10 Years 2011-2021 Previous Question Papers|| Punjab Technical University