当前分类： OCP 11G认证考试
问题：多选题Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）Afailures because a data file is renamed by errorBfailures when no standby database is configuredCfailures that require no archive logs to be applied for rec...
查看答案
问题：多选题When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）AThe job will be dropped automatically if the value of the AUTO_DROP attribute is TRUEBThe job will only be disabled if the value of the AUTO_DROP att...
问题：单选题The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）A to prevent the creation of an excessive number of scheduler job classesB to allow the Automated M...
问题：多选题When does a transaction complete?（）Awhen a DELETE statement is executedBwhen a ROLLBACK command is executedCwhen a PL/SQL anonymous block is executedDwhen a data definition language (DDL) statement is executedEwhen a TRUNCATE statement is executed afte...
问题：多选题Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）AAs ASM instance mounts an ASM control fileBAn ASM instance uses the ASMB process for rebalancing of disks within a disk groupCAutomatic Memory Management is enab...
问题：单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGG...
问题：多选题Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）ABackup retention policyBDefault backup device typeCDefault destinations for backupsDMultiple backup device types for single backupEDef...
问题：单选题Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?（）A Differential incremental backupB Different incremental backup C Cumulative backup D Cumulative incremental backup...
问题：多选题You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?（）AThe backup as copy can only be taken to diskBThe backup as copy can only be taken to tapeCBackup can be performed onl...
问题：单选题Examine the following command: SQL ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）A The shrink operation touches every block in the BOOKING tableB The high-water mark (HWM) for the BOOKING...
问题：单选题Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?（）A PLSQL_BLOCKB JAVA_STORED_PROCEDUREC STORED_PROCEDURED EXECUTABLEE None of the above are invalid settings....
问题：多选题Which two statements regarding a SQL profile are true?（）AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CR...
问题：单选题Your archive-log destination directory runs out of space. What is the impact of this on the database?（）A None. The database will switch over to the stand-by archive-log destination directory. B A warning message will be written to the alert log of the ...
问题：多选题Examine the following command used to perform incremental level 0 backup: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL ALTER DATABASE ENABLE BL...
问题：多选题Which two activities are NOT supported by the Data Recovery Advisor?（）ADiagnose and repair a data file corruption offline.BDiagnose and repair a data file corruption online.CDiagnose and repair failures on a standby database.DRecover from failures in t...
问题：单选题View the Exhibit that sets the threshold for the Current Open Cursors Count metric.Why is the Significance Level threshold type not available in the threshold setting?（）A because AWR baseline is not enabledB because Current Open Cursors Count is not ...
问题：单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A Restore and recover the datafile. B Restore and recover the tablespace. C Restore and recover the database. D Restore and recover the control ...
问题：多选题Which two statements are true regarding working with dates?（）AThe default internal storage of dates is in the numeric formatBThe default internal storage of dates is in the character formatCThe RR date format automatically calculates the century from t...
问题：单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）A Segment AdvisorB SQL Access AdvisorC Undo AdvisorD SQL Tuning Advisor...
问题：单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A statistics recommendationsB SQL Pro...
