单选题
A It remains valid.
B It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
C It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
D It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
正确答案
答案解析
略
相似试题
These are points that describe the contents of different memory components: 1: Descriptive information or metadata about schema objects that are queried by using SQL statements 2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements 3: Results of SQL queries and PL/SQL functions 4: Executable forms of SQL cursors, PL/SQL programs, and Java classes 5: The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in theShared Poolif the necessary configurations are done（）
单选题查看答案
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？（）
单选题查看答案
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？（）
单选题查看答案
Given： What creates the appropriate DateFormat object and adds a day to the Date object？（）
单选题查看答案
Click the Exhibit button. Given： ClassA a = new ClassA（）； a.methodA（）； What is the result？（）
单选题查看答案
You need to rename a data file of a tablespace. How would you perform this？（）
单选题查看答案
Which method could be utilized to identify both DML operations and the SQL statements needed to undo those operations for a specific schema owner？（）
多选题查看答案
Given： Which code， inserted at line 16， correctly retrieves a local instance of a Point object？（）
单选题查看答案
Given： Which code， inserted at line 16， correctly retrieves a local instance of a Point object？（）
单选题查看答案