Solved Exercises in DBMS

Solved exercises in DBMS / Solved exercises in all areas of DBMS / Solved exercises on ER Diagrams, Normalization, Query Processing, Transaction Processing, SQL, Relational algebra etc. / Solved exercises in DBMS with answers explained.

TOPICS

• Entity - Relationship Model (ER Model)

• Relational Algebra

• Multiple Choice Questions (MCQs) in Relational algebra

• SQL and RA short exercises 1

• Relational algebra - solved exercise 2 

• Normalization

• Normalization all exercises - Home page

• Closure Finding Exercises

• TRUE/FALSE Questions

• Boyce Codd Normal Form (BCNF) Examples

• Minimal cover (Canonical cover)

• Multiple Choice Questions (MCQs) in Normalization 

• Disk Storage and Access
• Multiple Choice Questions (MCQs) in Storage and access

• Find the number of blocks exercise  

• Find the required number of buffer pages in external sorting

• Find the memory required for external sorting 

• Transaction Processing

• Lost update problem exercise 1

• Given Schedule is conflict serializable or not - solved example 1  

• Given Schedule is conflict serializable or not - solved example 2

• Given schedule is conflict serializable or not - solved exercise 3 

• Given schedule is conflict serializable or not - solved exercise 4 

• Given schedule is recoverable serializable or not - solved exercise 

• Find the transaction isolation levels of the given schedules

• Conflict serializable schedule solved example

• Transaction schedule that is conflict serializable exercise

• Non-conflict serializable solved exercise

• View serializable exercise - Non-conflict serializable exercise

• Query Processing

• Find the cost of executing SQL queries  
  

• Find the IO cost for iteration join and merge join - exercise

************

Go to Normalization - Solved Exercises page

Go to Advanced DBMS Concepts page

 

Go to Multiple Choice Questions (MCQ) in DBMS home

List of solved exercises in RDBMS

Solved exercises in Entity relationship modeling

solved problems in relational algebra

solved exercises in normalization in dbms

solved exercises in disk access and memory management in DBMS

solved exercises in transaction processing in DBMS

solved exercises in query processing in RDBMS

Important exercises with answers in RDBMS

Top interview questions and exercises in RDBMS with solutions