if you update view? where we store the data?




Answers were Sorted based on User's Feedback



if you update view? where we store the data?..

Answer / smrao

Even if we update the view, the data will update in the
base table of the view.

Is This Answer Correct ?    26 Yes 2 No

if you update view? where we store the data?..

Answer / abhishek.421

in the table itself..view does not contain any data!

Is This Answer Correct ?    8 Yes 0 No

if you update view? where we store the data?..

Answer / vishal muthal

View is nothing but the virtual table made from few columns
of the base table to get faster retrival and fetch of the
data. Hence when you update any view the column which you
updating is get updated,and the column basically belongs to
the base table.hence answer is IT WILL UPDATE BASE TABLE

Is This Answer Correct ?    4 Yes 0 No




if you update view? where we store the data?..

Answer / sivakumar

The value gets updated in base table. This is done by insteadof trigger

Is This Answer Correct ?    1 Yes 0 No

if you update view? where we store the data?..

Answer / ramesh.ch

The updated data will be stored in base table directly.


Explanation:

View is always reference for base table .view is a virtual
table.Unless a view is indexed,its data is not stored in
data base as a distinct element. only the select statement
is stored in the data base.If you call the select statement
of view ,it displays the data form base table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More Oracle General Interview Questions

How to run queries on external tables?

0 Answers  


How to drop an index?

0 Answers  


16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,


What is background process in Oracle?

0 Answers   MCN Solutions,


how do get database name at sql prompt?

3 Answers  






What is a shared pool?

1 Answers  


What is the difference between view and materialized view in Oracle?

0 Answers   MCN Solutions,


I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers   Microsoft,


sql command 2 know current database

4 Answers  


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

0 Answers  


Display Odd/ Even number of records?

3 Answers  


what is the difference between authorization and authentication?

4 Answers   MAHINDRA, PUCIT,






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)