Database Management System Important Questions – DMS Imp Qusts

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

1. List the advantages of DBMS?
2. List the database Applications?
3. Define instances and schemas of database?

For more questions please download the above Pdf file

UNIT – II

1. Define relational database query?
2. State about SELECT operation in Relational algebra?
3. State about PROJECT operation in Relational algebra?

For more questions please download the above Pdf file

UNIT – III

1. Define redundancy?
2. Define functional dependency? Why are some functional dependencies trivial?
3. 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