ALLInterview.com :: Home Page KalAajKal.com
 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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 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 
which statement is running fastly ie insert or delete?
 Question Submitted By :: Kandulasreekanth
I also faced this Question!!     Rank Answer Posted By  
 
  Re: which statement is running fastly ie insert or delete?
Answer
# 1		 
insert
 
Is This Answer Correct ?    1 Yes 1 No
Amit Choubey
 
  Re: which statement is running fastly ie insert or delete?
Answer
# 2		 
delete
 
Is This Answer Correct ?    1 Yes 0 No
Somya
 
 
 
  Re: which statement is running fastly ie insert or delete?
Answer
# 3		 
Delete
 
Is This Answer Correct ?    2 Yes 0 No
Bhavna
 
  Re: which statement is running fastly ie insert or delete?
Answer
# 4		 
Its definitely Delete.
Becuase
When Delete operation is being performed then Oracle
doesnot actualy permanently remove the data from data block 
but rather marks that particular data block as unusable.
Whereas when concerned to Insert Oracle needs to insert the 
new values into Datablocks.
 
Is This Answer Correct ?    4 Yes 0 No
Sandeep Desai
 
  Re: which statement is running fastly ie insert or delete?
Answer
# 5		 
it is delete
 
Is This Answer Correct ?    2 Yes 0 No
Sandep
 
  Re: which statement is running fastly ie insert or delete?
Answer
# 6		 
it is delete...........
 
Is This Answer Correct ?    0 Yes 0 No
Swati Gupta
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS Mind-Tree2
what is analyze command ? what kind of statistics does it generate?  1
what is the use of rank function?  1
Write a simple Store procedure and pass parameter to it ? Keane-India-Ltd1
Explain the relationship among Database, Tablespace and Data file?  1
Is it possible to enter only time value into a column of a table in sql?  1
What are the advantages of Views ?  1
what is index?  3
what diffrence between function and procedure?  3
What is different bet native dynamic sql and Dbms_Sql? Thermotech2
What is STATSPACK tool? Wipro1
What are joins..how many types of joins are there? TCS8
What is the use of Control File ?  1
What are synonyms used for ?  2
what is the syntax of DROP command?  5
what are stored procedures? TCS3
When can Hash Cluster used ?  1
What is an Index Segment ?  1
What are main difference between Stored Procedure and Functions. CA2
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?  1
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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