当前分类： OCP 11G认证考试
问题：单选题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...
查看答案
问题：单选题You executed the following commands in an RMAN session for your database instance that has failures: RMAN LIST FAILURE; After some time, you executed the following command in the same session: RMAN ADVISE FAILURE; But there are new failures recorded in...
问题：多选题The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）AThe optimi...
问题：单选题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 ...
问题：单选题Which setting enables the baselines by default in Oracle Database 11g?（）A setting the STATISTICS_LEVEL parameter to TYPICALB adding filters to the Automatic Database Diagnostic Monitor (ADDM)C enabling Automated Maintenance Task using Oracle Enterprise...
问题：多选题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...
问题：单选题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...
问题：单选题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...
问题：多选题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 are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD lsdsk -I -d DATA Which statement is true regarding th...
问题：单选题If a job references a schedule that has been disabled, what will be the result?（）A The job will be automatically disabled.B The job will never execute.C The job will attempt to execute but will fail.D The job will inherit the DEFAULT_SCHEDULE schedule....
问题：多选题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 ...
问题：单选题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...
问题：单选题Which of the following calendaring syntax expressions would evaluate to the last day of every month?（）A FREQ = MONTHLY; BYMONTHDAY = 31B FREQ = MONTHLY; BYMONTHDAY = -1C FREQ = DAILY; BYDAY = -1D FREQ = MONTHLY; BYDAY = 31E FREQ = DAILY; BYMONTHDAY = L...
问题：多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）ABoth source and target database must be the same character setBBoth source and target database must have the same ...
问题：多选题Which statements are true regarding the Query Result Cache? （）AIt can be set at the system, session, or table level.BIt is used only across statements in the same session.CIt can store the results from normal as well as flashback queries.DIt can store ...
问题：多选题Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? （）ASET_ATTRIBUTE_NULLBALTER_JOBCALTER_JOB_PARAMETERSDALTERESET_ATTRIBUTE...
问题：多选题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 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...
