Database Concepts (7th Edition)
Database Concepts (7th Edition)
7th Edition
ISBN: 9780133544626
Author: David M. Kroenke, David J. Auer
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
Explain the difference between an exclusive lock and a shared lock.
What are the methods for handling deadlocks?
You can explain what a shared lock is and what an exclusive lock is.
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.
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