站内搜索
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 after the pending transact ion
问题
多选题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 recoveryDfailures due to loss of connectivity-for example, an unplugged disk cable
问题
单选题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 database, but no adverse impacts to the database will be experienced. C
The database will shut down, and will not restart until you correct the out-of-space situation. D
The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally. E
Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
问题
单选题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 Profile recommendationsC
Index-related recommendationsD
restructuring of SQL recommendations
问题
单选题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 Maintenance Tasks to use system resources without any restrictionC
to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD
to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
问题
单选题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 table is shifted from its original positionC
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD
The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
问题
多选题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 CREATE PROFILE command.
问题
单选题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
问题
多选题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 backupEDefault section size for backups
问题
单选题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 a basic metricC
because the STATISTICS_LEVEL parameter is set to BASICD
because the AWR baseline is a system-defined moving window baseline
问题
单选题Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）A
when ASM disk goes offlineB
when one or more ASM files are droppedC
when some disks in a disk group are offlineD
when some disks in a failure group for a disk group are rebalancing
问题
单选题During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?（）A
The installation terminates with an error.B
The installation proceeds with the default value without warnings and errors.C
The installation proceeds with the default value but it would not be an OFA-compliant database.D
The installation proceeds with the default value but a message would be generated in the alert log file.
问题
单选题You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）A
Mount the databaseB
Open the database in NORMAL modeC
Open the database in RESTRICTED modeD
Open the database with the RESETLOGS option
问题
多选题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 optimizer adds the new plan to the plan history.BThe optimizer selects the new plan for the execution of the SQL statement.CThe optimizer adds the new plan to the SQL plan baseline as an accepted plan.DThe optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.EThe optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
问题
单选题Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?（）A
only encryption and compression settings for all SecureFile LOBsB
only encryption and deduplication settings for only SecureFile CLOBsC
deduplication, encryption, and compression settings for all SecureFile LOBsD
deduplication, encryption, and compression settings only for SecureFile CLOBs