What is the difference between truncate and delete? Can we rollback both? How wo

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

Question Posted / kunjan bharti

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle DBA (Database Administration) Interview Questions

What is a dba programmer?

What parameters control copy latches?

Are database administrators in demand?

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

What is your favorite tool for day-to-day oracle operation?

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

What is the difference between raid 5 and raid 10? Which is better for oracle?

What is a dba?

What file will give you oracle instance status information? Where is it located?

What is the purpose of the grep command?

What do you understand by the oracle?

If you see contention for library caches how you can fix it?

For more Oracle DBA (Database Administration) Interview Questions Click Here