网友您好, 请在下方输入框内输入要搜索的题目:
ViewtheExhibitandexaminetheparameters.UserAexecutesthefollowingcommandtoupdatetheTRANStable:SQL>UPDATEB.transSETtr_amt=tr_amt+500WHEREc_code=’C005’;BeforeuserAissuesaCOMMITorROLLBACKcommand,userBexecutesthefollowingcommandontheTRANStable:SQL>ALTERTABLEtransMODIFY(tr_typeVARCHAR2(3));Whatwouldhappeninthisscenario()
A.TheALTERTABLEcommandmodifiesthecolumnsuccessfully.
B.TheDDLoperationgetshigherpriorityandtransactionforuserAisrolledback.
C.TheALTERTABLEcommandwaitsindefinitelyuntiluserAendsthetransaction.
D.TheALTERTABLEcommandfailsafterwaitingfor60secondsduetotheresourcebeingbusy
参考答案