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

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


相关考题:

进出保税区的外国商品是需要缴纳进口税的。() 此题为判断题(对,错)。

猪,4岁,妊娠后期,两后肢站立不稳,交替负重,喜卧,无受伤史:神经反应性基本正常,X线侧位片未见明显异常。对该病的治疗方法是() A.口服泼尼松B.静脉注射葡萄糖C.手术治疗D.静脉注射葡萄糖酸钙E.皮下注射硝酸士的宁

柴油发电机在运行中,出水温度一般应控制在()范围内。 A.50-60℃B.60-70℃C.70-75℃D.75-85℃

YouworkasadatabaseadministratorforSupportcenter.cn.Youreceivedthefollowingerrorwhileworkingonyourdatabase:ORA-01555:snapshottooold,Inwhichsituationwouldyoureceivesuchanerror?() A.Youperformedrollbackaftercommit.B.Ifalogswitchoccursinyourdatabase.C.Thearchiverfailstogenerateanarchivedlogfile.D.Instancerecoveryfailstofindoneoftheredologfiles.E.Along-runningqueryisunabletogetread-consistentimage.F.Ifyouperformmanualundomanagementoperationsinautomode.

颁行《国家通用语言文字法》有什么样的意义?

Y8代产品共同的核心卖点是() A.全线GDDR5显存B.720P摄像头C.全线标清屏D.1TB大容量硬盘