Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18608 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are group functions in oracle?
Explain the use of tables option in exp command.
Design database draw er diagram for a certain scenario ?
How to create a new table by selecting rows from another table?
Describe an oracle table?
How to list all tables in your schema?
 How to use an oracle sequence generator in a mapping?
How to load a large xml file?
What is a Garbage Collection? and what is full recursive Garbage collection?
What is oracle latest version?
What is different types of joins?
Give syntax for SQL and ORACLE joins.
How to call a stored function with parameters?
Explain an index segment?
How to name query output columns in oracle?
