which statement is running fastly ie insert or delete?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / kandulasreekanth

13 Answers
19383 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

which statement is running fastly ie insert or delete?..

Answer / sandeep desai

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 ?

14 Yes

0 No

which statement is running fastly ie insert or delete?..

Answer / amit choubey

insert

Is This Answer Correct ?

13 Yes

7 No

which statement is running fastly ie insert or delete?..

Answer / somya

delete

Is This Answer Correct ?

7 Yes

1 No

which statement is running fastly ie insert or delete?..

Answer / sandep

it is delete

Is This Answer Correct ?

6 Yes

0 No

which statement is running fastly ie insert or delete?..

Answer / bhavna

Delete

Is This Answer Correct ?

5 Yes

0 No

which statement is running fastly ie insert or delete?..

Answer / chandiran

Delete

Is This Answer Correct ?

5 Yes

0 No

which statement is running fastly ie insert or delete?..

Answer / swati gupta

it is delete...........

Is This Answer Correct ?

4 Yes

0 No

which statement is running fastly ie insert or delete?..

Answer / sanal kumar

Delete runs faster than insert

coz whle during delete command,it only removes the records
from the table and the space alocated for the records
remains still..but for insertion,need to allocate the space
and insert the records in data blocks..

Is This Answer Correct ?

5 Yes

1 No

which statement is running fastly ie insert or delete?..

Answer / vivek kumar dixit

delete runs fastly

Is This Answer Correct ?

3 Yes

0 No

which statement is running fastly ie insert or delete?..

Answer / akhilesh

Delete

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Oracle General Interview Questions

What is blob datatype?

0 Answers

What is dictionary cache ?

2 Answers

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers IMS Health, NIIT,

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers HCL,

How to generate query output in html format?

0 Answers

Explain oracle instance.

0 Answers

What are the varoius components of physical database structure of oracle database?

0 Answers

Explain what are the characteristics of data files?

0 Answers

Can u make a synonym for deptno=10 only from emp table.

1 Answers TCS,

How to use "while" statements in oracle?