• 搜标题
  • 搜题干
  • 搜选项
0 / 200字
多项选择题

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
单项选择题

One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）

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
微信扫码免费搜题