Answer Posted / abdul malik(new college)

A-Atomacity
C-Consistency
I-Isolation
D-Durability
Atomacity-eiher all operations of the transaction are
reflected properly in the database are none all.
Consistency-Execution of transaction in isolation (ie)with
no other transaction executing concurrently.preserve
the consistency of the database.
Isolation-even though multiple transaction may execute
concurrently.
Durablity-
after a transaction complete successfully the changes it has
made to the database presist even if there are system
failure.
These are called ACID properties.

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1031

---

What is co-related sub query?

1072

---

What is 'write-ahead log' in sql server 2000 ?

1107

---

Can you explain powershell included in sql server 2008?

991

---

What is subreport?

144

---

How to test odbc dsn connection settings?

1086

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

979

---

What is use of except clause?

1142

---

What are views in ms sql server?

1119

---

How to choose all records from the table?

1104

---

write an SQL query to list the employees who joined in the month of January?

1739

---

role of sql sever 2005 in database rather than any other database

1990

---

What are data files?

1094

---

What is an execution plan?

1238

---

In which sql server version report builder introduced?

152

---