Answer / 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

Answer / sundaresan

Views are used to select particular columns from a table
which is residing in a different DB. Once views are
crerated we can access the view to get the specified column
details from the table which is present in a different DB

Answer / 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.

Answer / vijayabhaskarreddy

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

Answer / thirumal

View is used to fetches the data from existing table and it
doesn't occupy any space in memory.

Answer / reddi

a view is a database object, that contains no data of its own.
it's used for to hide some confidential information.

Answer / reddi

to hide some confidential information

Answer / parmanand

Not all the views are updatable. updatable viwes are
available from SQL Sever 2000 version.

Pls remember all the views are not up datable again.

Answer / mehtab ullah

Purpose of view

Views hide data complexity.
Views add security by restricting access to the columns of a
table.
Views simplify the complex queries for the user.
View is a way to isolate application from changes in
definitions of base tables.
View is derived from the perant table.
View do not occupy any space in the memory .

Answer / veena

Views can reduce the complexity of database schema
Veiw can provide column level and row level security
By using views present aggregated data and hide detailed data

How to insert data with null values?

0 Answers  

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

What is the difference between left and right outer join?

0 Answers  

What is a non-clustered index?

0 Answers  

What is the default schema of your login session in ms sql server?

0 Answers  

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

Explain data warehousing in sql server?

0 Answers  

What is temporary table in sql server? Why we use temp table?

0 Answers  

Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

How can you see what type of locks used?

1 Answers  

If no size is defined while creating the database, what size will the database have?

0 Answers  

How to read data in a table with "select" statements?

0 Answers