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.