Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest

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

What is the difference between inner join and natural join?

0 Answers  

What is nvarchar max in sql?

0 Answers  

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

What is latest version of sql?

0 Answers  

How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

Can there be 2 primary keys in a table?

0 Answers  

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

What does dml mean?

0 Answers  

real time applications of nullif?

3 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories