单选题Which statement describes the effect of the execution of the above PL/SQL block?（）AThe plan baselines are verified with the SQL profiles.BAll fixed plan baselines are converted into nonfixed plan baselines.CAll the nonaccepted SQL profiles are accepted into the plan baseline.DThe nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
单选题
Which statement describes the effect of the execution of the above PL/SQL block?（）
A
The plan baselines are verified with the SQL profiles.
B
All fixed plan baselines are converted into nonfixed plan baselines.
C
All the nonaccepted SQL profiles are accepted into the plan baseline.
D
The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
参考解析
解析：
暂无解析
相关考题：
多选题Which two statements about the SQL Management Base (SMB) are true?（）AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.
多选题You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）AEvery SQL statement in the STS is considered only once for executionBThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsCThe execution plan and execution statistics are computed for each SQL statement in the STSDThe effects of DDL and DML are considered to produce the execution plan and execution statistics
多选题You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? （）AThe ASM-preferred mirror read feature is enabled.BThe ASM supports variable sizes for extents of 1, 8, and 64 allocation units.CThe ASM disk is dropped immediately from a disk group when it becomes unavailable.DThe RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
多选题Identify three key features of ASM.（）Afile stripingBallocation unit mirroringCautomatic disk rebalancingDautomatic file size incrementEautomatic undo management
单选题Which statement is true regarding virtual private catalogs? （）AA virtual private catalog owner can create a local stored script, and have read/write access to a global stored script. BThe virtual private catalog owner cannot create and modify the stored scripts. CThe set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner. DTo perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.
多选题You plan to execute the following command to perform a Flashback Database operation in your database: SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation
单选题In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）AComplete Recovery with online redo logBComplete Recovery with archived redo logCTablespace Point-in-Time Recovery (TSPITR)DIncomplete Recovery with system change number (SCN)
单选题How is block-change tracking enabled?（）AWith alter database enable block change trackingBWith alter system enable block change tracking CWith an init.ora parameter change DWith an spfile parameter change
单选题Which of the following is not a valid linguistic sort element?（）AAccent expansionBCanonical equivalenceCReverse secondary sortingDIgnorable charactersECharacter rearrangement
单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）Aalter tablespace DAVE_TBS backup modeBalter tablespace DAVE_TBS start backup Calter tablespace DAVE_TBS begin backup Dalter tablespace DAVE_TBS backup begin Ealter tablespace DAVE_TBS backup
单选题Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?（）AAll objects in the databaseBTables owned by SYS and SYSTEMCData dictionary tablesDNCHAR columnsECHAR columns
单选题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?（）AThe installation terminates with an error.BThe installation proceeds with the default value without warnings and errors.CThe installation proceeds with the default value but it would not be an OFA-compliant database.DThe installation proceeds with the default value but a message would be generated in the alert log file.
单选题What is the proper command to shut down the database in a consistent manner?（）Ashutdown abort Bshutdown kill CShutdown nowait Dshutdown immediateEshutdown halt
多选题While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?（）AThe plan baselines can be evolved over time to produce better performance.BThe newly generated plans are directly placed into the SQL plan baseline without being verified.CThe new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.DThe optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
单选题You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）AIt will create the tablespace TEMP1 in group G1.BIt will create the tablespace TEMP1 in group G3.CIt will not add the tablespace TEMP1 to any group.DIt will create the tablespace TEMP1 in the default group.
多选题Which of the following Scheduler elements encourage object reuse?（）ASchedule objectsBProgram argumentsCJob classesDJob argumentsEAll of the above
单选题The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）ACreate two custom ADDM tasks.BModify the AWR snapshot time interval to two hours.CCreate a new scheduler window for a time period of two hours.DModify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
单选题You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）ACreate both jobs by using events raised by the schedulerBCreate both jobs by using events raised by the applicationCCreate a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the schedulerDCreate a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application
多选题Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）ACursor cacheBStored outlineCSQL Tuning SetDAutomatic Workload Repository (AWR) snapshots
单选题Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL @utlrp.sql What is the significance of executing this script?（）AIt performs parallel recompilation of only the stored PL/SQL code.BIt performs sequential recompilation of only the stored PL/SQL code.CIt performs parallel recompilation of any stored PL/SQL as well as Java code.DIt performs sequential recompilation of any stored PL/SQL as well as Java code.
多选题You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager
单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL@utlu111i.sql Which statement about the execution of this script is true?（）AIt must be executed from the Oracle Database 11g environment.BIt must be executed only after the SYSAUX tablespace has been created.CIt must be executed from the environment of the database that is being upgraded.DIt must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.EIt must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
单选题You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）AOne of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.BOne of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.CBoth the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.DNone of the tables are recovered from the Recycle Bin, and the statement returns an error.
多选题You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）Athe SQL text SQLBthe execution planCthe execution contextDthe execution frequencyEthe system change number (SCN)
多选题Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks?（）ADefine the POWER option while adding or removing the disksBIncrease the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.CIncrease the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSESDIncrease the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
单选题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?（）A2, 4, 3B1, 4, 3, 2C2, 5, 4, 3, 6D5, 2, 4, 3, 6E1, 5, 4, 3, 6, 2
单选题Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?（）Aonly encryption and compression settings for all SecureFile LOBsBonly encryption and deduplication settings for only SecureFile CLOBsCdeduplication, encryption, and compression settings for all SecureFile LOBsDdeduplication, encryption, and compression settings only for SecureFile CLOBs
多选题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.