Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Lock and let me know Different types of locks?
- 2 Answers
- 5015 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sreejith s t
Different Types of Locks are
1. Shared Lock
2. Exclusive Lock
3. Update Lock
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / udhaya
Shared (S) Used for operations that do not change or update
data (read-only operations), such as a SELECT statement.
Update (U) Used on resources that can be updated. Prevents
a common form of deadlock that occurs when multiple
sessions are reading, locking, and potentially updating
resources later.
Exclusive (X) Used for data-modification operations, such
as INSERT, UPDATE, or DELETE. Ensures that multiple updates
cannot be made to the same resource at the same time.
Intent Used to establish a lock hierarchy. The types of
intent locks are: intent shared (IS), intent exclusive
(IX), and shared with intent exclusive (SIX).
Schema Used when an operation dependent on the schema of a
table is executing. The types of schema locks are: schema
modification (Sch-M) and schema stability (Sch-S).
Bulk Update (BU) Used when bulk-copying data into a table
and the TABLOCK hint is specified
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain indexed views and partitioned view with their syntax.
Can we call stored procedure in view in sql server?
What is shared lock?
What is instead of trigger sql server?
What are transactions and its controls?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
List the ways in which dynamic sql can be executed?
Where to find ntwdblib.dll version 2000.80.194.0?
How to provide default values to function parameters?
How each E-R model constructs can be mapped to the relational model?
How would you Update the rows which are divisible by 10, given a set of numbers in column?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
