Interested to Buy Any Domain ? << Click Here >> for more details...
Do view contain data?
- 6 Answers
- 11287 Views
- Ramco, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 12 Yes | 0 No |
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.
| Is This Answer Correct ? | 7 Yes | 0 No |
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
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)
| Is This Answer Correct ? | 2 Yes | 0 No |
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
| Is This Answer Correct ? | 0 Yes | 0 No |
explain the options of myisamchk to improve the performance of a table. : Sql dba
i have some prob lem to tell me about my self in interview first round ...
What is difference between pls_integer and integer?
Define sql delete statement.
What is a join?Explain the different types of joins?
6 Answers Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,
How does one use sql*loader to load images, sound clips and documents? : aql loader
create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
What is varchar data type in sql?
Explian rowid, rownum?
What are wait events. Describe the wait event tables.
what is a sub query?how will you calculate working days in a month using sub query?
Explain the difference between 'between' & 'and' operators in sql
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
