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.

Different types of keys in SQL?

1103

---

How to list all dsn entries on your local machine using odbc_data_source()?

1042

---

What is difference between sql and sql server?

1010

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1029

---

What are the disadvantages of using querystrings to send data from one page to another?

1009

---

Explain different forms of normalization?

951

---

What is a performance monitor?

977

---

What is sparse columns of sql server 2008?

1060

---

What is equi join with example?

1137

---

What are the source of constraints?

935

---

How to sort query output in descending order in ms sql server?

945

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1144

---

What are user defined functions in ms sql server?

1009

---

What is meant by referential integrity?

1013

---

What is a join in sql? What are the types of joins?

1113

---