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?
View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the Significance Level threshold type not available in the threshold setting?Exhibit:
When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?
What are the two different types of database duplication? (Choose two.)
Which two statements regarding the Flashback Table feature are correct? (Choose two.)
The INV_HISTORY table is created using the command:The following data has been inserted into the INV_HISTORY table: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?
