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

题目内容 （请给出正确答案）

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.

参考答案

更多 “ UserAexecutesthefollowingcommandtoupdatetheTRANStable）SQLUPDATEB.transSETtr_amt=tr_amt+500WHEREc_code=’C005’；BeforeuserAissuesaCOMMITorROLLBACKcommand，userBexecutesthefollowingcommandontheTRANStable：SQlALTERTABLEtransMODIFY（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
查看答案
热门标签
最新试卷