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

题目内容 (请给出正确答案)
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 ” 相关考题
考题 Loader组件是一个可滚动的单选或多选列表框。() 此题为判断题(对,错)。

考题 在Oracle中,以下工具可以逻辑备份数据库对象或整个数据库()。 A.SQL*PlusB.导出实用程序C.导入实用程序D.SQL*Loader

考题 嵌入式Linux的boo1loader开发板上电和复位后运行的第一个程序。() 此题为判断题(对,错)。

考题 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.

考题 IMPORT和SQL*LOADER 这2个工具的不同点

考题 ForwhichtwotaskswoulditbebestNOTtousetheutilitySQL*Loader?() A.Whenloadingselectedrowsintoeachtable.B.Whenloadingdatafromanexportdumpfile.C.Whenloadingdatafromdisk,tape,ornamedpipes.D.WhenyourdataisNOTbeinginsertedfromaflatfile.E.Whenusingarecordmanagementsystemtoaccessdatafiles.