DBMS Important Questions PDF

UNIT - 3 1. Define schema refinement in database design. 2. Given a relation in 1NF, convert it to 2NF by identifying and eliminating partial dependencies. 3. State the advantages of normalization in database design. 4. Identify and remove transitive dependencies from a given schema. 5....

UNIT - 3 1. Define schema refinement in database design. 2. Given a relation in 1NF, convert it to 2NF by identifying and eliminating partial dependencies. 3. State the advantages of normalization in database design. 4. Identify and remove transitive dependencies from a given schema. 5. Define schema refinement in the context of database design. 6. Design a relational schema for a university database and apply BCNF normalization. 7. Use schema refinement techniques to eliminate insertion anomalies in a customer database. 8. Differentiate between fully functional dependency and partial functional dependency. 9. Demonstrate how to eliminate multi-valued dependencies in a relation. 10. Explain the difference between partial dependency and transitive dependency in database normalization. 11. Apply 5NF decomposition to a relation with join dependencies. 12. Compare 2NF and 3NF using examples. 13. Demonstrate how to eliminate join dependencies in a relation. 14. Explain the significance of 5NF (Fifth Normal Form) and how it resolves the problem of join dependency. 15. Critically analyze the advantages of the Boyce-Codd Normal Form (BCNF) compared to 3NF. UNIT - 4 1. Explain how the ARIES protocol helps in recovering a database to a consistent state after a crash. 2. Describe the differences between serial execution and concurrent execution of transactions 3. Define the Write-Ahead Log Protocol (WAL). What is the key rule it enforces? 4. Differentiate between serial and serializable schedules. 5. Discuss the key differences between undo and redo operations in the context of the ARIES recovery method. 6. What is the role of Concurrency Control in maintaining data consistency? 7. Explain the concept of CONFLICT serializability in detail with a suitable example 8. Explain how the Two-Phase Locking Protocol works to ensure transaction consistency. 9. How do deadlocks occur in concurrent transactions? 10. How does the Multi-version Concurrency Control work? What are its advantages? 11. Discuss the concept of Timestamp Ordering and how it ensures serializability. 12. What is the purpose of Graph-Based Protocols in concurrency control? 13. Describe the Validation-Based Concurrency Control Protocol and how it handles conflicts. 14. Describe the Multiple Granularity locking Concurrency Control Protocol 15. Explain the concept of VIEW serializability in detail with a suitable example