网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
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.
热门标签
最新试卷