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

Roll No.
Total No. of Pages : 02
Total No. of Questions : 18
B.T ech (IT ) (Sem.?5)
DATABASE MANAGEMENT SYSTEMS
Subject Code : BTIT-502-18
M.Code : 78257
Time : 3 Hrs. Max. Marks : 60
INST RUCT ION TO CANDIDAT ES :
1 .
SECT ION-A is COMPULSORY cons is ting of TEN questions carrying TWO marks
each.
2 .
SECT ION-B c ontains F IVE questions c arrying FIVE marks eac h and s tud ents
have to atte mpt any FOUR q ues tions.
3 .
SECT ION-C contains THREE questions carrying T EN marks e ach and s tudents
have to atte mpt any T WO questio ns.
SECTION-A
Answer briefly :
1)
What is data independence? What are its types?
2)
Write various data manipulation operations that can be performed data.
3)
Differentiate between char and varchar2 data types in oracle.
4)
What is Transitive Dependency?
5)
What is difference between primary index and secondary index?
6)
What is a checkpoint in DBMS?
7)
What is a transaction?
8)
Why security is required in DBMS?
9)
What are Web databases?
10) What are advantages of OODBMS?
1 | M-78257
(S2)-68

---

SECTION-B
11) What is ER Diagram? What are the symbols used in it? Design and Draw an ER diagram
for a banking system.
12) What is the difference between relational algebra and relational calculus?
13) Discuss the Shadow Paging Recovery Technique. Under what circumstances does it not
require a log?
14) How can you manage access control to different data in database?
15) Explain distributed database with its advantages.
SECTION-C
16) What is normalization? Why do we need to normalize our database? Explain various
normal forms by taking proper example.
17) What is Hashing? How Hash Codes Work? Explain with Examples.
18) 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.
2 | M-78257
(S2)-68

---