单项选择题 AcustomerhasaWebTradeapplicationthatinitiallyusestheembeddedLDAPtoauthenticateusers.Toenhancesecurity,thecustomerdecidestouseOAMtoauthenticatesomeoftheusersagainstanexternalLDAPstore.Forthistowork,acustomerconfiguredanOAMAuthenticator,butwasnotsurewhattoselectfortheControlFlag.WhatControlFlagshouldthecustomerchoose?（）A.OPTIONALB.REQUISITEC.REQUIREDD.SUFFICIENTE.MANDATORY
单项选择题 YouaremaintainingyourproductiondatabaseinOracle10g.Youwantthecircularreuserecordsinthecontrolfileofthetargetdatabasetobereusedasrequired.WhichvaluewillyousetfortheCONTROL_FILE_RECORD_KEEP_TIMEinitializationparameter？（）A.0B.1C.NONED.DEFAULT
单项选择题 YouwanttoimplementthebackupandrecoverystrategyinyourdatabaseusingRecoveryManager（RMAN）.YouhavechosenthecontrolfileofthetargetdatabasefortheRMANrepository.Whichcommand-lineRMANcommandwouldyouusetoestablishalocalconnectionbetweenRMANandtheRMANrepositoryifyourdatabaseisusingpasswordfileauthentication？（）A.rmanTARGET/NOCATALOGB.rmanTARGETsys/passwordC.rmanTARGETsys/passwordASSYSDBAD.rmanTARGETsys/password@db_nameCATALOGrman_user/rman_password@rcat
单项选择题 Whichofthefollowingisnotaconfigurableattributeforanindividualdiskgroup？（）
单项选择题 YouarepeerreviewingafellowDBAsbackupplanforhisNOARCHIVELOGmodedatabase，asshownhere：Putthetablespacesinbackupmode.Backupthedatafilesforalltablespaces.Takethetablespacesoutofbackupmode.Backupallarchivedredologs.Yourcolleagueasksforyoutocommentonhisplan.Whichresponsewouldbecorrect？（）A.Theplanwillworkasis.B.Theplanneedstobemodifiedtoallowforanarchive-logswitchafterstep3.C.Theplanneedstobemodifiedsothatabackupofthearchivedredologsoccursbeforestep1.D.Theplanneedstobeadjustedtoshutdownthedatabaseafterstep1andtorestartthedatabaseafterstep2.E.Theplancannotworkaspresented.
单项选择题 WhichofthefollowingstatementsistruewhenthedatabaseisinARCHIVELOGmodeand tablespacesareinhotbackupmode？（）
单项选择题 YouhaveconfiguredyourdatabasetouseRMANforbackupandrecovery.YoumustbackupthedatafilecontainedintheTS1tablespace.ThesizeofthedatafileintheTS1tablespaceis200MB.YouissuethefollowingcommandfromtheRMANprompttoperformabackupofthetablespace：RMAN>BACKUPTABLESPACETS1MAXSETSIZE100M；Whichstatementistrueaboutexecutingthiscommand？（）A.Thecommandgeneratesanerror.B.Thecommandbacksupthetablespaceandcreatesabackupsetofsize200MBC.Thecommandbacksupthetablespaceandcreatestwobackupsetsofsize100MBeach.D.Thecommandbacksupthetablespaceandcreatesabackupsetwithbackuppiecesofsize100MBeach.
单项选择题 Youexecuteacommandtoresizeadatafile，sales.dbf，ofsize200MBinyourdatabase：ALTERDATABASEDATAFILE’／remorse／sales.dbf’RESIZE150M；Whichstatementistrueaboutthiscommand（）
单项选择题 Animportanttablespaceofyourdatabaseisdropped&ens
单项选择题 InwhichscenariodoyouusetheFlashbackDatabasefeature？（）
单项选择题 Theapplicationworkloadonyourdatabaseissamebetween10a.m.and11a.m.onweekdays.Suddenlyyouobservepoorperformancebetween10a.m.and11a.m.inthemiddleoftheweek.Howwouldyouidentifythechangesinconfigurationsettings，workloadprofile，andstatisticstodiagnosethepossiblecausesoftheperformancedegradation？（）A.byusingtheSQLaccessadvisorB.byusingtheAutomaticWorkloadRepositoryreportC.byrunningtheAutomaticDatabaseDiagnosticMonitor（ADDM）D.byusingtheAutomaticWorkloadRepositoryComparePeriodreportE.byanalyzingtheoutputoftheV$ACTIVE_SESSION_HISTORYview
单项选择题 Whichstatementistrueaboutthelossofsystem－criticaldatafilesinARCHIVELOGmode？（）
单项选择题 YouquerytheORDERStableanddiscoverthatordernumber1101ismissing.Oneofyourreports，generatedat5：00A.M.onApril23，2005usingOracleReports，includesthisordernumberintheoutput.Youhaveinserted100newordersintotheORDERStablesincegeneratingthisreport.Whichflashbacktechnologywouldyouusetorecoverordernumber1101intotheORDERStablewithoutlosingthe100ordersthatyouaddedafterthereportwasgenerated？（）A.FlashbackTableB.FlashbackQueryC.FlashbackVersionQueryD.FlashbackTransactionQuery
单项选择题 Whichofthefollowingmostcloselyrepresentsanimagecopy?（）
单项选择题 InwhichscenariowillyouusetheFlashbackVersionQueryfeature？（）
单项选择题 YouaremanagingasingleinstanceOracle10gdatabasethatutilizesthefollowingparameters：WhichofthefollowingsetofcommandsmustyouexecutetoenableFlashbackDatabase？（）
单项选择题 YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles？（）A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’；B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH；C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’；D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’；
单项选择题 YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）A.V$DATABASEB.V$FLASHBACK_DATABASE_STATC.V$FLASHBACK_DATABASE_LOGD.V$RECOVERY_FILE_DEST
单项选择题 YouupgradedOracleDatabase10gtoOracleDatabase11g.Howwouldthisaffecttheexistingusers’passwords？（）
单项选择题 YourOracleDatabase10gisonlinewhenyouexecutethefollowingstatement：SQL>ALTERTABLESPACEMY_TABLESPACEFLASHBACKOFF；WhatistheresultofexecutingthisstatementiftheFlashbackDatabasefeatureisalreadyenabledinthedatabase？（）A.ThedatabasedoesnotrecordflashbacklogsforMY_TABLESPACEB.ThetablesresidinginMY_TABLESPACEarenotprotectedbytheRecycleBin.C.AllthetablespacesexceptMY_TABLESPACEcanberecoveredusingFlashbackDatabasefeature.D.Noneoftheflashbacktechnologies，suchasFlashbackTable，FlashbackTransactionQueryandFlashbackVersionQuerycanbeusedtorecoverindividualrowswithintheobjectsfromMY_TABLESPACE