ORACLE试题Word下载.docx
《ORACLE试题Word下载.docx》由会员分享,可在线阅读,更多相关《ORACLE试题Word下载.docx(56页珍藏版)》请在冰豆网上搜索。
D.restoreallthedatafilesinthedatabase,andthenperformanincompleterecovery
CorrectAnswers:
Explanation:
2:
YousettherecoverywindowtosevendaysandthebackupoptimizationtoONusingtheCONFIGUREcommandofRecoveryManager(RMAN).ThemostrecentbackupoftheTOOLStablespacetodiskwastakenonJanuary3.TheTOOLStablespaceisread-only.OnFebruary21,whenyouexecuteacommandtobackupallthetablespacestodisk,youfindthatRMANbacksuptheTOOLStablespacealso,eventhoughthecontentsofthetablespacehavenotchangedafterthebackuponJanuary3.BecausetherearenochangesmadetotheTOOLStablespace,youdecidethatthetablespaceshouldnotbebackedupbyRMAN.WhatcanyoutodoskipbackinguptheTOOLStablespacewithoutchangingthecurrentbackupoptimizationsetting?
A.configureadefaultdeviceforRMANbackups
B.temporarilydisabletheretentionpolicyforRMANbackups
C.configureautomaticchannelallocationforRMANbackups
D.usetheCONFIGUREcommandtoreconfiguretherecoverywindowto60days
B
3:
ViewtheExhibitandexaminethecharacteristicsoftheUSERStablespace.YouobservethatalargevolumeofinsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto,inordertofindinformationabouttablefragmentation?
A.MemoryAdvisor
B.SegmentAdvisor
C.SQLTuningAdvisor
D.SQLAccessAdvisor
E.AutomaticDatabaseDiagnosticMonitor(ADDM)
4:
InyourproductiondatabaseyouwanttouseanAutomaticStorageManagement(ASM)instancetomanagethedatabasefiles.Whichoptionwouldyouusetomigratethedatabasefilesfromanon-ASMinstancetoanASMinstance?
A.OracleMigrationAssistant
B.RecoveryManager(RMAN)
C.OracleDataPumpExportandImport
D.conventionalOracleExportandImport
E.operatingsystemutilitiestocopythefilestotheASMinstance
5:
Youwanttocreateaconsumergroup,GROUP1,andyouexecutethefollowingcommandinthecommand-lineinterface:
SQL>
EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP
(CONSUMER_GROUP=>
'
group1'
COMMENT=>
'
NewGroup'
);
Thiscommanderrorsoutdisplayingthefollowingmessage:
ERRORatline1:
ORA-29371:
pendingareaisnotactive
ORA-06512:
at"
SYS.DBMS_RMIN"
line115
SYS.DBMS_RESOURCE_MANAGER"
line108
atline1
Whatactionwouldyoutaketoovercomethiserror?
A.createthePendingAreabeforecreatingtheconsumergroup
B.activatethePendingAreabeforecreatingtheconsumergroup
C.increasethesizeofthelargepooltoaccommodatethePendingArea
D.increasethesizeofthesharedpooltoaccommodatethePendingArea
E.increasethesizeofthedatabasebuffercachetoaccommodatethePendingArea
6:
Lastnight,amediafailurecausedthelossofatemporaryfilethatbelongstoyourdatabase.Whichtwothingsmayhappenthismorningwhenyoutrytoopenyourdatabase?
(Choosetwo.)
选项
A.Thedatabaseopensnormally.
B.Thedatabasepromptsforadatabaserecovery.
C.Thedatabasewriterwritestoatracefile,indicatingthatthetemporaryfileisnotfound.
D.Thedatabasegetsmountedandthrowsanerrorindicatingthatthetemporaryfilerequiresrecovery.
AC
7:
Thedatabasehasthedatablocksizesetto8KB.Youneedtoimportatablespacewitha4KBblocksizeintothedatabase.Whichadditionalmemoryparameter(s)shouldbeconfiguredtoperformatransportabletablespaceimport?
A.DB_CACHE_SIZEonly
B.DB_8K_CACHE_SIZEonly
C.DB_4K_CACHE_SIZEonly
D.SGA_TARGETandDB_4K_CACHE_SIZE
E.DB_BLOCK_SIZEandDB_8K_CACHE_SIZE
F.DB_BLOCK_SIZEandDB_4K_CACHE_SIZE
C
8:
Whatpurposewouldyouachievebyenablingtheblockchangetrackingfeature?
A.eliminatethenecessityforbackups
B.performoptimizedimagecopybackups
C.performoptimizedincrementalbackups
D.enablecheckpoint(CKPT)toperformcheckpointingateveryblockchange
E.enabledatabasewriter(DBWn)towritechangedblockstodatafilesfaster
9:
YouareworkingonanOracleDatabase10gdatabasethatoperatesintheARCHIVELOGmode.At06:
00p.m.,youdiscoveredthatatableintheSYSTEMtablespacethatdoesnotbelongtothedatadictionarywasdroppedat03:
00p.m.Whatwouldyoudotorecoverthetable?
A.performpoint-in-timerecoverytorecoverthetable
B.recoverthetablebyusingtheFlashbackTablefeature
C.restoretheentiredatabasefromthemostrecentbackupandopenit
D.usetheFlashbackTransactionQueryfeaturetoidentifytherelevantSQLstatementanduseittoundropthetable
10:
Youhavemanyuserscomplainingaboutslowinsertsintoalargetable.Whileinvestigatingthereason,youfindthatthenumberofindexesonthetableishigh.Youwanttofindoutwhichindexesarenotbeingused.Whichmethodwouldyoufollowtoachievethis?
A.enableindexmonitoringandquerytheDBA_OBJECTSview
B.enableindexmonitoringandquerytheDBA_INDEXESview
C.enableindexmonitoringandquerytheV$OBJECT_USAGEview
D.enableindexmonitoringandviewtheDBA_INDEXTYPE_COMMENTSview
11:
YourdatabaseisfunctioninginNOARCHIVELOGmode.Yourdatabasecontains15tablespaces.YouwanttouseRecoveryManager(RMAN)toperformbackups.Whichtwobackupswouldyoubeabletoperformwhenthedatabaseisbeingaccessedbyusers?
A.backupofofflinetablespaces
B.backupofread-onlytablespaces
C.backupofsystem-criticaltablespaces
D.backupofonline,locallymanagedtablespaces
E.backupofread/writedictionary-managedtablespaces
AB
12:
YouexecutethefollowingRMANcommandsintheordershownbelow:
BACKUPVALIDATEDATABASE;
BLOCKRECOVERCORRUPTIONLIST;
Whatwillthesecommandsdo?
A.createabackupofthedatabaseandrecoverallcorruptedblocksfoundinthebackup
B.runabackupvalidationandlistallthelogicallycorruptblocksaswellasphysicallycorruptblocksinthedatabase
C.runabackupvalidationtopopulateV$COPY_CORRUPTIONview,andthenlistanycorruptblocksrecordedintheview
D.runabackupvalidationtopopulateV$DATABASE_BLOCK_CORRUPTIONview,andthenrepairanycorruptblocksrecordedintheview
E.runabackupvalidation,repairanycorruptblocksfoundduringthevalidationprocess,andthenupdateV$DATABASE_BLOCK_CORRUPTION
viewtoindicatewhichcorruptblockshavebeenrepaired
D
13:
YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourOracle10gdatabase:
RMAN>
REPORTNEEDBACKUPdays3;
Whatwouldbetheoutputofthiscommand?
A.alistoffilesthatrequireabackupwithinthreedays
B.alistoffilesthathavenotbeenbackedupforthreedays
C.alistoffilesthatRMANrecommendsbebackeduponlyonceineverythreedays,basedonlowvolatility
D.alistoffilesforwhichabackuphasalreadybeenperformedandmayneedabackupafterthreedays
14:
YouexecutedthefollowingcommandinRecoveryManager(RMAN):
RESTORECONTROLFILE;
Whichoperationmustyouperformbeforethiscommandisexecuted?
A.backupthecontrolfiletotrace
B.bringdatabasetotheMOUNTstate
C.openaconnectiontotheRMANrecoverycatalog,whichcontainstheRMANmetadataforthetargetdatabase
D.setthedatabaseID(DBID),butonlyiftheDB_NAMEparameterassociatedwiththetargetdatabaseisuniqueintherecoverycatalog
15:
YourdatabaseisfunctioninginARCHIVELOGmode.Inwhichtwosituationswouldyouperformacancel-basedrecovery?
A.Youfindthatoneoftheredologmembersineachredologgroupislost.
B.YoufindthatadatafilethatbelongstotheUSERStablespaceisdamaged.
C.YoufindthatadatafilethatbelongstotheSYSTEMtablespaceisdamaged.
D.Youfindthatthecurrentredologgroupisdamagedandisnotavailableforrecovery.
E.Yourealizedwhileperformingarecoverythatanarchivedredologfileneededforrecoveryislost.
DE
16:
Youhavespecifiedthewarningandcriticalthresholdvaluesofanapplicationtablespacetobe60%and70%,respectively.Fromthetablespacespaceusagemetrics,youfindthattheactualspaceusagehasreachedthespecifiedwarningthresholdvalue,butnoalertshavebeengenerated.Whatcouldbethereasonforthis?
A.TheEVENTparameterwasnotset.
B.TheSQL_TRACEparameterissettoFALSE.
C.TheEnterpriseManagerGridControlisnotused.
D.TheSTATISTICS_LEVELparameterissettoBASIC.
E.TheTIMED_STATISTICSparameterissettoFALSE.
17:
ViewtheExhibitandexaminetheFlashbackDatabasearchitecture.Identifythemissingcomponent(shownwitha"
?
"
)intheFlashbackDatabasearchitecture.
A.DBWn
B.RVWR
C.ARCH
D.RECO
E.TRWR
18:
Inwhichtwoconditionsareresumablestatementssuspended?
A.whenausersessionisterminated
B.whenauserexceedsthespacequota
C.whenausermanuallysuspe