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.

Is sql server implemented as a service or an application? : Sql server database administration

921

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

904

---

Explain the benefits of user-defined functions?

1012

---

What is RMS migrations?

2106

---

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

135

---

how would you improve etl (extract, transform, load) throughput?

987

---

How can windows applications connect to sql servers via odbc?

1084

---

Why would you use sql agent?

1235

---

Can you use order by when defining a view?

931

---

Which are the two editions in which SQL Azure database available?

119

---

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

165

---

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

974

---

Which are new data types introduced in sql server 2008?

1010

---

How many databases Microsoft SQL server provides?

1047

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

953

---