ExaminethefollowingstatementthatisusedtomodifytheprimarykeyconstraintontheSALEStable:SQL>ALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE;Whichthreestatementsaretrueregardingtheabovecommand()A.Theconstraintremainsvalid.B.Theindexontheconstraintisdropped.C
题目
ExaminethefollowingstatementthatisusedtomodifytheprimarykeyconstraintontheSALEStable:SQL>ALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE;Whichthreestatementsaretrueregardingtheabovecommand()
A.Theconstraintremainsvalid.
B.Theindexontheconstraintisdropped.
C.ItallowstheloadingofdataintothetableusingSQL*Loader.
D.Newdataconformstotheconstraint，butexistingdataisnotchecked.
E.ItallowsthedatamanipulationonthetableusingINSERT/UPDATE/DELETESQLstatements.
相似考题
参考答案和解析
参考答案：A, B, C