You observe that a database performance has degraded over a period of time. While investigatingthe reason, you find that the size of the database buffer cache is not large enough to cache all theneeded data blocks. Which advisory component would you refer to, in order to determine thatrequired […]
In your production database, the total waits and the time waited for log file parallel write aresignificantly high. While investigating the reason, you find that there are three redo log groups withtwo members in each group, and all redo log members are places on a single physical disk. […]
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 andopening the database?
You have set some of the initialization parameters as:DB_BLOCK_SIZE = 8KBSGA_MAX_SIZE = 2GBSGA_TARGET = 0SHARED_POOL_SIZE = 120MBDB_CACHE_SIZE = 896MBSTREAM_POOL_SIZE = 0LARGE_POOL_SIZE = 110 MBWhich two statements are correct? (Choose two.)
You are performing a block media recovery on the tools01.dbf data file in the SALES databaseusing RMAN. Which two statements are correct in this scenario? (Choose two.)
You executed the following command to perform a backup of the USERS tablespace:RMAN > BACKUP TABLESPACE USERS;Which type of backup would this command perform?
In your database, online redo log files are multiplexed and one of the members in a group is lostdue 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?
View the Exhibit and examine the Resource Manager settings for the groups at different levels.Which two effects would be the result of this setting? (Choose two.)
The current time zone for one of the user sessions is set to the database local time zone. For oneapplication, the user session requires the time zone to be set to the local operating system timezone without affecting other user sessions. Which two solutions could the user implement toachieve […]