Explain the following terms: 1. Relational Database 2. Transaction failure 3. Encryption 4. Atomicity 5. Distributed Database 6. Rollback 7. Deadlock
[7 marks]What is query processing? Explain Evaluation plans in detail
[7 marks]Explain Shadow Paging concept for transactions in detail?
[7 marks]Write ACID property for transaction management
[7 marks]Discuss Types of Lock and deadlock concept.
[7 marks]Discuss any six transformation rules for query optimization and also discuss steps of Heuristic Optimization algorithm.
[7 marks]Explain serializability.
[7 marks]Explain Deadlock Prevention Techniques like Wait-Die, Wound-Wait
[7 marks]Explain two-phase locking protocol with its advantages
[7 marks]Explain grant and revoke privileges with example for discretionary access control.
[7 marks]Explain differed database modification and immediate database modification 0 and list difference between them.
[7 marks]Explain Forward recovery, Backward recovery, Media recovery in detail.
[7 marks]Discuss various threats to database security.
[7 marks]What is database security? explain firewall in detail
[7 marks]Explain types of failures occur in database in detail.
[7 marks]Give difference between Parallel Database and Distributed Database.
[7 marks]Explain Statistical Database Security in detail.
[7 marks]