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 indexers?

1036

---

What is a with(nolock)?

928

---

What is the query and subquery?

1027

---

How to enter binary string literals in ms sql server?

1097

---

When we should use @@error?

914

---

What is “asynchronous” communication in sql server service broker?

962

---

What is the default order of an order by clause?

946

---

What is 2nf example?

943

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

963

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1089

---

What are the disadvantages of primary key and foreign key in SQL?

1049

---

What is tabulation?

899

---

How do I manually uninstall an instance of sql server 2016?

965

---

Tell about MOM Tool(Microsoft Operator Manager)?

1854

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2045

---