What is the difference between truncate and delete? How would a full table scan

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

Question Posted / rakesh ranjan

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

More Oracle DBA (Database Administration) Interview Questions

Which function is used to find the largest integer less than or equal to aspecific value?

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

How can be determining the size of the log files?

What is the difference between a database and instance? What is the relation between them?

How can you find out how many users are currently logged into the database? How can you find their operating system id?

What is pga_aggregate_target?

While taking hot backup (begin end backup) what will happens back end?

What happens if the constraint name is left out of a constraint clause?

What does the no logging option do? Why would we be careful of using it?

What do you understand by recovery catalog?

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

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