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 would you use user_constraints table in DB?

941

---

What do you understand by physical_only option in dbcc checkdb?

935

---

What are information schema views?

924

---

What will be the maximum number of indexes per table?

912

---

What are the difference between primary key and unique key? : sql server database administration

894

---

Explain the etl (extraction, transformation, and loading)?

940

---

Can sql server 2016 run on windows 7?

865

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

109

---

How many types of subqueries are there in sql server?

937

---

What is ms sql server service broker?

935

---

In how many ways you can invoke ssrs reports?

132

---

What is the web service used for reporting services?

114

---

How can I track the changes or identify the latest insert-update-delete from a table?

915

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

846

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

943

---