Answer Posted / mr.narendra singh(gulli)

transction is a process use for either execution or set
of exection process complite or abort or rollback.
Ex-ATM(alternative transation machine),railway reservation
and so on.

Explain the benefits of user-defined functions?

986

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

932

---

What is the native system stored procedure to execute a command against all databases?

967

---

What happens to a statement batch if there is a compilation error?

897

---

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

1015

---

What is subquery explain with example?

1005

---

Is null in sql server?

938

---

What is resource db in sql server?

962

---

What is the definition for sql server 2000?

1039

---

what is the system function to get the current user's user id? : Sql server database administration

952

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

899

---

What is the language structure to add a record to a table?

962

---

What is the syntax for encrypting a column in SQL Server?

1052

---

Explain iaas, paas and saas?

90

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

887

---