多项选择题
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?()
单项选择题 OneoftheusersinthePRODdatabase,Adams,complainsthathisupdateonthetable,TRANS,istakinganunusuallylongtimetocomplete.YoufindthatthetablegetslockedbyanotherdatabaseuserbeforeAdamsstartshistransactions,andyouareunabletocontacttheuserholdingthetablelock.AsAdamsisupdatingsomecrucialrowsinthetable,heshouldgetthehighestpriority.Whichmethodwouldyouusetoovercomethisproblem?()
单项选择题 Youhavetwodatabases,FINDBandPAYDB,onsingleoperatingsystemandusingOptimalFlexiblearchitecture(OFA).FINDBisfunctionalandiscurrentlybeingaccessedbytheusers.WhilestartinguptheinstanceforthePAYDBdatabaseyougetthefollowingerror:ORA-01081:cannotstart-alreadyrunningORACLE-shutitdownfirstWhichenvironmentalvariablewouldyousetbeforestartingupthePAYDBdatabasetoovercomethiserror?()