TBS2

题目

TBS2

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

单选题

The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）

A

The materialized view should have a complete refresh performed after the online table redefinition is completed.

B

The materialized view should have a fast refresh performed after the online table redefinition is completed.

C

The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.

D

The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.

正确答案： C

解析：暂无解析

第2题：

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.

正确答案:C

第3题：

Youneedtocreateapartitionedtabletostorehistoricaldataandyouissuedthefollowingcommand：CREATETABLEpurchase_intervalPARTITIONBYRANGE（time_id）INTERVAL（NUMTOYMINTERVAL（1，’month’））STOREIN（tbs1，tbs2，tbs3）（PARTITIONp1VALUESLESSTHAN（TO_DATE（’1-1-2005’，’dd-mm-yyyy’）），PARTITIONp2VALUESLESSTHAN（TO_DATE（’1-1-2007’，’dd-mm-yyyy’）））ASSELECT*FROMpurchasesWHEREtime_id<TO_DATE（’1-1-2007’，’dd-mm-yyyy’）；Whatistheoutcomeoftheabovecommand？（）

A.ItreturnsanerrorbecausetherangepartitionsP1andP2shouldbeofthesamerange.

B.Itcreatestworangepartitions（P1，P2）.Withineachrangepartition，itcreatesmonthwisesubpartitions.

C.Itcreatestworangepartitionsofvaryingrange.Fordatabeyond’1-1-2007，’itcreatespartitionswithawidthofonemontheach.

D.Itreturnsanerrorbecausethenumberoftablespaces（TBS1，TBS2，TBS3）specifieddoesnotmatchthenumberofrangepartitions（P1，P2）specified.

参考答案：C

题目

相似问题和答案

相关内容