Answer / rhys

A view is a "virtual" (isn't physically stored) table. It hides complex details (you can join multiple tables together), provides security/privacy (users can set which columns are available for different people) and it allows read-only access.

The view data dictionary will be updated along side the master data dictionary. For example, if I updated a client's name in the master table, the view would also be amended.

Answer / subhash chandra

views snapsot of multiple table into one one vertual table.
views can be update,insert,delete,its effect base tables
depend upon..
if you update/insert when- base table is multiples/sigle
respectively

Answer / waseem

a view is a virtual table based on the result-set of an SQL
statement.
The fields in a view are fields from one or more real tables
in the database.

You can add SQL functions, WHERE, and JOIN statements to a
view and present the data as if the data were coming from
one single table.
A view always shows up-to-date data! The database engine
recreates the data, using the view's SQL statement, every
time a user queries a view.

Answer / vikash kr pandey

view is a virtual table , which provides to a subset of columns from one or more tables. in which doesn't have its own data.
yes view is updatbable in a single update statement

Answer / fam

a view can be thought as either a store query or a virtual table,store query coz in db only select statement is store and virtual table coz it perfilter the underlying table.
it is updatable in case of simple view and it is non updatable in the case of complex view.

Answer / sd

Views are virtual tables . Formed using queries.

View can / can not be updtaed/

Answer / gunjan sapra

View is a virtual table,created by users for their own
convienience.
views can be updated as required but the updated data will
not reflect in the base table, since view is the virtual
table not the original table.
so, if we want to update the table we have to update that
outside the view or directly but not using view.
if we update through view its temporary means just in the
view only but will not reflect in the base table.

Explain cursor as data base object?

0 Answers  

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

What is the syntax for encrypting a column in SQL Server?

0 Answers   MindCracker,

explain query execution plan

1 Answers  

What is row by row processing ?

2 Answers  

When columns are added to existing tables, what do they initially contain?

0 Answers  

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

What is change tracking in sql server?

0 Answers  

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers