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.