当前分类： OCP 11G认证考试
问题：多选题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...
查看答案
问题：单选题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instanc...
问题：单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?（）A It will display a list of files that need incremental backupB It will display a list of files that need backup after...
问题：单选题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...
问题：单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）A The EMPLOYEES table will be changed to read-onl...
问题：单选题Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）A restore datafiles until time '09/28/2008:21:03:11'B restore database files until time '09/28/2008:18:00:00'C restore database until time '09/28/2008:18:00:00'D recover d...
问题：单选题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...
问题：多选题What recommendations does the SQL Access Advisor provide for optimizing SQL queries?（）Aselection of SQL plan baselinesBpartitioning of tables and indexesCcreation of index-organized tablesDcreation of bitmap, function-based, and B-tree indexesEoptimiza...
问题：单选题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 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 three elements can a job chain process involve?（）Aan eventBa scheduleCa programDanother chainEa lightweight job...
问题：单选题Which statement about using RMAN stored scripts is true?（）A To create and execute an RMAN stored script, you must use a recovery catalog.B When executing a stored script and a command fails, the remainder of the script is executed, and a message is wri...
问题：单选题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...
问题：多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）ABoth source and target database must be the same character setBBoth source and target database must have the same ...
问题：多选题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...
问题：单选题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 statement is true regarding the COALESCE function?（）A It can have a maximum of five expressions in a list B It returns the highest NOT NULL value in the list for all rows C It requires that all expressions in the list must be of the same data typ...
问题：多选题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...
问题：多选题Which three components does the Scheduler use for managing tasks within the Oracle environment?（）Aa jobBa programCa scheduleDa PL/SQL procedure...
