ocp认证043新增题库.docVIP

1、 In Recovery Manager(RMAN), you set the retention policy to NONE by executing the following command: CONFIGURE RETENTION POLICY TO NONE; what would be the impact of this setting? A. The retention policy cleared; B. RMAN does not consider any backup as obsolete; C. The retention policy is set to its default setting of redundancy 1. D. The retention policy is set to its default setting of recovery window 7. B 2、 Using the LIST command in Recovery Manager(RMAN), which two pieces of information from the RMAN repository can be listed? backups that can be deleted stored scripts in the recovery catalog backup sets and image copies that are obsolete only the most recent backup sets or image copies backups that do not have the AVALIABLE status in RMAN repository B E 3、 From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective? create a plan directive in the SYS_GROUP create the pending area for the consumer group activate the provided SYSTEM_PLAN in Resource Manager set the TIMED_STATISTIS parameter to TRUE in the parameter file set the execution time limit for all users, except SYS and SYSTEM, in their profiles c 4、 In the parameter file of the production database, the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location? the alert log file the core dump files the change tracking file the user session trace files the database audit trail files the background process trace files a f 5、 You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not