When configuring sqlnet on the client what files need to be set up?
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 space left in a file system?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
Can you remove an open file under unix?
How can you determine if an oracle instance is up from the operating system level?
When should you increase copy latches?
How to uncatalog backup?
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
How many redo logs should you have and how should they be configured for maximum recoverability?
How to drop an oracle database?
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?
Discuss row chaining, how does it happen? How can you reduce it?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?