What is difference between logical standby database and physical standby database?
What are the skills required for oracle dba?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
How can you determine if an oracle instance is up from the operating system level?
Why are recursive relationships bad? How do you resolve them?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
How do you set up your tablespace on installation level: low?
When should you increase copy latches?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
What is a junior dba?
What does the no logging option do? Why would we use it? Why would we be careful of using it?