UserAexecutesthefollowingcommandtoupdatetheTRANStable）SQLUPDATEB.transSETtr_amt=tr_amt+500WHEREc_code=’C005’；BeforeuserAissuesaCOMMITorROLLBACKcommand，userBexecutesthefollowingcommandontheTRANStable：SQlALTERTABLEtransMODIFY（tr_typeVARCHAR2（3））；Whatwouldhappeninthisscenario？（）A.ThetransactionforuserAisrolledback.B.TheALTERTABLEcommandmodifiesthecolumnsuccessfully.C.TheALTERTABLEcommandfailsduetotheresourcebeingbusy.D.TheALTERTABLEcommandwaitsuntiluserAendsthetransaction.

UserAexecutesthefollowingcommandtoupdatetheTRANStable）SQL>UPDATEB.transSETtr_amt=tr_amt+500WHEREc_code=’C005’；BeforeuserAissuesaCOMMITorROLLBACKcommand，userBexecutesthefollowingcommandontheTRANStable：SQl>ALTERTABLEtransMODIFY（tr_typeVARCHAR2（3））；Whatwouldhappeninthisscenario？（）

A.ThetransactionforuserAisrolledback.

B.TheALTERTABLEcommandmodifiesthecolumnsuccessfully.

C.TheALTERTABLEcommandfailsduetotheresourcebeingbusy.

D.TheALTERTABLEcommandwaitsuntiluserAendsthetransaction.

相关考题：

ViewtheExhibitandexaminetheparameters.UserAexecutesthefollowingcommandtoupdatetheTRANStable：SQLUPDATEB.transSETtr_amt=tr_amt+500WHEREc_code=’C005’；BeforeuserAissuesaCOMMITorROLLBACKcommand，userBexecutesthefollowingcommandontheTRANStable：SQLALTERTABLEtransMODIFY（tr_typeVARCHAR2（3））；Whatwouldhappeninthisscenario（）A.TheALTERTABLEcommandmodifiesthecolumnsuccessfully.B.TheDDLoperationgetshigherpriorityandtransactionforuserAisrolledback.C.TheALTERTABLEcommandwaitsindefinitelyuntiluserAendsthetransaction.D.TheALTERTABLEcommandfailsafterwaitingfor60secondsduetotheresourcebeingbusy
查看答案
热门标签