READ Free Dumps For Oracle- 1z0-050
| Question ID 5979 | 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 | It returns an error because the range partitions P1 and P2 should be of the same range. |
| Option B | It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions. |
| Option 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 | 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 5980 | Examine the following PL/SQL block: DECLARE my_plans plsjnteger; BEGIN My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_Id => ?9twu5t2dn5xd?; END; Which statement is true about the plan being loaded into the SQL plan baseline by the above command? |
| Option A | It is loaded with the FIXED status. |
| Option B | It is loaded with the ACCEPTED status. |
| Option C | It is not loaded with the ENABLED status. |
| Option D | It is not loaded with the ACCEPTED status. |
| Correct Answer | B |