当前分类： OCP 11G认证考试
问题：多选题Which tasks are run automatically as part of the Automated Maintenance Task by default?（）ASegment AdvisorBSQL Access AdvisorCOptimizer statistics gatheringDAutomatic SQL Tuning AdvisorEAutomatic Database Diagnostics Monitor...
查看答案
问题：单选题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 ...
问题：单选题In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which acci...
问题：多选题You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）ABackup compression should be enabledBParallelism for the channel shou...
问题：单选题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 the minimize load database parameter mean when backing up a database?（）A RMAN will attempt to make the backup run as fast as possible without any IO limitations. B RMAN will automatically restrict the number of channels in use to one. C RMAN ...
问题：多选题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...
问题：多选题Identify the three predefined server-generated alerts.（）ADrop UserBTablespace Space UsageCResumable Session SuspendedDRecovery Area Low On Free SpaceESYSTEM Tablespace Size Increment...
问题：单选题What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）A An upper limit on how far you can flash back the database, depending on the information in the redo logsB An upper limit on how far you can flash back the database, depending on the in...
问题：单选题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...
问题：单选题Which of the following parameters defines the location where Oracle should create archived redo logs?（）A LOG_ARCHIVE_1 B LOG_DESTINATION_1 C LOG_ARCHIVED_DESTINATION_1D LOG_ARCHIVE_DEST_1E LOG_ARCHIVE_SOURCE_1...
问题：多选题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 is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?（）A The database must be running in ARCHIVELOG mode.B No special set...
问题：单选题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 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 ...
问题：单选题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...
问题：多选题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...
问题：单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to en...
问题：单选题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 ...
