Why are recursive relationships bad? How do you resolve them?
No Answer is Posted For this Question
Be the First to Post Answer
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
What is oracle dba role?
If you see contention for library caches how you can fix it?
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 are the requirements of simple database?
You see multiple fragments in the system tablespace, what should you check first?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
What is ora-1555 snapshot too old error? Explain in detail?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
How can you determine if an index needs to be dropped and rebuilt?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
What is a dba why is this position necessary?