Answer Posted / ravina

A transaction is a sequence of sql Operations(commands),
work as single atomic unit of work. To be qualify
as "Transaction" , this sequence of operations must satisfy
4 properties , which is knwon as ACID test.

A(Atomicity):-The sequence of operations must be atomic,
either all or no operations are performed.

C(Consistency):- When completed, the sequence of operations
must leave data in consistent mode. All the defined
relations/constraints must me Maintained.

I(Isolation): A Transaction must be isolated from all other
transactions. A transaction sees the data defore the
operations are performed , or after all the operations has
performed, it can't see the data in between.

D(Durability): All oprtaions must be permanently placed on
the system. Even in the event of system failure , all the
operations must be exhibit.

What are partitioned views?

997

---

How to name query output columns in ms sql server?

968

---

What are the different types of sub-queries?

1043

---

Give an example of SQL injection attack ?

1006

---

What is create command?

969

---

Explain throw statement in sql server 2008?

994

---

explain different types of cursors? : Sql server database administration

1090

---

What is dml command?

969

---

What is the use of floor function in sql server?

1081

---

Define Wed Edition in SQL Azure?

100

---

Explain about unique identifier data type in sql server?

918

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1518

---

What does REVERT do in SQL Server 2005?

961

---

where can you add custom error messages to sql server? : Sql server administration

1120

---

How to use order by with union operators in ms sql server?

1024

---