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

How to uncatalog backup?

Who is a database user?

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

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

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

How can you find out how many users are currently logged into the database?

What do you understand by the term 'normalization'?

What is dba in sound level?

What are the steps involved in instance recovery in oracle?

What kinds of responsibilities does a dba have in a database environment?

What are the five main functions of a database administrator?

Which files are vital that should be backed up?

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