单项选择题

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.

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

<上一题目录下一题>

热门试题

单项选择题

At5：30PM，adatabaseadministrator，William，isinformedthatanimportantrecordofemployeenoE0025ismissingfromtheSCOTT.EMPLOYEEtable.At4：30P.M，thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion：SELECToperation，undo_sql，logon_userFROMFLASHBACK_TRANSACTION_QUERYWHERExid=HEXTORAW（’0100043E23456’）；where’0100043E23456’isthetransactionIDofthetransactionthatdeletedtherow.Beforeissuingtheabovestatement，whichtaskdidWilliamperformtoidentifythetransactionIDofthetransactionthatdeletedtherow？（）

A.EMPLOYEEtable.At4：30P.M，thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion：

未分类题

YoudeploymobiledevicesthatrunMicrosoftWindowsMobile5.0withMicrosoftMessagingandSecurityFeaturePack.AserverthatrunsMicrosoftExchangeServer2003ServicePack2isconfiguredbyusingthedefaultinstallationsettings.CompanysecuritypolicyrequiresacomplexpasswordforunlockingtheWindowsMobilebaseddevices.YouneedtoensurethattheWindowsMobilebaseddevicesthatperformMicrosoftActiveSyncsynchronizationmeetthecompanysecuritypolicy.Whichtwoactionsshouldyouperform？（）A.EnterallmobiledeviceusersintheExceptionslist.B.EnabletheRequirebothnumbersandlettersoption.C.EnabletheAllowaccesstodevicesthatdonotfullysupportpasswordsettingsoption.D.EnabletheMinimumpasswordlength（characters）option.Configureavalueof6orgreater.