READ Free Dumps For Oracle- 1z0-050
Question ID 1825 | You need to create a partitioned table to store historical data and you Issued the following command: |
Option A | A. It returns an error because the range partitions P1 and P2 should be of the same range. |
Option B | B. It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
|
Option C | C. It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of |_| one month each
|
Option D | D. It returns an error because the number of tablespaces (TBS1 ,TBS2,TBS3)specified does not match the number of range partitions (P1 ,P2) specified |
Correct Answer | C |
Question ID 1826 | View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. SQL> VAR tname VARCHAR2(60); |
Option A | A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema. |
Option B | B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only. |
Option C | C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state. |
Option D | D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.C |
Correct Answer | C |