AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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:
CREATE TABLE purchas_interval
PARTITION BY RANGE (time_id)
INTERVAL (NUMTOYMINTERVAL(1 ,'month1)) STORE IN (tbs1 ,tbs2,tbs3)
PARTITION p1 VALUES LESS THAN(TO_DATE('1-1-2005I, 'dd-mm-yyyy')), PARTITION p2 VALUES LESS THAN(TO_DATE('1-1-2007', 'dd-mm-yyyy'))) AS
SELECT *
FROM purchases
WHERE time_id < TO_DATE('1-1-2007'l'dd-mm-yyyy'); What is the outcome of the above 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
Explanation


Question ID 1826

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.

SQL> VAR tname VARCHAR2(60);
SQL> BEGIN
:tname := lmy_instance_analysis_mode_task,;
DBMS_ADDM .INSERT_SEGMENT_DIRECTIVE(:tname ,lSg_directivel ,'SCOTT1); END; Which statement describes the consequence?
 

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
Explanation

Send email to admin@getfreedumps for new dumps request!!!