Answer Posted / nirmala.s

transaction is series of actions that should happen without
any fail.
if the transaction consists of 3 actions , if anyone of
these fails, then whole transaction wil be rolled back.


like,

banking: we used to say it as a transaction.
logging in, transfer fund and logging out.
if any one of these fails ,
the transaction will not be completed.

Tell me what is normalization? Explain different forms of normalization?

1036

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2231

---

What is Lock table in SQL?

1477

---

What is a mixed extent?

1037

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

145

---

In what three ways is the return statement used in a stored procedure?

1016

---

Define Unique Key?

1024

---

What is row_number () and partition by in sql server?

1090

---

What is difference between commit and rollback when used in transactions?

969

---

Tell me what is log shipping?

984

---

Mention a few common trace flags used with sql server?

941

---

What is isnull() operator?

1050

---

What is difference between joins and subqueries?

1129

---

What do you understand by recursive stored procedures?

998

---

How to count groups returned with the group by clause in ms sql server?

1070

---