What is a Lock and let me know Different types of locks?
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 |
how to dispaly a particular row details from a given table
Can I save my report as html, excel or word? : sql server management studio
What Is The Difference Between Primary Key & Super Key
what is database replication? : Sql server database administration
Explain use of expression builder.
What is checkpoint process in the sql server?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is subquery? Explain the properties of a subquery?
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)