Answer Posted / hloni

A transaction is a sequence of database operations that
access the database. It must be a logical unit of work,
meaning that no portion of the transaction can exist on its
own. Either all parts are executed or the transaction is
aborted.

Transaction has five main properties called ACIDS:

1. Atomicity -- all parts of the transaction are executed
or else the transaction is aborted.

2. Consistency -- indicates the permanence of the
database's consistent state. When a transaction is
completed the database reaches a consistence state.

3. Isolation -- means that the data used during the
exercution of a transaction cannot be used by the a second
transaction until the first transaction is complete.

4. Durability -- ensures that once transaction changes are
commited, they cannot be lost even in the event of system
failure.

5. Serializability -- ensures that concurrent execution of
several transaction yields consistent results. This
property is important in a multi-user and distributed
datbases, where multiple transaction are likely to be
executed concurrently.

What is sql server profiler trace data file?

1109

---

What are the grouping functions?

930

---

Explain different types of index?

1051

---

What is data source object?

999

---

How do I debug a stored procedure in sql server?

1103

---

Explain the dbcc pintable command when would you use it?

914

---

What is normalization 1nf 2nf 3nf?

1058

---

What are the advantages of using stored procedures?

947

---

What are orphan records?

929

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1040

---

How to read data in a table with "select" statements?

967

---

Describe the left outer join & right outer join. : sql server database administration

996

---

Mention a few common trace flags used with sql server?

927

---

What are click through reports?

142

---

Tell me something about security and sql azure?

114

---