问题:单选题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 task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?()A 2, 4, 3B 1, 4, 3, 2C 2, 5, 4, 3, 6D 5, 2, 4, 3, 6E 1, 5, 4, 3, 6, 2
查看答案
问题:单选题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 offlineD when some disks in a failure group for a disk group are rebalancing
问题:单选题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 modeC Open the database in RESTRICTED modeD Open the database with the RESETLOGS option
问题:多选题Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?()Agenerating the SQL profileBtesting and accepting the SQL profileCgenerating a list of candidate SQLs for tuningDadding tuned SQL plans into the SQL plan baselineEtuning each SQL statement in the order of importanceFgenerating baselines that include candidate SQLs for tuning
问题:单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()A Perform Export before TSPITR and Import after TSPITRB Move objects to another schema that has the same tablespace assignedC Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
问题:单选题Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?()A RSTLNEB NLSRTLC LISTENERD NLSSORTE Linguistic sorts
问题:单选题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 compression settings for all SecureFile LOBsD deduplication, encryption, and compression settings only for SecureFile CLOBs
问题:多选题Which two commands never trigger an implicit rebalancing within the disk group?()AALTER DISKGROUP misc MOUNT;BALTER DISKGROUP misc DROP DISK misc2;CALTER DISKGROUP misc CHECK ALL NOREPAIR;DALTER DISKGROUP misc RESIZE ALL SIZE 1023m;E ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';
问题:多选题Which three elements can a job chain process involve?()Aan eventBa scheduleCa programDanother chainEa lightweight job
问题:单选题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 terminates with an error.B The installation proceeds with the default value without warnings and errors.C The installation proceeds with the default value but it would not be an OFA-compliant database.D The installation proceeds with the default value but a message would be generated in the alert log file.
问题:多选题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 can be used to join tables on columns that have different names but compatible data typesDThe WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
问题:单选题You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this? ()A Implement job classes B Implement Scheduler windowsC Implement the mapping rule for the consumer groups D Set the SWITCH_TIME resource plan directive for both the resource plans
问题:单选题What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?()A It improves resync operations.B This feature enables much faster file opens.C It improves performance as fewer extent pointers are needed in the shared pool.D It improves performance by reading from a copy of an extent closest to the node.
问题:多选题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 optimizer adds the new plan to the plan history.BThe optimizer selects the new plan for the execution of the SQL statement.CThe optimizer adds the new plan to the SQL plan baseline as an accepted plan.DThe optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.EThe optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
问题:单选题What view might you use to try to determine how long a particular backup will take?()A V$SESSION_EVENT B V$SESSION C V$W0041ITSD V$WAITSTAT E V$SESSION_LONGOPS
问题:单选题Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?()A NLS_SORT = BINARYB NLS_SORT = BINARY_AIC NLS_SORT = BINARY_CID NLS_SORT = BINARY_AI_CIE Binary sorts are case insensitive and accent insensitive by default.
问题:多选题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 purged.CAll the objects owned by scott are permanently dropped from the database.DAll the objects of scott in the Recycle Bin must be purged before executing the DROP command.EAny objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
问题:单选题Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()A Because row IDs may change during the flashback operationB Because the object number changes after the flashback operationC Because the rows are retrieved from the recycle bin during the flashback operationD Because the table is moved forward and back to a temporary during the flashback opertion
问题:多选题Which two statements are correct about database transportation? ()AThe source and target platforms must be the sameBRedo logs, control files and temp files are also transportedCThe transported database must have the same database identifier (DBID) as the source database and cannot be changedDThe COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedERecovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
问题:单选题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 available SQL Tuning Set (STS) only D SQL statements that are available in the cursor cache and executed by a user other than SYS