What are the main benefits of using spfile over pfile?
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between logical standby database and physical standby database?
What is the purpose of the grep command?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
What are the requirements of simple database?
What does a dba stand for?
Discuss row chaining, how does it happen? How do you correct it?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
What are the five functions of a database?