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.
正确答案
答案解析
相似试题
(单选题)
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()