Table of Contents
- What is transaction Concept?
- Explain the ACID property of transaction.
- What is Serializability?
- Explain the view Serializability.
- Discuss conflict Serializability.
- What is Recoverability?
- What are Schedules?
- What are differences between conflict serializability and view serializability ?
- What are cascadeless and recoverable schedules?
- Explain cascadeless schedules and cascading rollback.
- What is the system log used for? What is the typical kinds of records in a system log?
- What are transaction commit point and why are they important?
- What is log? How it is maintained?
- Discuss salient feature of deferred database modification and immediate database modification strategies in brief.
- Describe the shadow paging recovery technique. Under what circumstances does it not require a log?
- What is deadlock? When does it occur?
- How deadlock is detected in database system?
- How deadlock can be avoided? Discuss in detail.
- Discuss the procedure of deadlock detection and recovery in transaction.
- Explain the transaction wait-for graph.
- Define phantom deadlock and discuss a protocol for detection of a deadlock.
- Explain how detection of phantom deadlocks may be avoided.
- What is fragmentation of a relation? Describe the main types of fragmentation.
- Briefly explain the distributed database and outline the objectives of distributed database.
- What is meant by data allocation in distributed database design? Describe the criteria to allocate the database inits over the various sites.
- What is mixed fragmentation in distributed database design? Explain.
- Explain homogeneous and heterogeneous database reference to distributed database.
- Discuss the procedure of deadlock detection and recovery in transactions.
- What do you mean by Transparency?
- Explain in detail the various approaches used for storing a relation in distributed database.
What did you think?
Similar Reads
-
Aggregate function in SQL with Examples
In a Database Management System (DBMS), an aggregate function is a special tool that performs calculations on a set of… -
SQL and Parts of SQL language
SQL is a popular programming language, which is used to manage the relational databases and to perform various operations on… -
Views in Relational Algebra
In SQL, virtual table are considered as views. Like Tables, views also contain rows and columns. We can select the… -
Syntax of following SQL commands: sysdate, to date(), dual table ,to_number, substr() and initcap()
1. SYSDATE Purpose: SYSDATE is a function that returns the current date and time of the database server. Syntax SELECT… -
What is Super key, Candidate key and Primary key?
1. Super Key A super key is an attribute or a set of attributes within a table that uniquely identifies… -
What is Cursor? Difference between Implicit and Explicit Cursor
A Cursor is essentially a temporary work area created in the system memory that comes into play during the execution… -
What is Relational Algebra?
Relational algebra is a formal language used to query and manipulate data stored in relational database systems. It provides a… -
What do you mean by Relational Model? Explain with Example
The relational model is a type of model, which represents how the data are stored in a relational database. In… -
Functions of DBA in DBMS
The role of a Database Administrator (DBA) is to manage and maintain the performance, security, and integrity of a database.… -
What is Data Abstraction and Data Redundancy in DBMS
In the world of data management, two terms often come up: data abstraction and data redundancy. Both play crucial roles…