which statement is running fastly ie insert or delete?

Answer Posted / sudheer

INSERT BECAUSE IN DELETE STATEMENT TO TAKE THE TIME TO DELETE BECAUSE THAT DATA WHERE IT HAVING TO IT SERACH.BUT INSERT NOT LIKE THAT WHEN U WRITE THE COMMAND ITS NOT TO TAKE LONGER TIME...........

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is null value in oracle?

638


What happens to the data files if a tablespace is dropped?

578


Explain about achiever in sql?

584


What is the difference between postgresql and oracle?

508


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

998






What is a initialization parameter file in oracle?

584


How to assign values to data fields in record variables?

584


How to create additional tablespaces for an new database?

572


What is the max number of columns in an oracle table?

516


How to calculate date and time differences in oracle?

535


How to do a full database export?

637


Where are the settings stored for each instance in oracle?

629


Name the various constraints used in oracle?

567


How to write numeric literals in oracle?

617


Can we save images in a database and if yes, how?

594