ORACLE试题.docx

ORACLE试题.docx

《ORACLE试题.docx》由会员分享，可在线阅读，更多相关《ORACLE试题.docx（56页珍藏版）》请在冰豆网上搜索。

ORACLE试题

Vendor:

1z0-043（new）

ExamCode:

oracledatabase10g:

administrationii

ExamName:

Oracle

Version:

3.00

分卷:

A

1:

YoulostthePRODSTDtablespace,whichwasread-only.Thetablespacewasread-onlywhenthelastbackupwastaken.Howwouldyourecoverthetablespace?

A.restorethetablespacefromthebackup

B.restorethetablespacefromthebackup,andthenperformanincompleterecovery

C.restorethetablespacefromthebackup,andthenapplyalltheredoinformation

D.restoreallthedatafilesinthedatabase,andthenperformanincompleterecovery

CorrectAnswers:

A

Explanation:

2:

YousettherecoverywindowtosevendaysandthebackupoptimizationtoONusingtheCONFIGUREcommandofRecoveryManager（RMAN）.ThemostrecentbackupoftheTOOLStablespacetodiskwastakenonJanuary3.TheTOOLStablespaceisread-only.OnFebruary21,whenyouexecuteacommandtobackupallthetablespacestodisk,youfindthatRMANbacksuptheTOOLStablespacealso,eventhoughthecontentsofthetablespacehavenotchangedafterthebackuponJanuary3.BecausetherearenochangesmadetotheTOOLStablespace,youdecidethatthetablespaceshouldnotbebackedupbyRMAN.WhatcanyoutodoskipbackinguptheTOOLStablespacewithoutchangingthecurrentbackupoptimizationsetting?

A.configureadefaultdeviceforRMANbackups

B.temporarilydisabletheretentionpolicyforRMANbackups

C.configureautomaticchannelallocationforRMANbackups

D.usetheCONFIGUREcommandtoreconfiguretherecoverywindowto60days

CorrectAnswers:

B

Explanation:

3:

ViewtheExhibitandexaminethecharacteristicsoftheUSERStablespace.YouobservethatalargevolumeofinsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto,inordertofindinformationabouttablefragmentation?

A.MemoryAdvisor

B.SegmentAdvisor

C.SQLTuningAdvisor

D.SQLAccessAdvisor

E.AutomaticDatabaseDiagnosticMonitor（ADDM）

CorrectAnswers:

B

Explanation:

4:

InyourproductiondatabaseyouwanttouseanAutomaticStorageManagement（ASM）instancetomanagethedatabasefiles.Whichoptionwouldyouusetomigratethedatabasefilesfromanon-ASMinstancetoanASMinstance?

A.OracleMigrationAssistant

B.RecoveryManager（RMAN）

C.OracleDataPumpExportandImport

D.conventionalOracleExportandImport

E.operatingsystemutilitiestocopythefilestotheASMinstance

CorrectAnswers:

B

Explanation:

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

ORA-06512:

at"SYS.DBMS_RESOURCE_MANAGER",line108

ORA-06512:

atline1

Whatactionwouldyoutaketoovercomethiserror?

A.createthePendingAreabeforecreatingtheconsumergroup

B.activatethePendingAreabeforecreatingtheconsumergroup

C.increasethesizeofthelargepooltoaccommodatethePendingArea

D.increasethesizeofthesharedpooltoaccommodatethePendingArea

E.increasethesizeofthedatabasebuffercachetoaccommodatethePendingArea

CorrectAnswers:

A

Explanation:

6:

Lastnight,amediafailurecausedthelossofatemporaryfilethatbelongstoyourdatabase.Whichtwothingsmayhappenthismorningwhenyoutrytoopenyourdatabase?

（Choosetwo.）

选项

A.Thedatabaseopensnormally.

B.Thedatabasepromptsforadatabaserecovery.

C.Thedatabasewriterwritestoatracefile,indicatingthatthetemporaryfileisnotfound.

D.Thedatabasegetsmountedandthrowsanerrorindicatingthatthetemporaryfilerequiresrecovery.

CorrectAnswers:

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

CorrectAnswers:

C

Explanation:

8:

Whatpurposewouldyouachievebyenablingtheblockchangetrackingfeature?

A.eliminatethenecessityforbackups

B.performoptimizedimagecopybackups

C.performoptimizedincrementalbackups

D.enablecheckpoint（CKPT）toperformcheckpointingateveryblockchange

E.enabledatabasewriter（DBWn）towritechangedblockstodatafilesfaster

CorrectAnswers:

C

Explanation:

9:

YouareworkingonanOracleDatabase10gdatabasethatoperatesintheARCHIVELOGmode.At06:

00p.m.,youdiscoveredthatatableintheSYSTEMtablespacethatdoesnotbelongtothedatadictionarywasdroppedat03:

00p.m.Whatwouldyoudotorecoverthetable?

A.performpoint-in-timerecoverytorecoverthetable

B.recoverthetablebyusingtheFlashbackTablefeature

C.restoretheentiredatabasefromthemostrecentbackupandopenit

D.usetheFlashbackTransactionQueryfeaturetoidentifytherelevantSQLstatementanduseittoundropthetable

CorrectAnswers:

A

Explanation:

10:

Youhavemanyuserscomplainingaboutslowinsertsintoalargetable.Whileinvestigatingthereason,youfindthatthenumberofindexesonthetableishigh.Youwanttofindoutwhichindexesarenotbeingused.Whichmethodwouldyoufollowtoachievethis?

A.enableindexmonitoringandquerytheDBA_OBJECTSview

B.enableindexmonitoringandquerytheDBA_INDEXESview

C.enableindexmonitoringandquerytheV$OBJECT_USAGEview

D.enableindexmonitoringandviewtheDBA_INDEXTYPE_COMMENTSview

CorrectAnswers:

C

Explanation:

11:

YourdatabaseisfunctioninginNOARCHIVELOGmode.Yourdatabasecontains15tablespaces.YouwanttouseRecoveryManager（RMAN）toperformbackups.Whichtwobackupswouldyoubeabletoperformwhenthedatabaseisbeingaccessedbyusers?

（Choosetwo.）

选项

A.backupofofflinetablespaces

B.backupofread-onlytablespaces

C.backupofsystem-criticaltablespaces

D.backupofonline,locallymanagedtablespaces

E.backupofread/writedictionary-managedtablespaces

CorrectAnswers:

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

CorrectAnswers:

D

Explanation:

13:

YouexecutedthefollowingcommandinRecoveryManager（RMAN）againstyourOracle10gdatabase:

RMAN>REPORTNEEDBACKUPdays3;

Whatwouldbetheoutputofthiscommand?

A.alistoffilesthatrequireabackupwithinthreedays

B.alistoffilesthathavenotbeenbackedupforthreedays

C.alistoffilesthatRMANrecommendsbebackeduponlyonceineverythreedays,basedonlowvolatility

D.alistoffilesforwhichabackuphasalreadybeenperformedandmayneedabackupafterthreedays

CorrectAnswers:

B

Explanation:

14:

YouexecutedthefollowingcommandinRecoveryManager（RMAN）:

RMAN>RESTORECONTROLFILE;

Whichoperationmustyouperformbeforethiscommandisexecuted?

A.backupthecontrolfiletotrace

B.bringdatabasetotheMOUNTstate

C.openaconnectiontotheRMANrecoverycatalog,whichcontainstheRMANmetadataforthetargetdatabase

D.setthedatabaseID（DBID）,butonlyiftheDB_NAMEparameterassociatedwiththetargetdatabaseisuniqueintherecoverycatalog

CorrectAnswers:

C

Explanation:

15:

YourdatabaseisfunctioninginARCHIVELOGmode.Inwhichtwosituationswouldyouperformacancel-basedrecovery?

（Choosetwo.）

选项

A.Youfindthatoneoftheredologmembersineachredologgroupislost.

B.YoufindthatadatafilethatbelongstotheUSERStablespaceisdamaged.

C.YoufindthatadatafilethatbelongstotheSYSTEMtablespaceisdamaged.

D.Youfindthatthecurrentredologgroupisdamagedandisnotavailableforrecovery.

E.Yourealizedwhileperformingarecoverythatanarchivedredologfileneededforrecoveryislost.

CorrectAnswers:

DE

16:

Youhavespecifiedthewarningandcriticalthresholdvaluesofanapplicationtablespacetobe60%and70%,respectively.Fromthetablespacespaceusagemetrics,youfindthattheactualspaceusagehasreachedthespecifiedwarningthresholdvalue,butnoalertshavebeengenerated.Whatcouldbethereasonforthis?

A.TheEVENTparameterwasnotset.

B.TheSQL_TRACEparameterissettoFALSE.

C.TheEnterpriseManagerGridControlisnotused.

D.TheSTATISTICS_LEVELparameterissettoBASIC.

E.TheTIMED_STATISTICSparameterissettoFALSE.

CorrectAnswers:

D

Explanation:

17:

ViewtheExhibitandexaminetheFlashbackDatabasearchitecture.Identifythemissingcomponent（shownwitha"?

"）intheFlashbackDatabasearchitecture.

A.DBWn

B.RVWR

C.ARCH

D.RECO

E.TRWR

CorrectAnswers:

B

Explanation:

18:

Inwhichtwoconditionsareresumablestatementssuspended?

（Choosetwo.）

选项

A.whenausersessionisterminated

B.whenauserexceedsthespacequota

C.whenausermanuallysuspe