Download PTU B.Tech 2020 March CSE-IT 5th Sem BTIT 503 Database Management System Question Paper

FirstRanker.com
Firstranker's choice
FirstRanker.com

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

Roll No. ‘ ‘ ‘ ‘ H‘ ‘ ‘ H ‘ Total No. of Pages : 02
Total No. of Questions : 09
B.Tech. (IT) (2012 to 2017) (Sem.-5)
DATABASE MANAGEMENT SYSTEM
Subject Code : BTIT-503

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

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

3. SECTION-C contains THREE questions carrying TEN marks each and students have to attempt any TWO questions.

SECTION-A

1. Answer briefly :
   1. What do you mean by a Data Base instance and a Data Base schema?
   2. Differentiate between Strong and Weak entity sets. How are they represented in an E-R Diagram?
   3. What is DML in SQL? List the different DML commands used in SQL.

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

   4. What are NoSQL databases?
   5. Explain the Cartesian Product operation in Relational Algebra.
   6. Differentiate between char and varchar2 data types in oracle.
   7. What do you mean by integrity of data? List any two integrity constraints.
   8. What is Locking?

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

   9. What is an Applet?
   10. What are Object-Relational Databases?

FirstRanker.com

FirstRanker.com

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

SECTION-B

1. What is Relational Model? Discuss various features of Relational Model.
2. List various advantages of Data Base approach over Traditional File system approach.

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

3. Explain the different set operations used in SQL.
4. What are Multimedia Databases? How data is stored and indexed in Multimedia Databases?
5. What are Data Warehouses? Explain the meaning of Extraction, Transformation and Load in perspective of Data warehouses.

SECTION-C

1. Explain XML with the help of an example.

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

2. What do you mean by Normalization? Explain the first three normal forms along with BCNF and the anomalies that exist in these normal forms with the help of suitable examples.
3. What is meant by concurrent execution of Database Transactions in a multi user system? Discuss the different problems that can occur due to concurrent execution of transactions. Explain with the help of an example of the terms - Serial Schedule and Serializable Schedule.

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