网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

EvaluatethefollowingSQLstatementusedtocreatethePRODUCTStable：CREATETABLEproducts（product_idNUMBER（3）PRIMARYKEY，product_descVARCHAR2（25），qtyNUMBER（8，2），rateNUMBER（10，2），total_valueAS（qty*rate））PARTITIONBYRANGE（total_value）（PARTITIONp1VALUESLESSTHAN（100000），PARTITIONp2VALUESLESSTHAN（150000），PARTITIONp3VALUESLESSTHAN（MAXVALUE））COMPRESSFORALLOPERATIONS；Whichstatementistrueregardingthiscommand？（）

A.Itexecutessuccessfullybutpartitionpruningcannothappenforthispartitionkey.

B.ItproducesanerrorbecausetheTOTAL_VALUEcolumncannotbeusedasapartitionkey.

C.ItproducesanerrorbecausecompressioncannotbeusedfortheTOTAL_VALUEpartitionkey.

D.ItexecutessuccessfullybutthevaluesintheTOTAL_VALUEcolumnwouldnotbephysically storedinthepartitions.

参考答案

更多 “ EvaluatethefollowingSQLstatementusedtocreatethePRODUCTStable：CREATETABLEproducts（product_idNUMBER（3）PRIMARYKEY，product_descVARCHAR2（25），qtyNUMBER（8，2），rateNUMBER（10，2），total_valueAS（qty*rate））PARTITIONBYRANGE（total_value）（PARTITIONp1VALUESLESSTHAN（100000），PARTITIONp2VALUESLESSTHAN（150000），PARTITIONp3VALUESLESSTHAN（MAXVALUE））COMPRESSFORALLOPERATIONS；Whichstatementistrueregardingthiscommand？（）A.Itexecutessuccessfullybutpartitionpruningcannothappenforthispartitionkey.B.ItproducesanerrorbecausetheTOTAL_VALUEcolumncannotbeusedasapartitionkey.C.ItproducesanerrorbecausecompressioncannotbeusedfortheTOTAL_VALUEpartitionkey.D.ItexecutessuccessfullybutthevaluesintheTOTAL_VALUEcolumnwouldnotbephysically storedinthepartitions. ” 相关考题
考题 Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?() A. It executes successfully but partition pruning cannot happen for this partition key.B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
查看答案
考题 EvaluatetheCREATETABLEstatement:CREATETABLEproducts(product_idNUMBER(6)CONSTRAINTprod_id_pkPRIMARYKEY,product_nameVARCHAR2(15));WhichstatementistrueregardingthePROD_ID_PKconstraint?() A.Itwouldbecreatedonlyifauniqueindexismanuallycreatedfirst.B.Itwouldbecreatedandwoulduseanautomaticallycreateduniqueindex.C.Itwouldbecreatedandwoulduseanautomaticallycreatednonuniqueindex.D.Itwouldbecreatedandremainsinadisabledstatebecausenoindexisspecifiedinthecommand.
查看答案
热门标签
最新试卷