WhichstatementistrueaboutloadingdatausingtheconventionalpathofSQL*Loader()A.Redoisnotgeneratedwhileperformingconventionalpathloads.B.OnlyPRIMARYKEY，UNIQUEKEY，andNOTNULLconstraintsarechecked.C.Noexclusivelocksareacquiredwhentheconventionalpathloadsareperfo

题目
WhichstatementistrueaboutloadingdatausingtheconventionalpathofSQL*Loader()

A.Redoisnotgeneratedwhileperformingconventionalpathloads.

B.OnlyPRIMARYKEY，UNIQUEKEY，andNOTNULLconstraintsarechecked.

C.Noexclusivelocksareacquiredwhentheconventionalpathloadsareperformed.

D.Insteadofperformingtransactions，SQL*Loaderdirectlywritesdatablockstothedatafiles.

E.INSERTtriggersaredisabledbeforetheconventionalpathloadandreenabledattheendoftheload

相似考题

1.Loader组件是一个可滚动的单选或多选列表框。()此题为判断题(对，错)。

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

3.ExaminethefollowingstatementthatisusedtomodifytheprimarykeyconstraintontheSALEStable:SQL>ALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE;Whichthreestatementsaretrueregardingtheabovecommand()A.Theconstraintremainsvalid.B.Theindexontheconstraintisdropped.C.ItallowstheloadingofdataintothetableusingSQL*Loader.D.Newdataconformstotheconstraint，butexistingdataisnotchecked.E.ItallowsthedatamanipulationonthetableusingINSERT/UPDATE/DELETESQLstatements.

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

更多“WhichstatementistrueaboutloadingdatausingtheconventionalpathofSQL*Loader() ”相关问题

  • 第1题：

    ExaminethefollowingstatementthatisusedtomodifytheconstraintontheSALEStable:SQL>ALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE;Whichthreestatementsaretrueregardingtheabovecommand()

    A.Theconstraintremainsvalid.

    B.Theindexontheconstraintisdropped.

    C.ItallowstheloadingofdataintothetableusingSQL*Loader.

    D.Newdataconformstotheconstraint，butexistingdataisnotchecked

    E.ItallowsthedatamanipulationonthetableusingINSERT/UPDATE/DELETESQLstatements.


    参考答案：A, B, C

  • 第2题：

    ForwhichtwotaskswoulditbebestNOTtousetheutilitySQL*Loader?()

    A.Whenloadingselectedrowsintoeachtable.

    B.Whenloadingdatafromanexportdumpfile.

    C.Whenloadingdatafromdisk，tape，ornamedpipes.

    D.WhenyourdataisNOTbeinginsertedfromaflatfile.

    E.Whenusingarecordmanagementsystemtoaccessdatafiles.


    参考答案：B, D

  • 第3题：

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


    正确答案：
     

相关内容