当前分类： OCP 11G认证考试
问题：多选题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...
查看答案
问题：多选题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are pur...
问题：单选题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 te...
问题：单选题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）A SQL statements that are part of the AWR baseline only B SQL statements based on the AWR top SQL identificationC SQL statements that are part of the availa...
问题：多选题To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?（）ALOG_HISTORYBJOB_LOG_RETENTIONCWINDOW_LOG_RETENTIONDWHICH_LOGELOG_NAME...
问题：多选题Which three statements are true about windows?（）AOnly one window can be open at any given timeBConsumer groups are associated with windowsCWindows work with job classes to control resource allocationDThe database service name must be provided during wi...
问题：单选题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 offlin...
问题：多选题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...
问题：单选题Note the following statements that use flashback technology: 1. FLASHBACK TABLE TO SCN ; 2. SELECT * FROM AS OF SCN 123456; 3. FLASHBACK TABLE TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP ; 5. SELECT * FROM VERSIONS AS OF SCN 123456 AND 12399...
问题：多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a success...
问题：单选题Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance ta...
问题：单选题What is the default value for the ENABLED attribute of a job or program when it is created? （）A TRUEB FALSEC There is no default. It must be defined at creation time.D PENDINGE NULL...
问题：多选题For which two situations would you use functionality provided by the Resource Manager?（）Asetting idle timeout limits on resource plansBsaving storage space by using compressed backup setsCcreating jobs that will run automatically at a scheduled timeDas...
问题：单选题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 compress...
问题：多选题Which two statements are true regarding the USING and ON clauses in table joins?（）ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause c...
问题：多选题Which three elements can a job chain process involve?（）Aan eventBa scheduleCa programDanother chainEa lightweight job...
问题：多选题Identify the three predefined server-generated alerts.（）ADrop UserBTablespace Space UsageCResumable Session SuspendedDRecovery Area Low On Free SpaceESYSTEM Tablespace Size Increment...
问题：单选题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 ...
问题：单选题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 ...
