Oracle OCP 1Z0-053 (System Partitioning)
245.Which statements are true regarding system-partitioned tables? (Choose all that apply.)
A. Only a single partitioning key column can be specified.
B. All DML statements must use partition-extended syntax.
C. The same physical attributes must be specified for each partition.
D. Unique local indexes cannot be created on a system-partitioned table.
E. Traditional partition pruning and partitionwise joins are not supported on these tables.
Answer: DE
參考:http://blog.csdn.net/rlhua/article/details/17008263
http://docs.oracle.com/cd/E11882_01/appdev.112/e10765/dom_idx.htm#ADDCI4490
A. Only a single partitioning key column can be specified.
B. All DML statements must use partition-extended syntax.
C. The same physical attributes must be specified for each partition.
D. Unique local indexes cannot be created on a system-partitioned table.
E. Traditional partition pruning and partitionwise joins are not supported on these tables.
Answer: DE
參考:http://blog.csdn.net/rlhua/article/details/17008263
http://docs.oracle.com/cd/E11882_01/appdev.112/e10765/dom_idx.htm#ADDCI4490
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2072179/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Partitioning(轉)Oracle
- Oracle OCP(56)Oracle
- Oracle OCP(23):序列Oracle
- Oracle OCP(29):PROFILEOracle
- Oracle OCP(54):EXPOracle
- Oracle OCP(54):IMPOracle
- Oracle OCP(57):IMPDPOracle
- Oracle OCP(44):LSNRCTLOracle
- Oracle OCP(28):USEROracle
- Oracle OCP(25):索引Oracle索引
- Oracle OCP(30):ROLEOracle
- [20190805]Oracle 12c New Feature – Online Partitioning.txtOracle
- Oracle OCP(33):官方文件Oracle
- Oracle OCP(20):建立表Oracle
- Oracle OCP(21):管理表Oracle
- Oracle OCP(12):ROLLUP & CUBEOracle
- Oracle OCP(48):UNDO TABLESPACEOracle
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- Oracle OCP(24):檢視Oracle
- Oracle OCP(26):其它ObjectOracleObject
- Oracle OCP(32):SUPPORT:MOSOracle
- Oracle OCP(35):Database 安裝OracleDatabase
- Oracle OCP(36):DBCA建庫Oracle
- Oracle OCP(04):聚合函式Oracle函式
- Oracle OCP(43):listener.oraOracle
- Oracle OCP(40):程式結構Oracle
- Oracle OCP(18):命名規則Oracle
- Oracle OCP(60):RMAN 備份Oracle
- Oracle OCP(45):sqlnet.oraOracleSQL
- Oracle OCP(45):TNSNAMES.oraOracle
- Oracle OCP(62):熱備份Oracle
- Oracle OCP(60):冷備份Oracle
- Oracle OCP和MySQL OCP認證考試內容有哪些?OracleMySql
- Oracle OCP(02):條件和排序Oracle排序
- Oracle OCP(41):邏輯結構Oracle
- Oracle OCP(38):Database 物理結構OracleDatabase
- Oracle OCP(15):分層檢索Oracle
- Oracle OCP(19):資料型別Oracle資料型別
- Oracle OCP(08):使用子查詢Oracle