ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
   
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle AllOther
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
How to update the simple views?give me example?if the table 
having 100 records and created a view on this table. if i can 
update the table then how to update the views
 Question Submitted By :: Venki
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
Answer
# 1
if you update the table then view will be automatically update, no need to update view. 
Is This Answer Correct ?    6 Yes 1 No
Muzaffar Ali Umrani
 
  Re: How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
Answer
# 2
THIS IS IMMETIRIAL QUESTION.

IF THE VIEW IS SIMPLE VIEW THEN IF U UPDATE TABLE OR DIRECT
UPDATE ON VIEW THE SAME THINGS WILL HAPPEN.
 
Is This Answer Correct ?    1 Yes 0 No
Sudipta Santra
 
 
 

 
 
 
Other Oracle AllOther Interview Questions
 
  Question Asked @ Answers
 
what is different between inline query,subquery& corelated query? Quest8
whats the difference between join command and Cartesian product using example?  1
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?  4
what is the querry to get first 10 records from the emp table?(emp no is the primary key) Verizon4
Can we get the deleted Record again if the delete transaction has been committed.  3
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?  4
How client makes connection with server in client/server architecture? CA1
What command would you use to encrypt a PL/SQL application?  1
What command would you use to create a backup control file?  1
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count HP2
Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance  1
How can you gather statistics on a table?  2
 
For more Oracle AllOther Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com