（单选题）
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition？（）
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？（）
