Oracle OCP 1Z0 053 Q224(Interval Partition)
224.You need to create a partitioned table to store historical data and you issued the following command:
CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL
(NUMTOYMINTERVAL(1,'month')) STORE IN (tbs1,tbs2,tbs3) ( PARTITION p1 VALUES LESS
THAN(TO_DATE('1-1-2005', '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','dd-mm-yyyy');
What is the outcome of the above command?
A. It returns an error because the range partitions P1 and P2 should be of the same range.
B. It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
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.
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.
Answer: C
INTERVAL 是11G新增的自動分割槽特性
該語句建立p1、p2兩個分割槽,其後的資料按月自動進行分
參考:http://blog.csdn.net/jgmydsai/article/details/38231135
CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL
(NUMTOYMINTERVAL(1,'month')) STORE IN (tbs1,tbs2,tbs3) ( PARTITION p1 VALUES LESS
THAN(TO_DATE('1-1-2005', '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','dd-mm-yyyy');
What is the outcome of the above command?
A. It returns an error because the range partitions P1 and P2 should be of the same range.
B. It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
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.
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.
Answer: C
INTERVAL 是11G新增的自動分割槽特性
該語句建立p1、p2兩個分割槽,其後的資料按月自動進行分
參考:http://blog.csdn.net/jgmydsai/article/details/38231135
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2073806/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0 053 Q71(ADDM AWR Interval)Oracle
- Oracle OCP 1Z0 053 Q17(Auto Partition 自動分割槽)Oracle
- Oracle OCP 1Z0 053 Q650Oracle
- Oracle OCP 1Z0 053 Q324Oracle
- Oracle OCP 1Z0 053 Q27Oracle
- Oracle OCP 1Z0 053 Q49Oracle
- Oracle OCP 1Z0 053 Q10Oracle
- Oracle OCP 1Z0 053 Q685Oracle
- Oracle OCP 1Z0 053 Q454Oracle
- Oracle OCP 1Z0 053 Q500Oracle
- Oracle OCP 1Z0 053 Q444(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q440(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q601Oracle
- Oracle OCP 1Z0 053 Q472(Locale)Oracle
- Oracle OCP 1Z0 053 Q525(ASM)OracleASM
- Oracle OCP 1Z0 053 Q292(NFS)OracleNFS
- Oracle OCP 1Z0 053 Q538(ASM)OracleASM
- Oracle OCP 1Z0 053 Q416Oracle
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0 053 Q520Oracle
- Oracle OCP 1Z0 053 Q607Oracle
- Oracle OCP 1Z0 053 Q500(Rman)Oracle
- Oracle OCP 1Z0 053 Q707Oracle
- Oracle OCP 1Z0 053 Q28(INCREMENTAL)OracleREM
- Oracle OCP 1Z0 053 Q332Oracle
- Oracle OCP 1Z0 053 Q269Oracle
- Oracle OCP 1Z0 053 Q83(Flashback Database)OracleDatabase
- Oracle OCP 1Z0 053 Q344(V$SESSION)OracleSession
- Oracle OCP 1Z0 053 Q558(V$BACKUP)Oracle
- Oracle OCP 1Z0 053 Q427(Transportable Tablespace)Oracle
- Oracle OCP 1Z0 053 Q182(RMAN)Oracle
- Oracle OCP 1Z0 053 Q428(transport database)OracleDatabase
- Oracle OCP 1Z0 053 Q458(Globalization NLSRTL)Oracle
- Oracle OCP 1Z0 053 Q465(NLS Parameters)Oracle
- Oracle OCP 1Z0 053 Q21(RMAN Duplicate)Oracle
- Oracle OCP 1Z0 053 Q600(RMAN BACKUP)Oracle
- Oracle OCP 1Z0 053 Q114Oracle
- Oracle OCP 1Z0 053 Q700(RMAN Duplicate)Oracle