Answer Posted / vijayabhaskarreddy

view eassy to use , views used to work with part of the
tables.
** provides security for the data.

What is the difference between a function and a stored procedure?

1005

---

How to transfer data from a cursor to variables with a "fetch" statement?

1020

---

What are transactions and its controls?

1003

---

What is policy based management (pbm)? : sql server database administration

928

---

How you can find out if an index is useful to the optimizer?

871

---

Do you know the policy based administration feature of sql server 2008?

905

---

Explain transaction server explicit transaction?

877

---

Determine when an index is appropriate?

1016

---

How to view the error log for any specific instance? : sql server database administration

985

---

What are the different types of upgrades that can be performed in sql server?

1115

---

What are the types of lock supported by ?

995

---

What do you understand by the data quality services in sql server?

900

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

913

---

Explain activity monitors

1004

---

Explain hostprotectionattribute in sql server 2005?

960

---