RDBMS FUNDAMENTALS - Locking

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(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 Job Interview Questions

• RDBMS FUNDAMENTALS - Uncommitted Data Problem
• RDBMS FUNDAMENTALS - Lost Update Problem
• RDBMS FUNDAMENTALS - Transaction Processing
• RDBMS FUNDAMENTALS - Shared Locks
• RDBMS FUNDAMENTALS - Architecture of a Database
• RDBMS FUNDAMENTALS - End-user's View of a Database
• RDBMS FUNDAMENTALS - Lost Update Problem
• RDBMS FUNDAMENTALS - Organizing the Database
• RDBMS FUNDAMENTALS - INTERPRETING DATA - Relationships
• RDBMS FUNDAMENTALS -SIMPLIFYING DATA
• More...