单选题Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   Which statement describes the effect of the execution of the above P

题目
单选题
Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   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.Examine the following set of RMAN commands:Which statement is true when the RMAN RUN block Is executed?()A. The execution of the script fails because multiple channels cannot coexist.B. The script is executed and both the channels are used for the script execution.C. The new channel, CHI, is Ignored because a channel has been configured already.D. ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.

2.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.

3.Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）A.B.C.D.

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?（）A.Every SQL statement in the STS is considered only once for executionB.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC.The execution plan and execution statistics are computed for each SQL statement in the STSD.The effects of DDL and DML are considered to produce the execution plan and execution statistics

更多“单选题Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   Which statement describes the effect of the execution of the above P”相关问题

  • 第1题：

    ExaminethefollowingPL/SQLblock：SETSERVEROUTPUTONSETLONG10000ECLAREreportclob；BEGINreport：=DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）；DBMS_OUTPUT.PUT_LINE（report）；END；WhichstatementdescribestheeffectoftheexecutionoftheabovePL/SQLblock？（）

    A.TheplanbaselinesareverifiedwiththeSQLprofiles.

    B.Allfixedplanbaselinesareconvertedintononfixedplanbaselines.

    C.AllthenonacceptedSQLprofilesareacceptedintotheplanbaseline.

    D.ThenonacceptedplansintheSQLManagementBaseareverifiedwiththeexistingplanbaselines.


    参考答案：D

  • 第2题：

    Whichbuilt－inwouldyoureferenceinyourtriggercodetoremoveareportfromtheReportsServerqueuedynamically?()

    A.FIND_REPORT_OBJECT

    B.CANCEL_REPORT_OBJECT

    C.REPORT_OBJECT_STATUS

    D.SET_PROPERTYOBJECT_PROPERTY


    参考答案：B

  • 第3题：

    Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）

    • A、SRW.BREAK 
    • B、SRW.SET_ALTER 
    • C、SRW.REFERENCE 
    • D、SRW.DO_SQL 
    • E、SRW.RUN_REPORT
    • F、SRW.SET_FIELD

    正确答案:D

  • 第4题：

    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）

    • A、Execute the query and view Active Session History (ASH) for information about the query.
    • B、Enable SQL trace for the query.
    • C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
    • D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

    正确答案:C

  • 第5题：

    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？（）

    • A、 Every SQL statement in the STS is considered only once for execution.
    • B、 The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
    • C、 The execution plan and execution statistics are computed for each SQL statement in the STS. 
    • D、 The effects of DDL and DML are considered to produce the execution plan and execution statistics.

    正确答案:A,C

  • 第6题：

    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?（）

    • A、Every SQL statement in the STS is considered only once for execution
    • B、The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
    • C、The execution plan and execution statistics are computed for each SQL statement in the STS
    • D、The effects of DDL and DML are considered to produce the execution plan and execution statistics

    正确答案:A,C

  • 第7题：

    Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   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.

    正确答案:D

  • 第8题：

    Which built-in would you reference in your trigger code to remove a report from the Reports Server queue dynamically?（）

    • A、FIND_REPORT_OBJECT 
    • B、CANCEL_REPORT_OBJECT 
    • C、REPORT_OBJECT_STATUS 
    • D、SET_PROPERTY OBJECT_PROPERTY

    正确答案:B

  • 第9题：

    单选题
    Examine the following PL/SQL block：   DECLARE   my_plans pls_integer； BEGIN  my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id=> ？9twu5t2dn5xd？； END；   Which statement is true about the plan being loaded into the SQL plan baseline by the above command？（）
    A

     It is loaded with the FIXED status.

    B

     It is loaded with the ACCEPTED status.

    C

     It is not loaded with the ENABLED status.

    D

     It is not loaded with the ACCEPTED status.


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

  • 第10题：

    单选题
    Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）
    A

    SRW.BREAK 

    B

    SRW.SET_ALTER 

    C

    SRW.REFERENCE 

    D

    SRW.DO_SQL 

    E

    SRW.RUN_REPORT

    F

    SRW.SET_FIELD


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

  • 第11题：

    单选题
    Which of the following commands will fail？（）
    A

     report schema

    B

     report need backup

    C

     report need backup days 3

    D

     report user

    E

     report obsolete


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

  • 第12题：

    单选题
    The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:（）
    A

    2，4，5

    B

    2，1，4，3，5

    C

    1，2，3，4，5

    D

    1，2，4，5


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

  • 第13题：

    YouneedtocreateatriggertolocatetheProductreportintheRpt_Server,runthereport,andtestthestatusofthereport.Whichthreebuilt－inswouldyouusetoaccomplishthistask?()

    A.RUN_PRODUCT

    B.SET_REPORT_OBJECT_PROPERTY

    C.RUN_REPORT_OBJECT

    D.FIND_REPORT_OBJECT

    E.REPORT_OBJECT_STATUS

    F.COPY_REPORT_OBJECT_OUTPUT


    参考答案：C, D, E

  • 第14题：

    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）

    A. Execute the query and view Active Session History (ASH) for information about the query.

    B. Enable SQL trace for the query.

    C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

    D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.


    参考答案：C

  • 第15题：

    报表的打印输出命令是（）.

    • A、REPORT FORM
    • B、MODI REPORT
    • C、SET REPORT
    • D、CREATE REPORT

    正确答案:A

  • 第16题：

    Examine the following PL/SQL block：   DECLARE   my_plans pls_integer； BEGIN  my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id=> ？9twu5t2dn5xd？； END；   Which statement is true about the plan being loaded into the SQL plan baseline by the above command？（）

    • A、 It is loaded with the FIXED status.
    • B、 It is loaded with the ACCEPTED status.
    • C、 It is not loaded with the ENABLED status.
    • D、 It is not loaded with the ACCEPTED status.

    正确答案:B

  • 第17题：

    Which of the following commands will fail？（）  

    • A、 report schema
    • B、 report need backup
    • C、 report need backup days 3
    • D、 report user
    • E、 report obsolete

    正确答案:D

  • 第18题：

    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.

    正确答案:D

  • 第19题：

    Examine the command：  SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）

    • A、Automatic statistics collection is stopped for the CUSTOMERS table.
    • B、Statistics for the CUSTOMERS table are locked and cannot be overwritten.
    • C、Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
    • D、Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.

    正确答案:D

  • 第20题：

    单选题
    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）
    A

    Execute the query and view Active Session History (ASH) for information about the query.

    B

    Enable SQL trace for the query.

    C

    Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

    D

    Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.


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

  • 第21题：

    单选题
    Examine the command：  SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）
    A

    Automatic statistics collection is stopped for the CUSTOMERS table.

    B

    Statistics for the CUSTOMERS table are locked and cannot be overwritten.

    C

    Existing statistics for the CUSTOMERS table become unusable for the query optimizer.

    D

    Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.


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

  • 第22题：

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


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

  • 第23题：

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

    Every SQL statement in the STS is considered only once for execution.

    B

    The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.

    C

    The execution plan and execution statistics are computed for each SQL statement in the STS.

    D

    The effects of DDL and DML are considered to produce the execution plan and execution statistics.


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

相关内容