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 do I find the sql server version?

1028

---

What is the difference between dbcc indexdefrag and dbcc reindex?

987

---

SQL Server Architecture ?

2462

---

How to select all columns of all rows from a table with a select statement in ms sql server?

1119

---

what is difference between NULL and ISNULL in SQL Server 2008?

1020

---

Explain various On-Delete options in a DB table. Which is the default option?

1469

---

What are truncate options available in sql server? : sql server database administration

1035

---

What is difference between aggregate and analytic function?

939

---

Explain how dts is used to extract, transform and consolidate data?

1000

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1917

---

What function does a database engine serve in the sql server?

1043

---

Can I work with several databases simultaneously? : sql server management studio

995

---

How is table type constraint applied to a table?

979

---

What is the difference between varchar and nvarchar?

942

---

How many types of attribute relationships are there? : sql server analysis services, ssas

1079

---