当前分类： OCP 11G认证考试
问题：多选题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...
查看答案
问题：单选题Automatic data conversion will occur if which of the following happens?（）A The client and server have different NLS_LANGUAGE settings.B The client and server character sets are not the same, and the database character set is not a strict superset of th...
问题：单选题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 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...
问题：单选题What does it mean if a backup is expired?（）A The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. B The backup set has one or more invalid blocks in it and is not usable for recovery. C The backup set contains one...
问题：多选题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...
问题：单选题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 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...
问题：单选题Which statement is true regarding the VALIDATE DATABASE command?（）A It checks the database for intrablock corruptions only.B It checks for block corruption in the valid backups of the database.C It checks the database for both intrablock and interblock...
问题：单选题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...
问题：多选题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 statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）A It returns space usage of only BasicFile LOB chunks.B It returns space usage of only SecureFile LOB chunks.C It returns both BasicFile an...
问题：单选题In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?（）A VARCHAR2B CHARC NVARCHAR2D CLOBE LONG...
问题：单选题Which option is best practice for creating a recovery catalog owner in the catalog database?（）A Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege...
问题：单选题Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?（）A All objects in the databaseB Tables owned by SYS and SYSTEMC Data dictionary tablesD NCHAR columnsE CHAR columns...
问题：多选题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...
问题：Which statements are true regarding system-partitioned table...
问题：单选题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...
问题：单选题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 ...
