What is the difference between sga and pga?
No Answer is Posted For this Question
Be the First to Post Answer
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 cold backup and hot backup?
What is main function of database administrator?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
Explain the term 'oracle grid architecture'?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
What is the difference between truncate and delete? How would a full table scan behave after?
What is explain plan and how is it used?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What are the roles and responsibilities of oracle dba?
What causes the "snapshot too old" error? How can this be prevented or mitigated?