What is the difference between truncate and delete? How would a full table scan behave after?
No Answer is Posted For this Question
Be the First to Post Answer
When configuring sqlnet on the client what files need to be set up?
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 you have a large number of wraps is this a problem?
What are the beneficial tools for administering the database?
What do you mean by dba?
How do you put database is archivelog mode, explain procedure?
What are the main functions of dba?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
Do you need a commit after ddl statements?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What are the different responsibilities of a dba?
How do I become an administrator?