Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vikas
delete is slow because it creates log file while performing delete operations.We can recover data which is removed by using delete command by using rollback.
Truncate is fast because it does not create any log file while performing delete operation.We can not recover data which is removed by using truncate command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a dynamic performance view in oracle?
How to view all columns in an existing table?
What are triggers in oracle?
How to import one table back from a dump file?
How to grant create session privilege to a user in oracle?
What do you mean by redo log file mirroring?
How to use in conditions in oracle?
What are the logical operations?
What is a tns file?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
When do you get a .pll extension in oracle? Explain its importance
What is Library Cache in Oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
State and explain about oracle instance?
How to create additional tablespaces for an new database?
