What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
No Answer is Posted For this Question
Be the First to Post Answer
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What are elements of administration?
How do you set up your tablespace on installation level: low?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
How do I become an administrator?
What skills should a dba have?
What are roles in oracle?
When should the default values for oracle initialization parameters be used as is?
Are database administrators in demand?
What os user should be used for the first part of an oracle installation (on unix)?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
What are the five functions of a database?