RDBMS FUNDAMENTALS - Locking

RDBMS FUNDAMENTALS Interview Questions and Answers

(Continued from previous question...)

RDBMS FUNDAMENTALS - Locking

Locking : Locking is a facility provided by an RDBMS to ensure that a transaction does not interfere with any other transaction. Locking prevents the problem of lost update, uncommitted data and inconsistent data. An RDBMS provided two types of locks for locking a part of the database - shared locks and exclusive locks.

(Continued on next question...)

Other Interview Questions

• RDBMS FUNDAMENTALS - Concept of a Database
• RDBMS FUNDAMENTALS - Database Management System (DBMS)
• RDBMS FUNDAMENTALS - Architecture of a Database
• RDBMS FUNDAMENTALS - What is Relational Database?
• RDBMS FUNDAMENTALS - Relational Database's Attribute
• RDBMS FUNDAMENTALS - Relational Database's Tuple
• RDBMS FUNDAMENTALS - Relational Database's Domain
• RDBMS FUNDAMENTALS - Identifiers for Relations
• RDBMS FUNDAMENTALS - INTERPRETING DATA - Entities
• RDBMS FUNDAMENTALS - INTERPRETING DATA - Relationships
• RDBMS FUNDAMENTALS -SIMPLIFYING DATA
• RDBMS FUNDAMENTALS - Language Support for an RDBMS
• RDBMS FUNDAMENTALS - Organizing the Database
• RDBMS FUNDAMENTALS - Interacting with a Database
• RDBMS FUNDAMENTALS - End-user's View of a Database
• RDBMS FUNDAMENTALS - Restricting Access to a Database
• RDBMS FUNDAMENTALS - Data Integrity
• RDBMS FUNDAMENTALS - Integrity Constraints
• RDBMS FUNDAMENTALS - Entity Integrity
• RDBMS FUNDAMENTALS - Referential Integrity
• RDBMS FUNDAMENTALS - Transaction Processing
• RDBMS FUNDAMENTALS - Commit
• RDBMS FUNDAMENTALS - Rollback
• RDBMS FUNDAMENTALS - Concurrency Control
• RDBMS FUNDAMENTALS - Lost Update Problem
• RDBMS FUNDAMENTALS - Uncommitted Data Problem
• RDBMS FUNDAMENTALS - Inconsistent Data Problem
• RDBMS FUNDAMENTALS - Locking
• RDBMS FUNDAMENTALS - Shared Locks
• RDBMS FUNDAMENTALS - Exclusive Locks