单选题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 accep

题目
单选题
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.

相似考题

1.多选题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.

2.多选题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.

3.多选题Identify three key features of ASM.（）Afile stripingBallocation unit mirroringCautomatic disk rebalancingDautomatic file size incrementEautomatic undo management

4.多选题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

更多“Which statement describes the effect of the execution of the”相关问题

  • 第1题：

    单选题
    Which statement is true regarding virtual private catalogs? （）
    A

    A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script. 

    B

    The virtual private catalog owner cannot create and modify the stored scripts. 

    C

    The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner. 

    D

    To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database. 


    正确答案： A
    解析： 暂无解析

  • 第2题：

    单选题
    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?（）
    A

    Complete Recovery with online redo log

    B

    Complete Recovery with archived redo log

    C

    Tablespace Point-in-Time Recovery (TSPITR)

    D

    Incomplete Recovery with system change number (SCN)


    正确答案： D
    解析： 暂无解析

  • 第3题：

    单选题
    Which of the following is not a valid linguistic sort element?（）
    A

    Accent expansion

    B

    Canonical equivalence

    C

    Reverse secondary sorting

    D

    Ignorable characters

    E

    Character rearrangement


    正确答案： A
    解析： 暂无解析

  • 第4题：

    单选题
    Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?（）
    A

    All objects in the database

    B

    Tables owned by SYS and SYSTEM

    C

    Data dictionary tables

    D

    NCHAR columns

    E

    CHAR columns


    正确答案： B
    解析： 暂无解析

  • 第5题：

    单选题
    What is the proper command to shut down the database in a consistent manner?（）
    A

    shutdown abort 

    B

    shutdown kill 

    C

    Shutdown nowait 

    D

    shutdown immediate

    E

    shutdown halt


    正确答案： B
    解析： 暂无解析

  • 第6题：

    单选题
    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?（）
    A

    It will create the tablespace TEMP1 in group G1.

    B

    It will create the tablespace TEMP1 in group G3.

    C

    It will not add the tablespace TEMP1 to any group.

    D

    It will create the tablespace TEMP1 in the default group.


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    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?（）
    A

    Create two custom ADDM tasks.

    B

    Modify the AWR snapshot time interval to two hours.

    C

    Create a new scheduler window for a time period of two hours.

    D

    Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.


    正确答案： D
    解析： 暂无解析

  • 第8题：

    多选题
    Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）
    A

    Cursor cache

    B

    Stored outline

    C

    SQL Tuning Set

    D

    Automatic Workload Repository (AWR) snapshots


    正确答案： D,A
    解析： 暂无解析

  • 第9题：

    多选题
    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?（）
    A

    Backup compression should be enabled

    B

    Parallelism for the channel should be set to 2

    C

    All the files must be backed up as backup sets

    D

    The backup may be stored either on disk or on media with media manager


    正确答案： C,B
    解析： 暂无解析

  • 第10题：

    单选题
    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?（）
    A

    One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.

    B

    One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.

    C

    Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.

    D

    None of the tables are recovered from the Recycle Bin, and the statement returns an error.


    正确答案： A
    解析： 暂无解析

  • 第11题：

    多选题
    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?（）
    A

    Define the POWER option while adding or removing the disks

    B

    Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.

    C

    Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES

    D

    Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES


    正确答案： C,D
    解析： 暂无解析

  • 第12题：

    单选题
    Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?（）
    A

    only encryption and compression settings for all SecureFile LOBs

    B

    only encryption and deduplication settings for only SecureFile CLOBs

    C

    deduplication, encryption, and compression settings for all SecureFile LOBs

    D

    deduplication, encryption, and compression settings only for SecureFile CLOBs


    正确答案： A
    解析： 暂无解析

  • 第13题：

    多选题
    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?（）
    A

    The database must have multiplexed redo log files

    B

    The database must be in the MOUNT state to execute the command

    C

    The database must be in the NOMOUNT state to execute the command

    D

    The database must be opened in RESTRICTED mode before this operation

    E

    The database must be opened with the RESETLOGS option after the flashback operation


    正确答案： B,C
    解析： 暂无解析

  • 第14题：

    单选题
    How is block-change tracking enabled?（）
    A

    With alter database enable block change tracking

    B

    With alter system enable block change tracking 

    C

    With an init.ora parameter change 

    D

    With an spfile parameter change 


    正确答案： A
    解析： 暂无解析

  • 第15题：

    单选题
    Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）
    A

    alter tablespace DAVE_TBS backup mode

    B

    alter tablespace DAVE_TBS start backup 

    C

    alter tablespace DAVE_TBS begin backup 

    D

    alter tablespace DAVE_TBS backup begin 

    E

    alter tablespace DAVE_TBS backup


    正确答案： B
    解析： 暂无解析

  • 第16题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第17题：

    多选题
    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?（）
    A

    The plan baselines can be evolved over time to produce better performance.

    B

    The newly generated plans are directly placed into the SQL plan baseline without being verified.

    C

    The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

    D

    The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.


    正确答案： C,A
    解析： 暂无解析

  • 第18题：

    多选题
    Which of the following Scheduler elements encourage object reuse?（）
    A

    Schedule objects

    B

    Program arguments

    C

    Job classes

    D

    Job arguments

    E

    All of the above


    正确答案： C,A
    解析： 暂无解析

  • 第19题：

    单选题
    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?（）
    A

    Create both jobs by using events raised by the scheduler

    B

    Create both jobs by using events raised by the application

    C

    Create 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 scheduler

    D

    Create 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


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    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?（）
    A

    It performs parallel recompilation of only the stored PL/SQL code.

    B

    It performs sequential recompilation of only the stored PL/SQL code.

    C

    It performs parallel recompilation of any stored PL/SQL as well as Java code.

    D

    It performs sequential recompilation of any stored PL/SQL as well as Java code.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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?（）
    A

    It must be executed from the Oracle Database 11g environment.

    B

    It must be executed only after the SYSAUX tablespace has been created.

    C

    It must be executed from the environment of the database that is being upgraded.

    D

    It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

    E

    It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    多选题
    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?（）
    A

    the SQL text SQL

    B

    the execution plan

    C

    the execution context

    D

    the execution frequency

    E

    the system change number (SCN)


    正确答案： E,C
    解析： 暂无解析

  • 第23题：

    单选题
    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, 3

    B

    1, 4, 3, 2

    C

    2, 5, 4, 3, 6

    D

    5, 2, 4, 3, 6

    E

    1, 5, 4, 3, 6, 2


    正确答案： D
    解析： 暂无解析

  • 第24题：

    多选题
    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?（）
    A

    The optimizer adds the new plan to the plan history.

    B

    The optimizer selects the new plan for the execution of the SQL statement.

    C

    The optimizer adds the new plan to the SQL plan baseline as an accepted plan.

    D

    The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.

    E

    The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.


    正确答案： E,A
    解析： 暂无解析

相关内容