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 exactly does a dba do?
How many control files should you have?
What are functions of dba?
What is difference between co-related sub query and nested sub query?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
When configuring sqlnet on the server what files must be set up?
What are bind variables and why are they important?
What do you understand by recovery catalog?
What are the daily activities of oracle dba?
What is the full form of dba?
How many databases should a dba manage?
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?