You observe that a database performance has degraded over a period of time. While investigating
the reason, you find that the size of the database buffer cache is not large enough to cache all the
needed data blocks. Which advisory component would you refer to, in order to determine that
required size of the database buffer cache?
In your production database, the total waits and the time waited for log file parallel write are
significantly high. While investigating the reason, you find that there are three redo log groups with
two members in each group, and all redo log members are places on a single physical disk. What
action would you take to minimize the waits?
One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and
opening the database?
You have set some of the initialization parameters as:
DB_BLOCK_SIZE = 8KB
SGA_MAX_SIZE = 2GB
SGA_TARGET = 0
SHARED_POOL_SIZE = 120MB
DB_CACHE_SIZE = 896MB
STREAM_POOL_SIZE = 0
LARGE_POOL_SIZE = 110 MB
Which two statements are correct? (Choose two.)
You are performing a block media recovery on the tools01.dbf data file in the SALES database
using RMAN. Which two statements are correct in this scenario? (Choose two.)
In your database, online redo log files are multiplexed and one of the members in a group is lost
due to media failure?
How would you recover the lost redo log member?
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?
The current time zone for one of the user sessions is set to the database local time zone. For one
application, the user session requires the time zone to be set to the local operating system time
zone without affecting other user sessions. Which two solutions could the user implement to
achieve this objective? (Choose two.)