Answer Posted / 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

How many columns can exist together per table?

1156

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

967

---

What are the new scripting capabilities of ssms? : sql server management studio

1067

---

Is candidate a key?

947

---

How to get the definition of a stored procedure back?

977

---

What are the different types of sql server replication? : sql server replication

1272

---

What is the difference between nvl and nvl2?

977

---

How to define output parameters in stored procedures?

1027

---

What is a collation in ms sql server?

1085

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1146

---

What is autocommit mode in sql server?

1177

---

What is implicit cursors?

1085

---

What happens if you are trying to access a schema not owned by you?

968

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1140

---

Explain how to use linked server?

991

---