单项选择题
A. Add a finding directive for the ADDM task.
B. Add a segment directive for the ADDM task.
C. Add a parameter directive for the ADDM task.
D. Disable the Segment Advisor from the Automatic Maintenance Task.
单项选择题 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?()
单项选择题 Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery,you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()
多项选择题 Whichtwostatementsaretrueregardinghotpatching?()