当前分类： 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...
查看答案
问题：单选题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...
问题：单选题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...
问题：单选题Which of the following calendaring syntax expressions would evaluate to the last day of every month?（）A FREQ = MONTHLY; BYMONTHDAY = 31B FREQ = MONTHLY; BYMONTHDAY = -1C FREQ = DAILY; BYDAY = -1D FREQ = MONTHLY; BYDAY = 31E FREQ = DAILY; BYMONTHDAY = L...
问题：多选题Which two statements are true regarding subqueries? （）AA subquery can retrieve zero or more rowsBOnly two subqueries can be placed atone levelCA subquery can be used only in SQL query statementsDA subquery can appear on either side of a comparison oper...
问题：多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations...
问题：单选题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...
问题：单选题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 two statements are true regarding hot patching? （）AIt requires relinking of the Oracle binary.BIt does not require database instance shutdown.CIt can detect conflicts between two online patches.DIt is available for installing all patches on all p...
问题：单选题Which backup option defines a user-defined name for a backup? （）A FORMATB NAMEC TAGD FORMAT U%...
问题：多选题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...
问题：单选题Which statement about recovering from the loss of a redo log group is true?（）A If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B If the lost redo log group is CURRENT, you must clear the log file.C If the lost redo ...
问题：单选题Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?（）A New channels for restore and recovery tasksB New name for the data files of the tablespaceC Auxiliary name fo...
问题：多选题Which three elements can a job chain process involve?（）Aan eventBa scheduleCa programDanother chainEa lightweight job...
问题：单选题You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?（...
问题：单选题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...
问题：Which command will result in a trace file being created with...
问题：多选题The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?（）AAll the related indexes and views are automatically droppedBThe flashback d...
问题：单选题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 ...
