Database Management System Important Questions Pdf file – DMS Imp Qusts
Please find the attached pdf file of Database Management System Important Questions Bank – DMS Imp Qusts
Link – DWHM Question Bank
UNIT – I
- List the advantages of DBMS?
- List the database Applications?
- Define instances and schemas of database?
For more questions please download the above Pdf file
UNIT – II
- Define relational database query?
- State about SELECT operation in Relational algebra?
- State about PROJECT operation in Relational algebra?
For more questions please download the above Pdf file
UNIT – III
- Define redundancy?
- Define functional dependency? Why are some functional dependencies trivial?
- Discuss normalization?
For more questions please download the above Pdf file
UNIT – IV
1 Define a Transaction? List the properties of transaction?
2 Discuss different phases of transaction?
3 Discuss recoverable schedules?
For more questions please download the above Pdf file
UNIT – V
1 Discuss about data on External storage?
2 Explain Clustered Indexes?
3 Discuss the Primary and Secondary indexes?
For more questions please download the above Pdf file