Answer Posted / hari

Transcation is a sequene of operations performaed a single
logical unit of work .it must be excuted acid properties.
Atomicity : set of t-sql statements act as a batch
constitancy : ---
isolation : to reduce the concurrency
durabality : once chages are commied database permentaly
saved

What is the largest component inside a field?

1067

---

What are the requirements to use odbc connections in php scripts?

1083

---

How to connect to SQL Azure Database by using sqlcmd?

136

---

Does group by or order by come first?

913

---

What are the transaction properties?

980

---

What is deploy, process and build? : sql server analysis services, ssas

1058

---

How do you manipulate data?

874

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4336

---

What does asynchronous call backs means?

1099

---

Tell me what are cursors and when they are useful?

920

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

945

---

What is bit data type? What's the information that can be stored inside a bit column?

895

---

What is a ddl statement?

871

---

What is the difference between row_number and dense_rank?

847

---

What is the use of group by clause?

915

---