Answer / sreejith s t

Different Types of Locks are
1. Shared Lock
2. Exclusive Lock
3. Update Lock

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

What are partitioned views?

0 Answers  

---

How do you delete a data source?

0 Answers  

---

What is SQL server agent?

2 Answers   HCL, SAP Labs,

---

What is transaction ? Give me one example.

11 Answers   Melstar, Wipro,

---

what is the maximum size of a row? : Sql server database administration

0 Answers  

---

---

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  

---

What is a cursor in SQL Server 2000 and their types?

8 Answers  

---

What does Master database contains?

0 Answers   Abacus,

---

How many index keys possible for a table

6 Answers  

---

Is candidate a key?

0 Answers  

---

What are the various Isolation levels?

2 Answers   HP,

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,

---