Answer Posted / kumar

Transaction is logical unit of work. It will be done all
the things must otherwise none.
It Should be Satisfy ACID Property.
A - Acit
C - Consistency
I - Isolation
D - Durability.

By
Kumar T

What is difference between rollback immediate and with no_wait during alter database?

1017

---

What is difference between foreign key and unique key?

966

---

What is the Disadvantage of indexed sequential file.

1029

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

842

---

what are the different types of SSRS reports?

146

---

How do I view a script in sql server?

980

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

996

---

What is the full form of ddl?

866

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

953

---

How to create stored procedures with parameters in ms sql server?

993

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112

---

What are the advantages of using third-party tools?

921

---

What is the command dbcc checkdb used for?

966

---

What is 2nf normalization form?

1052

---

What is sql server 2000 work load governor?

978

---