What is difference between co-related sub query and nested sub query?
No Answer is Posted For this Question
Be the First to Post Answer
What is oracle dba role?
When should you increase copy latches?
How do you use automatic pga memory management with oracle 9i and above?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
What are the daily activities of oracle dba?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
What is the dba role in oracle?
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 causes the "snapshot too old" error? How can this be prevented or mitigated?