Exam (elaborations)
Sql Server 7 – Locking. Questions & answers, 100% Accurate. Rated A+
Rating
Sold
-
Pages
2
Grade
A+
Uploaded on
03-09-2023
Written in
2023/2024
Sql Server 7 – Locking. Questions & answers, 100% Accurate. Rated A+ intent lock--a mechinism used by transactions to declare their intent of acquiring a lock schema lock--used to maintain structural integrity of tables – i.e. cant drop an index while it is being used exclusive lock--needed for data modification update locks--intermediary lock between schared and exclusive. Indicating that a resource wants to obtain an exclusive lock SELECT: holdlocks--shared locks held for duration of transactions shared locks--used for read operations. Data modification is blocked till locks released – multiple shared locks are possible
Show more
Read less
Institution
Sql Server 7
Course
Sql Server 7
Whoops! We can’t load your doc right now. Try again or contact support.
Written for
- Institution
- Sql Server 7
- Course
- Sql Server 7
Document information
- Uploaded on
- September 3, 2023
- Number of pages
- 2
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
sql server 7 locking questions answers 100
$6.99
Get access to the full document:
Wrong document? Swap it for free
Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
Also available in package deal
Package deal
Sql Server 7 EXAMS Bundle
25
2023
$ 36.99
More info
