Answer Posted / kumar.t

1. View is logical representation of the table.
2. View is derived from the table.
3. view don't occupy any memory space.

purpose.
1. Security
2. Simplicity of the query.

Another Important Point : view is updatble.

By
Kumar.T

How to perform key word search in tables?

954

---

what is the difference between Tabular and Matrix report?

170

---

What is sql injection? How to protect against sql injection attack?

985

---

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

959

---

Will the writetext statement activate a trigger?

1082

---

What are the purposes and advantages stored procedure?

948

---

How many types of local tables are there in sql server?

922

---

What is difference between views and tables?

1002

---

What is the purpose of data source?

1029

---

What is tempdb in sql server?

967

---

Tell me what are the advantages of using stored procedures?

1000

---

What is dimension table? : sql server analysis services, ssas

1013

---

can a table be moved to different filegroup? : Sql server administration

962

---

What is the difference between system objects and user objects?

1152

---

Explain acid?

1071

---