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.皮下注射硝酸士的宁
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大容量硬盘