What action would you take to minimize the waits?

Exhibit 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 loggroups with two members in each group, and all redo log members are places on a singlephysical disk. What action would you take to minimize […]

Read More

Which two statements are correct?

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.) A.You cannot set a value for the DB_8K_CACHE_SIZE parameter. B.If you increase the size of the large pool to 120 MB, then the memory allocated […]

Read More

Which two statements are correct?

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.) A.You cannot set a value for the DB_8K_CACHE_SIZE parameter. B.If you increase the size of the large pool to 120 MB, then the memory allocated […]

Read More

Which two statements are correct in this scenario?

You are performing a block media recovery on the tools01.dbf data file in the SALESdatabase using RMAN. Which two statements are correct in this scenario? (Choose two.) A.You must ensure that the SALES database is mounted or open. B.You must restore a backup control file to perform a block media recovery. C.You must take the […]

Read More

Which type of backup would this command perform?

Exhibit 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? A.backup set B.image copy C.incremental backup D.None; the user receives an error indicating that the backup type must be specified. Show Answer

Read More

How would you recover the lost redo log member?

In your database, online redo log files are multiplexed and one of the members in a group islost due to media failure?How would you recover the lost redo log member? A.import the database from the last export B.restore all the members in the group from the last backup C.drop the lost member from the database […]

Read More

Which statement regarding an incomplete recovery is true?

You are using Oracle Database 10g. Which statement regarding an incomplete recovery istrue? A.You do not need to restore all the data files. B.You do not need to open the database with the RESETLOGS operation C.You do not need to perform a full backup after the RESETLOGS operation. D.You do not need to recover all […]

Read More

Which two effects would be the result of this setting?

Exhibit View the Exhibit and examine the Resource Manager settings for the groups at differentlevels. Which two effects would be the result of this setting? (Choose two.) A.The members of LOW_GROUP would get more priority than those of OTHER_GROUPS. B.The members of SYS_GROUP would get most of the CPU allocation at level 1. C.The members […]

Read More