if i perform any operation on views such as insert, delete
etc will my base table get affected?????

Answers were Sorted based on User's Feedback



if i perform any operation on views such as insert, delete etc will my base table get affected????..

Answer / ramesh

yes if it is simple view. error if it is compunt view

Is This Answer Correct ?    8 Yes 2 No

if i perform any operation on views such as insert, delete etc will my base table get affected????..

Answer / gourvendra singh

It will affect ur base table only when u having a simple
view and if you put null in the field which is primary key
of the base table then also the base table will not
affected. And if you are using the compute view then u r nt
able to insert or delete the records.

Is This Answer Correct ?    3 Yes 1 No

if i perform any operation on views such as insert, delete etc will my base table get affected????..

Answer / slokh

yes if it is a simple view. may be if is a complex view -

Is This Answer Correct ?    0 Yes 0 No

if i perform any operation on views such as insert, delete etc will my base table get affected????..

Answer / radha sri seshu.kolla

yes it will effect if your view is a simple view (eg:
create or replace view empview as select * from emp;) this
is called simple view. if you use any joins or if u create
view using more than two tables then it is called complex
view. in case of comlex view the database will not effect.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,


What is the advantage of nosql?

0 Answers  


What is ROWID?

8 Answers  


What is data type in database?

0 Answers  


Should I use mbr or gpt?

0 Answers  






What is procedure explain with example?

0 Answers  


what are the differences between binary and varbinary? : Sql dba

0 Answers  


Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,


Explain the advantages and disadvantages of stored procedure?

0 Answers  


Why does %isopen return false for an implicit cursor?

1 Answers  


How to execute a stored procedure?

0 Answers  


what is the difference between binary_integer and pls_integer

2 Answers   TCS,


Categories