KEMBAR78
DBMS Study Guide for Students | PDF | Relational Model | Relational Database
Scribd
Upload
2K views3 pages

DBMS Study Guide for Students

The document outlines important questions from 5 units of a Database Management Systems course. Unit 1 covers differences between file systems and DBMS, data modeling, and ER diagrams. Unit 2 introduces relational models, integrity constraints, and relational algebra. Unit 3 focuses on SQL queries, operations, and constraints. Unit 4 discusses transaction management, concurrency control, isolation levels, and recovery techniques. Unit 5 examines file organization, indexing methods, and comparing access structures.

Uploaded by

munugotisumanthrao
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2K views3 pages

DBMS Study Guide for Students

The document outlines important questions from 5 units of a Database Management Systems course. Unit 1 covers differences between file systems and DBMS, data modeling, and ER diagrams. Unit 2 introduces relational models, integrity constraints, and relational algebra. Unit 3 focuses on SQL queries, operations, and constraints. Unit 4 discusses transaction management, concurrency control, isolation levels, and recovery techniques. Unit 5 examines file organization, indexing methods, and comparing access structures.

Uploaded by

munugotisumanthrao
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

DATABASE MANAGEMENT SYSTEMS

UNIT WISE IMPORTANT QUESTIONS

UNIT 1

1. Explain the differences between file system and DBMS


2. What are the various models of DBMS?
3. Explain abstract levels of DBMS
4. Draw and explain the architecture of DBMS
5. Explain the ER model with its entities ,attributes and constraints
Or
Explain the features of ER model
6. Design the conceptual design model using ER diagram that satisfies the
following criteria
i) Binary Relationship Vs Ternary relationship
ii) Entity Vs Attributes
iii) Choosing weak and strong entity

UNIT 2

1. Explain the relational model with example


2. How to enforce integrity constraints in the relational model
3. Create your own relational database model with key and integrity
constraints
4. Describe views . Explain how to destroy a table/view
5. Explain basic operations of relational algebra
6. Differentiate between TRC and DRC with an example
7. Explain the rules of defining the formula in TRC
8. Explain the correlation between DRC and SQL

UNIT 3

1. Explain the basic form of SQL query with an example.


2. Explain the following:
i)Set operations of SQL
ii)Co -related nested queries
iii)Aggregate operations
3.Explain the following in SQL:
a)Union
b)Intersect
c)Except
d)Group by
e)Order by
4.Create a trigger in SQL on insert and delete commands
5.Explain primary and foreign constraints in SQL with examples.
6.Explain schema refinement in terms of data redundancy and decomposition.
7.Explain the reasoning about functional dependencies.
8.Explain 1st , 2nd , 3rd, 4th, 5th Normal forms and BCNF
9. Explain the following :
a) Properties of decomposition
b) Lossless join decomposition
c) Multivalued dependencies

UNIT 4
1. Explain states of transactions
Or
How do we implement atomicity or durability of transaction
2. Explain the properties of transaction
3. How do we control concurrent execution of transaction
4. Explain serializability/ Testing Serializability
5. How do we ensure isolation and atomicity of transaction
6. How do we implement isolation levels of transaction
7. Explain lock based protocols briefly
Or
Explain two phase locking
Or
How to prevent / detect / recover deadlock in transaction
8. Explain graph based protocol.
9. Explain multiple granularity
10. Explain timestamp based protocol
11. Explain validation based protocols
12. Explain types of failures (2M)
13. Explain Thoma’s rule (2M)
14. Explain types of storages (2M)
15. Explain remote backup (2M)
16. Explain fail stop assumption(2M)
17. Explain deadlock (2M)
18. Explain lock table (2M)
19. How to ensure atomicity while recovery from failure
Or
Explain recovery algorithms in concurrent transactions
20. Explain the following types of schedules
a. Serial schedule
b. Cascadeless schedule
c. Recoverable schedule
d. Serializable schedule

UNIT 5

1. How the data gets stored on external storage(2M)


2. Explain types of file organisation and indexing
3. Explain types of index data structures
4. Compare the file organisations
5. Explain types of tree indexing methods briefly
6. Explain types of hash based indexing

You might also like