Answer / sreekanth

No, View is a logical table associated with a query.
It will not store any data in it.
Only the query with which the view is created is stored in
the database.

Answer / sekhar

Absolutely, the view contain no data. The basic property of
a view is to extract a set of data columns to display from a
large number. And this is useful in future by jst stating
the view name instead writing the select statement every time.

Answer / gvmahesh

NO,the view is a logical table based on one or more tables
or views.A view in practicality contains no data by
itself.it contains only select statements.

Answer / shail

Hold on!!!!

All the above answers are absolutely true but remember the
fact that if you delete or update any view data then it
will be reflected in the base table.

Answer / ram

hold on..
all above are correct
incase of simple view dml operations are allowed
(simple view mean view creates based on one table)

incase of complex view dml operrations not allowd
(complex view create based on more than 1 table)

one more thing is in oracle
materialized view maintain physical copy of data
(dml operations on base tables not reflect on materialized view)

Answer / suresh

View is a stored select statement,it does not contain any data,and it is a logical table just for the viewing purpose

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

How to fix oracle error ora-00942: table or view does not exist

0 Answers  

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  

Where not exists in sql?

0 Answers  

What is query execution plan in sql?

0 Answers  

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

Can we use ddl statements in stored procedure?

0 Answers  

Is postgresql a server?

0 Answers  

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

What is procedure in pl sql?

0 Answers  

How do I view a sql database?

0 Answers  

What is the default isolation level in sql server? : Transact sql

0 Answers