首页计算机考试Oracle认证
(单选题)

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.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement?()

    答案解析

  • (单选题)

    View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to().

    答案解析

  • (单选题)

    View the Exhibit and examine the output of the query.  What do you infer from this()

    答案解析

  • (单选题)

    View the Exhibit and examine the output of the query.  What do you infer from this()

    答案解析

  • (多选题)

    View the Exhibit and examine the output.  Which two statements are true regarding the LISTENER2 listener()

    答案解析

  • (多选题)

    Exhibit: View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace: SQL> ALTER TABLE trans SHRINK SPACE CASCADE;  Which objects would be affected by this command?()

    答案解析

  • (单选题)

    View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries?  ()

    答案解析

  • (多选题)

    View the Exhibit and examine the output.  Which two statements are true regarding the LISTENER2 listener()

    答案解析

  • (单选题)

    View the Exhibit to examine the output for the CROSSCHECK BACKUP command.  Which statement is trueabout the output of the command()

    答案解析

  • (单选题)

    View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident()

    答案解析

快考试在线搜题