CS2255 DBMS DATABASE MANAGEMENT SYSTEM IMPORTANT QUESTIONS

CS2255 DBMS DATABASE MANAGEMENT SYSTEM IMPORTANT QUESTIONS

Regulation 2008

Common for 4th semester IT and CSE

Unit-1
1. Explain DBMS System Architecture. (16)
2. Explain E-R Model in detail with suitable example. (16)
3. Explain about various data models. (16)
4. Draw an E – R Diagram for Banking, University, Company, Airlines, ATM Hospital, Library, Super market, Insurance Company. (16)
5. Explain in details about the various database languages. (16)
6 a) Discuss about various operations in Relational Databases. (08)
b) Discuss about database users and administrators.

Unit-2
1. Discuss about various operations in Relational algebra (Fundamental operations – Additional operations). (16)
2. Disuss in detail about an Integrity, Triggers and Security. (16)
3. a) Explain Embedded and Dynamic SQL. (08)
b) Explain String Operations and Aggregate functions used in SQL. (08)
4. a) Explain detail in domain relational calculus. (08)
b) Explain detail in Tuple relational calculus. (08)
5. Explain detail in distributed databases and client/server databases. (16)

Unit-3

1. Explain detail about Functional Dependencies. (16) 

2. Explain detail about first, second and third normalization form. (16) 

3. Explain detail about Boyce code normal form and fifth normalization form. (16) 

4. Explain detail in decomposition using Functional Dependencies. (16) 

5. Explain detail in decomposition using Multi-Valued Dependencies. (16) 

Unit-4

1. Define Serializability. Explain the types of serializability with example. (16) 

2. Explain Deadlock with example. (16) 

3. Explain in detail about Locking Protocol. (16) 

4. a) Explain the Need for Concurrency Control. (08) 

     b) Discuss about transaction recoverability. (08) 

5. Explain Recovery isolation levels with example. (16) 

6. Explain in detail about ACID properties. 

Unit-5

1. Explain various hashing techniques. (16) 

2. Explain RAID. (16) 

3. Explain the steps in Query processing. (16) 

4. Explain B+ Tree and B-tree. (16) 

5. a) Explain the types of File Organization. (08) 

   b) Explain some basic algorithms used in selection operation, Sorting and Join operation. (08) 

6. Explain physical storage media with example. 

---

April/May 2010 Question paper --> Click Here

---