What is the difference between raid 5 and raid 10? Which is better for oracle?
What skills should a dba have?
What is dba in sound level?
How many control files should you have?
What is oracle archived redo log?
How can you determine if an index needs to be dropped and rebuilt?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
How can you find dead processes?
When should you increase copy latches? What parameters control copy latches?
What do you understand by a control file?
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?)
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
How can you determine the number of sqlnet users logged in to the unix system?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?