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.

What is report server project?

147

---

What samples and sample databases are provided by microsoft?

1037

---

can a table be moved to different filegroup? : Sql server administration

972

---

Explain about link server in sql server?

1055

---

What do you mean by an execution plan? How would you view it?

912

---

What is query parameter in ssrs?

160

---

Explain the phases a transaction has to undergo?

1057

---

Can foreign key be duplicate?

1058

---

Explain what are commit and rollback in sql?

931

---

What are “unrepeatable reads”?

1230

---

What is the difference between indexing and hashing?

1167

---

How to connect sql server management studio express to sql server 2005 express?

1042

---

How can we determine what objects a user-defined function depends upon?

1005

---

Differentiate between sql temp table vs table variable?

879

---

How many categories of functions based their return modes?

1101

---