Answer Posted / nithya.r

A view is a virtual table. A view serves as a security
mechanism. If we have several tables in a database and we
want to view only specific columns from specific tables we
can go for views. Using view we can avoid the complex
queries.

how many triggers you can have on a table? : Sql server database administration

968

---

What is the fillfactor concept in indexes?

972

---

Explain timestamp datatype?

957

---

What is an entity-relationship diagram (erd)?

1200

---

How to create sub reports?

242

---

Explain about system database?

1051

---

How to turn off warning messages during php execution?

1032

---

What is the stuff and how does it differ from the replace function?

1113

---

Tell me what do we need queues in sql service broker?

981

---

How to generate create table script on an existing table in ms sql server?

1138

---

How you can change the database name in SQL SERVER?

1186

---

Which table keeps the locking information?

913

---

Do you know what is similarity and difference between truncate and delete in sql?

1001

---

How can I create a report based on a query? : sql server management studio

1009

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

948

---