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
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
What does the no logging option do? Why would we use it? Why would we be careful of using it?
What is the difference between sga and pga?
What is a production dba?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
How many control files should you have? Where should they be located?
What do you understand by recovery catalog?
If you see contention for library caches how you can fix it?
What are the functions of administration?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
Which dba certification is best?