当前分类： OCP 11G认证考试
问题：单选题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...
查看答案
问题：单选题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...
问题：多选题The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are the minimum requirements for the statement to execute successf...
问题：单选题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...
问题：多选题Which three elements can a job chain process involve?（）Aan eventBa scheduleCa programDanother chainEa lightweight job...
问题：单选题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 ...
问题：多选题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...
问题：多选题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...
问题：多选题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...
问题：单选题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...
问题：多选题Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?（）AA must contain all of the characters defined in BBA must be UnicodeCThe encoded values in A must match the encoded values...
问题：单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you...
问题：单选题You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking ...
问题：多选题You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import m...
问题：单选题An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQLCREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE ...
问题：单选题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 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...
问题：单选题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...
问题：单选题Examine the parameter setting in your database: Which statement is correct about the database?（）A Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not setB The instance is started but the database will not be o...
问题：How many different calendars does Oracle 11g support?（）...
