Database Management System — Summer 2022

Explain the following terms: 1. Relational Database 2. Transaction failure 3. Encryption 4. Atomicity 5. Distributed Database 6. Rollback 7. Deadlock

What is query processing? Explain Evaluation plans in detail

Explain Shadow Paging concept for transactions in detail?

Write ACID property for transaction management

Discuss Types of Lock and deadlock concept.

Discuss any six transformation rules for query optimization and also discuss steps of Heuristic Optimization algorithm.

Explain serializability.

Explain Deadlock Prevention Techniques like Wait-Die, Wound-Wait

Explain two-phase locking protocol with its advantages

Explain grant and revoke privileges with example for discretionary access control.

Explain differed database modification and immediate database modification 0 and list difference between them.

Explain Forward recovery, Backward recovery, Media recovery in detail.

Discuss various threats to database security.

What is database security? explain firewall in detail

Explain types of failures occur in database in detail.

Give difference between Parallel Database and Distributed Database.

Explain Statistical Database Security in detail.