Database Concepts (8th Edition)
Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
bartleby

Concept explainers

Question
Book Icon
Chapter 6, Problem 6.14RQ
Program Plan Intro

Locks:

In order to avoid accessing the content or obtaining the copies of the same rows or table by multiple applications, a technique called resource locking is used to overcome this problem.

Resource locking is a technique which prevents the concurrent processing problems which blocks the sharing of resources or data by locking the resources or data.

Types of lock:

There are two types of lock which vary by type

  • Shared Locks
  • Exclusive Locks

Blurred answer
Students have asked these similar questions
State the difference between a shared lock and an exclusive lock.
Difference between the shared locks and the exclusive locks.
Describe the necessary conditions for Deadlock. Explain various methods for handling deadlocks.
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage