Download PTU (I.K.Gujral Punjab Technical University (IKGPTU)) B-Tech (Bachelor of Technology) (CSE-IT)- Computer Science Engineering -Information Technology 2020 December 5th Sem 70596 Database Management System Previous Question Paper
Total No. of Pages : 02
Total No. of Questions : 18
B.Tech. (IT) (2012 to 2017) (Sem.?5)
DATABASE MANAGEMENT SYSTEM
Subject Code : BTIT-503
M.Code : 70596
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 Physical and logical data Independence of DBMS?
2.
What is SQL Dependency?
3.
Compare hierarchical model with relational model?
4.
Explain 2nd and 3rd normal forms?
5.
What are report generators?
6.
Give syntax of JDBC?
7.
Write the use of XML?
8.
What is XQuery?
9.
What is the use of NoSQL database?
10. What is transaction management in SQL?
1 | M-70596
(S2)-967
SECTION-B
11.
Write a short note on distributed processing and client server architecture.
12.
Define relational algebra. Explain the various operations of relational algebra.
13.
What do you mean by Distributed databases? What are the policies used in distributed
databases?
14.
Give the introduction of relational query optimisation.
15.
Explain the various schemas that can be used for the construction of data warehouse.
SECTION-C
16.
What are logical data model and physical model? Discuss physical data Modeling
Techniques?
17.
What are nested elements in XML? What are the benefits of XML? Explain.
18.
Discuss how Online Analytical Processing (OLAP) is used to organize large business
databases?
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-70596
(S2)-967
This post was last modified on 13 February 2021