你可能感兴趣的试题

A.YoufindthatthetablegetslockedbyanotherdatabaseuserbeforeAdamsstartshistransactions，andyouareunabletocontacttheuserholdingthetablelock.AsAdamsisupdatingsomecrucialrowsinthetable，heshouldgetthehighestpriority.Whichmethodwouldyouusetoovercomethisproblem？（）
A.executethecommand，ALTERSESSIONKILL..，tokilltheblockingsession
B.executetheDBMS_SESSION.KILL_SESSIONproceduretokilltheblockingsession
C.executethecommand，ALTERSYSTEMKILLSESSION..，tokilltheblockingsession
D.executethecommand，ALTERSESSIONUNLOCK..，toreleasethelockfortheblockingsession
E.executethecommand，ALTERSYSTEMUNLOCKSESSION..，toreleasethelockfortheblockingsession

A.FINDBisfunctionalandiscurrentlybeingaccessedbytheusers.WhilestartinguptheinstanceforthePAYDBdatabaseyougetthefollowingerror：ORA-01081：cannotstart-alreadyrunningORACLE-shutitdownfirstWhichenvironmentalvariablewouldyousetbeforestartingupthePAYDBdatabasetoovercomethiserror？（）
A.ORA_PATH
B.ORACLE_SID
C.ORACLE_BASE
D.ORACLE_HOME
E.LD_LIBRARY_PATH