Answer / Ishan Ahmad

"ACID is an acronym for Atomicity, Consistency, Isolation, and Durability. These are properties that ensure reliable transactions in a database system: 1) Atomicity ensures that each transaction is treated as a single, indivisible unit of work. 2) Consistency guarantees that the database remains in a valid state before and after a transaction. 3) Isolation ensures that concurrent execution of transactions leaves the database in the same state as if they were executed sequentially. 4) Durability ensures that once committed, a transaction will survive permanent failures such as power outages."

Define compound operators?

1 Answers  

---

How to connect ms access to sql servers through odbc?

1 Answers  

---

What is user-defined scalar function?

1 Answers  

---

How to Rebuild Master database in sql server 2005.

2 Answers   Wipro,

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1 Answers  

---

Explain the different index configurations a table can have?

1 Answers  

---

How to create a large table with random data for index testing in ms sql server?

1 Answers  

---

Why main is user defined function?

1 Answers  

---

ow to bring suspect mode datbase online from scratch

1 Answers  

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

How many types of triggers are there?

1 Answers  

---