What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
No Answer is Posted For this Question
Be the First to Post Answer
Explain procedure to change characterset of a database.
What do you understand by the term 'normalization'? Explain the various modes of normalization?
What are the roles and responsibilities of oracle dba?
What are dba privileges?
What is the dba role in oracle?
What do you understand by the term 'system change number (scn)'?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
What are the goals of dba?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
What is the difference between truncate and delete? How would a full table scan behave after?
Who is a database user?
When should you increase copy latches? What parameters control copy latches?