Database Management System — Winter 2021

Answer the following questions. 1. What do you mean by checkpoint? What is its use? 2. Define authentication and authorization. 3. Write about transaction and transaction failure. 4. What is the importance of Audit trail? 01

What is Query Processing? Also explain the steps of it. Illustrate with diagram.

What is Serializability? Explain conflict serializability in detail with example.

Explain materialized view and types of view maintenance.

Define transaction. Write the ACID properties. Describe the state diagram of a transaction.

What are the types of lock? Explain two-phase locking protocol in detail.

Briefly explain phantom phenomenon.

What is deadlock? Write about deadlock detection and recovery.

Explain Recoverable schedule and Cascadeless schedule by giving appropriate examples.

Explain Deferred update and Immediate update techniques.

Explain the concept of shadow paging in detail.

State and explain the types of database failures.

Describe the concept of mandatory access control.

What is database security? What are various threats and issues to database security? Explain.

Discuss OODM. Compare it with E-R Model.

What is Data Encryption? Discuss the various Encryption schemes used in Database security.

Define distributed database. Describe the properties and functions of it. Name different types of distributed databases.