B.Tech. (IT) (2012 to 2017) (Sem.-5)
DATABASE MANAGEMENT SYSTEM
--- Content provided by FirstRanker.com ---
Subject Code : BTIT-503
M.Code : 70596
Time : 3 Hrs. Max. Marks : 60
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.
--- Content provided by FirstRanker.com ---
SECTION-A
Answer briefly :
- What is Physical and logical data Independence of DBMS?
- What is SQL Dependency?
- Compare hierarchical model with relational model?
- Explain 2nd and 3rd normal forms?
- What are report generators?
- Give syntax of JDBC?
- Write the use of XML?
- What is XQuery?
- What is the use of NoSQL database?
- What is transaction management in SQL?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
SECTION-B
--- Content provided by FirstRanker.com ---
- Write a short note on distributed processing and client server architecture.
- Define relational algebra. Explain the various operations of relational algebra.
- What do you mean by Distributed databases? What are the policies used in distributed databases?
- Give the introduction of relational query optimisation.
- Explain the various schemas that can be used for the construction of data warehouse.
--- Content provided by FirstRanker.com ---
SECTION-C
- What are logical data model and physical model? Discuss physical data Modeling Techniques?
- What are nested elements in XML? What are the benefits of XML? Explain.
- 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.
--- Content provided by FirstRanker.com ---
This download link is referred from the post: PTU B.Tech Question Papers 2020 December (All Branches)
--- Content provided by FirstRanker.com ---