EvaluatetheCREATETABLEstatement:CREATETABLEproducts(product_idNUMBER(6)CONSTRAINTprod_id_pkPRIMARYKEY,product_nameVARCHAR2(15));WhichstatementistrueregardingthePROD_ID_PKconstraint?() A.Itwouldbecreatedonlyifauniqueindexismanuallycreatedfirst.B.Itwouldbecreatedandwoulduseanautomaticallycreateduniqueindex.C.Itwouldbecreatedandwoulduseanautomaticallycreatednonuniqueindex.D.Itwouldbecreatedandremainsinadisabledstatebecausenoindexisspecifiedinthecommand.
EvaluatetheCREATETABLEstatement:CREATETABLEproducts(product_idNUMBER(6)CONSTRAINTprod_id_pkPRIMARYKEY,product_nameVARCHAR2(15));WhichstatementistrueregardingthePROD_ID_PKconstraint?()
A.Itwouldbecreatedonlyifauniqueindexismanuallycreatedfirst.
B.Itwouldbecreatedandwoulduseanautomaticallycreateduniqueindex.
C.Itwouldbecreatedandwoulduseanautomaticallycreatednonuniqueindex.
D.Itwouldbecreatedandremainsinadisabledstatebecausenoindexisspecifiedinthecommand.
相关考题：
The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? （）A. The results are not sorted.B. The results are sorted numerically.C. The results are sorted alphabetically.D. The results are sorted numerically and then alphabetically.
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.
若将文本字符串“15”、“8”、“6”按降序排序，则排序的结果为( )。A．“15”、 “8”、 “6”B．“6”、 “8”、 “15'’C．“8”、 “6”、 “15”D．“8”、 “15”、 “6”
设X~N(9,32),Y~N(5,0.52),则有________成立。A．P(6X≤15)P(4.5Y≤6)B．P(6X≤15)P(4.5Y≤6)C．P(6X≤15)=P(4.5Y≤6)D．P(6X≤15)2P(4.5Y≤6)
22碳6烯酸（DHA）正确写法是A．22:6△3,6,9,12,15,18B．22:6△6,9,12,15,18,21C．22:6ω3,6,9,12,15,18D．22:6ω6,9,12,15,18,21
22碳6烯酸（DHA）正确写法是A．22:6ω3,6,9,12,15,18B．22:6△3,6,9,12,15,18C．22:6△3,6,9,12,15,18D．22:6ω6,9,12,15,18,21