What does the no logging option do? Why would we use it? Why would we be careful of using it?
No Answer is Posted For this Question
Be the First to Post Answer
What causes the "snapshot too old" error? How can this be prevented or mitigated?
How do you generate file output from sql?
What are the requirements of simple database?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
What is the most common database language that a db administrator needs to know?
What are the different types of backup available in the oracle?
Why are recursive relationships bad? How do you resolve them?
Discuss row chaining, how does it happen? How can you reduce it?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
What does a dba do all day?
How many dba can you have?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?