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 purpose of normalization?

950

---

What is self contained sub query?

1062

---

How do you drop an index?

927

---

Can sql servers link to other servers?

1093

---

Is resultset an interface?

976

---

What is transaction server auto commit?

1068

---

How to sort the query output with order by clauses in ms sql server?

1035

---

What is 2nf in normalization?

1002

---

Explain different types of locks in sql server.

1082

---

What are the new features of sql server 2012 reporting service?

133

---

what is sql server? : Sql server database administration

993

---

How to copy data from one table to another table?

996

---

How to create indexed view?

1047

---

can SSRS reports Cache results?

147

---

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

312

---