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.