多项选择题
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
A.guarantee undo retention
B.add one more redo log group
C.size the redo log files appropriately
D.size the UNDO tablespace appropriately
E.size the SYSTEM tablespace appropriately
F.configure an appropriate undo retention interval
G.change automatic undo management to manual
相关考题
-
单项选择题
When you try to open your database， you receive the following error： ORA-00205： error in identifying control file Where would you find the details required to resolve this error？（）
A.audit trail
B.alert log file
C.user trace file
D.online trace file
E.background trace file
F.operating system event viewer -
单项选择题
OneoftheusersinthePRODdatabase，Adams，complainsthathisupdateonthetable，TRANS，istakinganunusuallylongtimetocomplete.YoufindthatthetablegetslockedbyanotherdatabaseuserbeforeAdamsstartshistransactions，andyouareunabletocontacttheuserholdingthetablelock.AsAdamsisupdatingsomecrucialrowsinthetable，heshouldgetthehighestpriority.Whichmethodwouldyouusetoovercomethisproblem？（）
A.execute the command， ALTER SESSION KILL ..， to kill the blocking session
B.execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
C.execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
D.execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
E.execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session -
单项选择题
Youhavetwodatabases，FINDBandPAYDB，onsingleoperatingsystemandusingOptimalFlexiblearchitecture（OFA）.FINDBisfunctionalandiscurrentlybeingaccessedbytheusers.WhilestartinguptheinstanceforthePAYDBdatabaseyougetthefollowingerror：ORA-01081：cannotstart-alreadyrunningORACLE-shutitdownfirstWhichenvironmentalvariablewouldyousetbeforestartingupthePAYDBdatabasetoovercomethiserror？（）
A.ORA_PATH
B.ORACLE_SID
C.ORACLE_BASE
D.ORACLE_HOME
E.LD_LIBRARY_PATH
