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 see multiple fragments in the system tablespace, what should you check first?
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 different types of backup available in the oracle?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
What is difference between logical standby database and physical standby database?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
What are database skills?
Explain the wait events in statspack report 'enqueue'?
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
If you have an example table, what is the best way to get sizing data for the production table implementation?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
What are the requirements of simple database?
How do you install statspack?