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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Can we insert data in view oracle?
How to grant create session privilege to a user in oracle?
What is index in Oracle?
Explain the use of parfile option in exp command.
What is a Garbage Collection? and what is full recursive Garbage collection?
Is a rollback possible to any savepoint?
What is an oracle database table?
What is a data lock in oracle?
What are the attributes that are found in a cursor?
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.
How to list all indexes in your schema?
What is control file used for?
interview questions with answer for cts
What are the differences between interval year to month and interval day to second?
