单项选择题 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？（）

单项选择题 You create a new Automatic Database Diagnostic Monitor （ADDM） task：  instance_analysis_mode_task. To view the ADDM report， you use the following command：   SQL> SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual；   You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments.  What would you do to achieve this？（）

单项选择题 The INV_HISTORY table is created using the command：   SQL>CREATE TABLE INV_HISTORY （inv_no NUMBER（3）， inv_date DATE， inv_amt NUMBER（10，2）） partition by range （inv_date） interval （numtoyminterval（1，’month’）） （partition p0  values less than （to_date（’01-01-2005’，’dd-mm-yyyy’））， partition p1 values less than （to_date（’01-01-2006’，’dd-mm-yyyy’）））；   The following data has been inserted into the INV_HISTORY table ：   INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000   You would like to store the data belonging to the year 2006 in a single partition and issue the command：   SQL> ALTER TABLE inv_history MERGE PARTITIONS  FOR（TO_DATE（’15-feb-2006’，’dd-mon-yyyy’））， FOR（TO_DATE（’15-apr-2006’）） INTO PARTITION sys_py；  What would be the outcome of this command？（）