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

题目内容 (请给出正确答案)
ExaminethefollowingstatementthatisusedtomodifytheconstraintontheSALEStable:SQL>ALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE;Whichthreestatementsaretrueregardingtheabovecommand()

A.Theconstraintremainsvalid.

B.Theindexontheconstraintisdropped.

C.ItallowstheloadingofdataintothetableusingSQL*Loader.

D.Newdataconformstotheconstraint,butexistingdataisnotchecked

E.ItallowsthedatamanipulationonthetableusingINSERT/UPDATE/DELETESQLstatements.


参考答案

更多 “ ExaminethefollowingstatementthatisusedtomodifytheconstraintontheSALEStable:SQLALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE;Whichthreestatementsaretrueregardingtheabovecommand() A.Theconstraintremainsvalid.B.Theindexontheconstraintisdropped.C.ItallowstheloadingofdataintothetableusingSQL*Loader.D.Newdataconformstotheconstraint,butexistingdataisnotcheckedE.ItallowsthedatamanipulationonthetableusingINSERT/UPDATE/DELETESQLstatements. ” 相关考题
考题 ExaminethefollowingstatementthatisusedtomodifytheprimarykeyconstraintontheSALEStable:SQLALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE;Whichthreestatementsaretrueregardingtheabovecommand() A.Theconstraintremainsvalid.B.Theindexontheconstraintisdropped.C.ItallowstheloadingofdataintothetableusingSQL*Loader.D.Newdataconformstotheconstraint,butexistingdataisnotchecked.E.ItallowsthedatamanipulationonthetableusingINSERT/UPDATE/DELETESQLstatements.