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 are the functions of administration?

What command is used to type files to the screen?

What is the use of the drop option in the alter table command?

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

What are the main benefits of using spfile over pfile?

How many databases should a dba manage?

When configuring sqlnet on the server what files must be set up?

How do you set up tablespaces during an oracle installation?

What is main function of database administrator?

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

What are elements of administration?

What skills does a dba need?

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