网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
WhichstatementistrueaboutloadingdatausingtheconventionalpathofSQL*Loader()
A.Redoisnotgeneratedwhileperformingconventionalpathloads.
B.OnlyPRIMARYKEY,UNIQUEKEY,andNOTNULLconstraintsarechecked.
C.Noexclusivelocksareacquiredwhentheconventionalpathloadsareperformed.
D.Insteadofperformingtransactions,SQL*Loaderdirectlywritesdatablockstothedatafiles.
E.INSERTtriggersaredisabledbeforetheconventionalpathloadandreenabledattheendoftheload
参考答案
更多 “ WhichstatementistrueaboutloadingdatausingtheconventionalpathofSQL*Loader() A.Redoisnotgeneratedwhileperformingconventionalpathloads.B.OnlyPRIMARYKEY,UNIQUEKEY,andNOTNULLconstraintsarechecked.C.Noexclusivelocksareacquiredwhentheconventionalpathloadsareperformed.D.Insteadofperformingtransactions,SQL*Loaderdirectlywritesdatablockstothedatafiles.E.INSERTtriggersaredisabledbeforetheconventionalpathloadandreenabledattheendoftheload ” 相关考题
考题
ExaminethefollowingstatementthatisusedtomodifytheprimarykeyconstraintontheSALEStable:SQLALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE;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.
考题
ForwhichtwotaskswoulditbebestNOTtousetheutilitySQL*Loader?()
A.Whenloadingselectedrowsintoeachtable.B.Whenloadingdatafromanexportdumpfile.C.Whenloadingdatafromdisk,tape,ornamedpipes.D.WhenyourdataisNOTbeinginsertedfromaflatfile.E.Whenusingarecordmanagementsystemtoaccessdatafiles.
热门标签
最新试卷