What do you understand by the term 'normalization'?
No Answer is Posted For this Question
Be the First to Post Answer
What does the no logging option do? Why would we be careful of using it?
What is oracle dba role?
What are the important tasks of common oracle dba?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
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?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
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?
What is the difference between cold backup and hot backup?
You see multiple extents in the temporary tablespace. Is this a problem?
What is dump destination? What are bdump, cdump and udump?
How do you prevent output from coming to the screen?
What is dba software?