A．producedB．stagedC．presentedD．released

A. Building the SQL profile

B. Recommending optimization of materialized views

C. Checking query objects for missing and stale statistics

D. Recommending bitmap, function-based, and B-tree indexes

E. Recommending restructuring SQL queries that are using bad plans

A.CONFIGUREDEFAULTDEVICETYPETOTAPEMEDIA

B.CONFIGUREDEFAULTDEVICETYPETOTAPE

C.CONFIGUREDEFAULTDEVICETYPETOSBT

D.CONFIGUREDEFAULTDEVICETYPETOSBT_TAPE

A.Thedatabaseautomaticallydeterminestheextent-sizingpolicyforthetablespace.

B.Thesegmentsareautomaticallyshrunkwhenthecontentsareremovedfromthem.

C.Theallocationofextentswithinthetablespaceismanagedthroughthedictionarytables.

D.Thespaceutilizationdescriptionofthedatablocksinsegmentsisrecordedinbitmapblocks.

E.Thespaceutilizationdescriptionofthedatablocksinsegmentsismanagedthroughfreelists.MANUAL

OnJan11，2005at2：30P.M.，anerroneousupdateoperationmodifiedallthevaluesofcolumnLASTNAMEintheEMPLOYEEtableintheScottschematoanemptystring.Youarethesystemadministrator，andyouwanttoreturntheoriginalvaluesinthetable.Todoso，youdecidedtoflashbackthetable.Whichtwooptionscanyouusetoflashbackatable？（）

A.byusingOracleEnterpriseManager

B.byissuingtheFLASHBACKTABLEstatementattheRMANprompt

C.byissuingtheFLASHBACKTABLEstatementattheSQLprompt

D.byissuingtheFLASHBACKTABLEstatementattheLSNRCTLprompt

nstallationofOraclesoftwareininteractivemodebyprovidingtheresponsefile.Inthemiddleoftheinstallation，yourealizethatthebehavioroftheOracleUniversalInstaller（OUI）isnotconsistentwiththeresponsefile.Whatactionwouldyoutaketodetectthecauseofthisbehavior？（）

A.Comparethecontentsoftheinstall.logfilewiththeresponsefile.

B.RefertothecontentsoftheoraInst.locfiletoverifythestepsperformedbyOUI.

C.ComparethecontentsoftheinstallActions.logfilewiththatoftheresponsefile.

D.RefertothealertlogfileforinformationregardingtheactionsperformedbyOUIduringinstallation.

A.Channelfailover

B.Restartablebackups

C.Rescheduablebackups

D.Automaticbackuprecovery

E.Channelrecovery

A.Youmustuseautomaticundomanagementinthedatabase.

B.YoumustconfigureOMFinyourdatabase.

C.YoumustconfigureASMforstoringthedatafiles.

D.Youmustmultiplextheonlineredologfile.

A.Thetracefileisinbinaryformat.

B.ThetracefilehasaSQLscripttore-createthecontrolfile.

C.Thetracefileisabackupsetcreatedduringthebackupofthecontrolfile.

D.Thetracefilecontainstheinstructionstomanuallyre-createthecontrolfile.

E.Thetracefileisanimagecopyofthecontrolfilecreatedduringthebackupofthecontrolfile.

At5：30PM，adatabaseadministrator，William，isinformedthatanimportantrecordofemployeenoE0025ismissingfromtheSCOTT.EMPLOYEEtable.At4：30P.M，thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion：

SELECToperation，undo_sql，logon_user

FROMFLASHBACK_TRANSACTION_QUERYWHERExid=

HEXTORAW（’0100043E23456’）；

where’0100043E23456’isthetransactionIDofthetransactionthatdeletedtherow.Beforeissuingtheabovestatement，whichtaskdidWilliamperformtoidentifythetransactionIDofthetransactionthatdeletedtherow？（）

A.

B.

C.

D. The query fails because the subquery returns more than one row.

E. The query fails because the outer query and the inner query are using different tables.