1Z0-083-CHN Oracle Database Administration II认证考试题库及答案_第1页
1Z0-083-CHN Oracle Database Administration II认证考试题库及答案_第2页
1Z0-083-CHN Oracle Database Administration II认证考试题库及答案_第3页
1Z0-083-CHN Oracle Database Administration II认证考试题库及答案_第4页
1Z0-083-CHN Oracle Database Administration II认证考试题库及答案_第5页
已阅读5页,还剩176页未读, 继续免费阅读

下载本文档

版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领

文档简介

PAGEPAGE11Z0-083-CHNOracleDatabaseAdministrationII认证考试题库一、单选题1.YoumusttransporttheUNIVERSITYtablespacefromonedatabasetoanother.TheUNIVERSITYtablespaceiscurrentlyopenread/write.

Thesourceanddestinationplatformshavedifferentendianformats.Examinethislistofactions:

1).MaketheUNIVERSITYtablespaceread-onlyonthesourcesystem.

2).ExporttheUNIVERSITYtablespacemetadatausingEXPDP.

3).ConverttheUNIVERSITYtablespacedatafiestothedestinationplatformformatusingRMANonthesourcesystem.

4).CopytheUNIVERSITYtablespacedatafilestothedestinationsystem.

5).CopytheDataPumpdumpsettothedestinationsystem.

6).ConverttheUNIVERSITYtablespacedatafilestothedestinationplatformformatusingRMANonthedestinationsystem.

7).ImporttheUNIVERSITYtablespacemetadatausingIMPDP.

8).MaketheUNIVERSITYtablespaceread/writeonthedestinationsystem.

Whichistheminimumnumberofactionsrequired,inthecorrectorder,totransporttheUNIVERSITYtablespace?A、1,2,4,5,7,8B、1,2,4,6,7,8C、1,2,3,4,5,7,8D、1,2,3,4,5,6,7,8E、2,4,5,6,7答案:C2..ExaminetheRMANmand:

RMAN>CONFIGUREENCRYPTIONFORDATABASEON;RMAN>BACKUPDATABASEPLUSARCHIVELOG;

Whichprerequisitemustbemetbeforeacplishingthebackup?A、Thepasswordfortheencryptionmustbesetup.B、Oraclewalletfortheencryptionmustbesetup.C、AllthetablespacesinthedatabasemustbeencryptedD、OracleDatabaseVaultmustbeenabled.答案:B3.OracleDataRedactionisactiveontheSCOTT.EMPtable.Youqueriedthetabletwice.SQL>SELECTENAME,SAL,M,MGR,HIREDATEFROMEMPWHEREDEPTNO=30;SQL>SELECTENAME,SAL,M,MGR,HIREDATEFROMEMPWHEREDEPTNO=30;Whichisguaranteedtobetrueconcerningtheredactionpolicy?A、FULLredactionisactiveontheSALcolumnB、RANDOMredactionisactiveontheMGRcolumnC、RANDOMredactionisactiveontheHIREDATEcolumnD、PARTIALredactionisactiveontheMGRcolumn.E、PARTIALredactionisactiveoftheHIREDATEcolumn.答案:C4.ExaminetheRMANmand:RMAN>RUN{

ALLOCATECHANNELc1DEVICETYPEsbt;ALLOCATECHANNELc2DEVICETYPEsbt;ALLOCATECHANNELc3DEVICETYPEsbt;

BACKUPINCREMENTALLEVEL=0(DATAFILE1,4,5CHANNELc1)(DATAFILE2,3,9CHANNELc2)(DATAFILE6,7,8CHANNELc3);

SQL'ALTERSYSTEMARCHIVELOGCURRENT';

}Whichstatementistrueaboutthemand?A、Itusesmultisectionbackup.B、Itusesparallelizationforthebackupset.C、ItusesasynchronousI/Oforthebackup.D、Itcreatespressedbackupsets.答案:B5.Choosethebestanswer.Examinethisconfiguration:

1).CDB1isacontainerdatabaserunninginARCHIVELOGmode.

2).MultipleunmittedtransactionsarerunninginCDB1.

3).Redologgroups1and2areINACTIVE.

4).Redologgroup3istheCURRENTgroup.

Allmembersofredologgroup3arelostbeforeitisarchived.Examinethesepossiblesteps:

1).SHUTDOWNABORT

2).STARTUPNOMOUNT

3).STARTUPMOUNT

4).ALTERDATABASEMOUNT

5).RESTOREDATABASE

6).RECOVERDATABASENOREDO

7).RECOVERDATABASEUNTILAVAILABLE

8).RESTOREARCHIVELOGALL

9).ALTERDATABASEOPEN

10).ALTERDATABASEOPENRESETLOGS

Choosetheminimumrequiredstepsinthecorrectordertorecoverthedatabase.A、1,3,5,6,9B、1,3,5,7,10C、1,2,5,7,4,10D、1,3,5,6,10E、1,3,5,6,10F、1,3,5,8,6,10答案:B6.YouplantocreateadatabasebyusingtheDatabaseConfigurationAssistant(DBCA),withthefollowingspecifications:Applicationswillconnecttothedatabaseviaamiddletier.

Thenumberofconcurrentuserconnectionswillbehigh.

Thedatabasewillhavemixedworkload,withtheexecutionofplexBIqueriesscheduledatnight.WhichDBCAoptionmustyouchoosetocreatethedatabase?A、aGeneralPurposedatabasetemplatewithdefaultmemoryallocationB、aDataWarehousedatabasetemplate,withthededicatedservermodeoptionandAMMenabledC、aGeneralPurposedatabasetemplate,withthesharedservermodeoptionandAutomaticMemoryManagement(AMM)enabledD、adefaultdatabaseconfiguration答案:C7.chooseoneYoutakeregularbackupsofoneofyourproductiondatabasesbyusingRMANwitharecoverycatalog.

Youhaveaddedtwonewtablespacestothisdatabasewhichmustbeincludedinfuturebackups.Whichprocessoccurswhichallowsthenewbackupstocontainthenewdatafiles?A、Thetargetdatabasecontrolfileissynchronizedfromtherecoverycatalogwithapartialresyncatthenextbackup.B、Therecoverycatalogissynchronizedfromthetargetdatabasecontrolfilewithafullresyncatthenextbackup.C、Thetargetdatabasecontrolfileissynchronizedfromtherecoverycatalogwithafullresyncatthenextbackup.D、Therecoverycatalogissynchronizedfromthetargetdatabasecontrolfilewithapartialresyncatthenextbackup.答案:B8.Youareadministeringamultitenantcontainerdatabase(COB)thatcontainstwopluggabledatabases(PDBs),pdb1andpdb2.

Youareconnectedtopdb2asamonuserwithDBAprivileges.Thestatistics_levelparameterisPDBmodifiable.

Astheusersys,executethefollowingmandonpdb2:

SQL>ALTERSYSTEMSETSTATISTICS_LEVEL=ALLSID='*'SCOPE=SPFILE;

Whichstatementistrueabouttheresultofthismand?A、Thestatistics_levelparameterissettoallwhenanyofthePDBsisreopened.B、Thestatistics_levelparameterissettoallonlyforPDB2whenitisreopened.C、Thestatistics_levelparameterissettoallwhentherootdatabaseisrestarted.D、ThestatementisignoredbecausethereisnoSPFILEforaPDB.答案:B9.Auserplainsaboutpoordatabaseperformance.Youwanttoverifyiftheuser¡¯ssessionhaswaitedforcertaintypesofI/Oactivity.

Whichviewdisplaysallwaitswaitedonbyasessionatleastonce?A、V$SESSION_EVENTB、V$SESSTATC、V$SESSION_WAITD、V$SESSION_WAIT_CLASSE、V$SESSION答案:A解析:V$SESSION_WAIT只显示当前和最后的等待事件,题目要求所有的事件。10.Choosethebestanswer.ApplicationPDBs,SALES_APP1andSALES_APP2,mustbecreatedandtheymustaccessmontablesoftheSALES_APPapplication.

Examinethesesteps:

1).InstalltheSALES_APPapplication,includingthemontables,intheapplicationroot.

2).InstalltheSALES_APPapplicationintheapplicationrootandthemontablesinboththeCDBrootandtheapplicationroot.

3).Createanapplicationseed.

4).InstalltheSALES_APPapplicationintheapplicationseed.

5).CreatetheSALES_APP1andSALES_APP2applicationPDBs.

6).Syncroot.

7).Syncseed.

8).SynctheSALES_APP1andSALES_APP2applicationPDBswiththeapplicationtheSALES_APP1andSALES_APP2applicationPDBswiththeapplicationtheapplicationseedwiththeapplicationroot.

Whicharetheminimumrequiredstepsinthecorrectsequence?A、1,3,5,7B、3,4,1,6,8C、1,3,5,6,7D、1,5,6E、2,5,6答案:D11.Yourproductiondatabaseisrunninginarchivelogmode.YouuseRMANwitharecoverycatalogtobackupyourdatabasetomediaandthedatabaseisuniquelyidentifiedintherecoverycatalog.

Youwanttocreateatestdatabasefromtheproductiondatabaseandallowtheproductiondatabasetoremainopenduringtheduplicateprocess.

Yourestorethedatabasebackupstoanewhostwiththesamedirectorystructureastheproductiondatabaseandwanttousetherecoverycatalogforfuturebackupsafterthedatabaseissuccessfullyrestoredtothenewhost.

Howwouldyouachievethis?A、byusingtheRMANswitchmandtosetthenewlocationforthedatafilesB、byusingtheRMANduplicatemandwithnofilenamechecktorecoverthedatabasetothenewhostC、byusingtheRMANduplicatemandwithdbidandsetnewnamefortablespacetorecoverthedatabasetothenewhostD、bycreatinganewdatabaseinthenewhost,andthenusingtheRMANrecovermand答案:B解析:因为是恢复的相同的路径下,所以duplicate的时候要用到nofilenamecheck12.Choosethebestanswer.Aschemaownertruncatedatableinerrorandmustrecoverthedata.WhichOracleFlashbackfeaturecouldbeusedtorecoverthedata?A、FLASHBACKDATABASEB、FLASHBACKTABLEC、FLASHBACKVERSIONQUERYD、FLASHBACKDATAARCHIVEE、FLASHBACKTRANSACTION答案:D13.Choosethebestanswer.Examinethisconfiguration:

1).CDB1isacontainerdatabase.

2).Thereareseveralpluggabledatabases(PDBs)inCDB1.

5).EachPDBhasseveraltableswithreferentialintegrityconstraints.

6).FLASHBACKDATABASEisON.

7).UNDORETENTIONGUARANTEEisenabled.MultipleundesiredmultitablechangesweremadeinallthePDBs.

Whichmethodcanbeusedtoundothechangesusingasinglemand?A、restoreandrecoverdatabaseB、flashbacktransactionC、flashbackdatabaseD、flashbacktableandtransactionE、flashbacktable答案:C14.Youexecutethismandsuccessfully:

SQL>ALTERDATABASEBACKUPCONTROLFILETOTRACE;

Whatistheoute?A、Itcreatesabinarybackupofthecontrolfile.B、ItupdatesthealertlogwiththelocationandcontentsofthecontrolfileC、ItcreatesafilethatcontainsSQLstatementstore-createthecontrolfile.D、ItcreatesafilethatcontainsRMANscriptstocreateaduplicatedatabase.E、Itcreatesacopyofthecontrolfileinthefastrecoveryarea(FRA).答案:C15.RMANisconnectedtoatargetdatabaseinstanceandanauxilaryinstance.Youexecutethemand:

RMAN>DUPLICATETARGETDATABASETOdupdbFROMACTIVEDATABASESECTIONSIZE1G;

Whatistheoute?A、RMANusesthepullmethodtorestorefilesusingimagecopiesB、RMANusesthepushmethodtotransferimagecopiesC、RMANusesthepushmethodtotransferbackupsetsD、RMANusesthepullmethodtorestorefilesusingbackupsets答案:D16.AplicationPDBs,SALES_APP1andSALES_APP2,mustbecreatedandtheymustaccessmontablesoftheSALES_APPapplication.

Examinethesesteps:

1).InstalltheSALES_APPapplication,indudingthemontables,intheapplicationroot.

2).InstalltheSALES_APPapplicationintheapplicationrootandthemontablesinboththeCDBrootandtheapplicationroot.

3).Createanapplicationseed.

4).InstalltheSALES_APPapplicationintheapplicationseed.

5).CreatetheSALES_APP1andSALES_APP2applicationPDBs.

6).SynctheSALES_APP1andSALES_APP2applicationPDBswiththeapplicationroot.

7).SynctheSALES_APP1andSALES_APP2applicationPDBswiththeapplicationseed.

8).Synctheapplicationseedwiththeapplicationroot.

Whicharetheminimumrequiredstepsinthecorrectsequence?A、1,3,5,7B、2,5,6C、1,5,6D、3,4,1.6,8E、1,3,5,6,7答案:C17.Choosethebestanswer.WhichshouldbetunedfirstwhendoingaperformancetuningexerciseforanOracleDatabaseenvironment?A、logwriterperformanceB、databasewriterperformanceC、generaloperatingsystemhealthD、SQLstatementsE、databaseinstancememorymanagementandsizes答案:D18.Choosethebestanswer.ExaminethisoutputofanexportfromthecurrentreleaseofanOraclemultitenantdatabase:$sqlplussystem/oracle.

SQL>colnamefora10

SQL>selectname,open_modefromv$pdbs;NAMEOPEN_MODE

PDB$SEEDREADONLY

PDB1READWRITE

PDB2MOUNTED

SQL>exit

Nextyouexecute:$expdpsystem/oraclefull=yWhatistheoute?A、ItfailsbecauseDataPumpcannotbecontainer.B、ItcreatesafullexportoftherootC、ItcreatesafullexportoftherootD、ItcreatesafullexportofonlytheusedwhileconnectedtotherootcontainerandPDB1.containerandallPDBs.containerandallopenPDBs.rootcontainer.答案:A19.Examinethisconfiguration:1.CDB1isacontainerdatabaserunninginARCHIVELOGmode2.ControlfilesofcDB1aremultiplexedin

'/u01/app/oracle/oradata/CDB1/controlfile/controlfile01.ctl'and'/u02/app/oracle/fastrecoverarea/cdb1/CDB1/controlfile02.ctl'3.TheonlybackupofcDB1wastakenwhenCONTROLFILEAUTOBACKwasOFF4.SNAPSHOTCONTROLFILENAMEis'/u01/app/oracle/product//db1/dbs/snapcfcdb1.f'WhileCDB1isopen,¡®/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl¡¯isaccidentallydeleted.Torecoverfromthiscriticalfailure,youexecutethesemands:$rmantargetsys/oracle4Ulocalhost:1521/cdb1

RMAN>SHUTDOWNABORT

Oracleinstanceshutdown

RMAN>STARTUPNOMOUNT

RMANRESTORECONTROLFILEFROM'/u01/app/oracle/oradata/CDB1/controlfile/controlfile01.ctl';Whatwillbetheoute?A、Itwillcreate¡®$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl.B、Itwillcreate¡®/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl.C、Itwillre-create¡®/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl.D、Itwillcreate¡®/u01/app/oracle/product//db_1/dbs/snapcf_cdb1control02.ctl¡¯.E、Itwillfailbecausethereisnoautobackupofthecontrolfiles.答案:C解析:经测试,会自动重建20.YounoticeperformancedegradationinyourproductionOracle12cdatabase.Youwanttoknowwhatcausedthisperformancedifference.

Whichmethodorfeatureshouldyouuse?A、DatabaseReplayB、AutomaticDatabaseDiagnosticMonitor(ADDM)parePeriodreportC、ActiveSessionHistory(ASH)reportD、SQLPerformanceAnalyzer答案:B21.Examinethesequeriesandtheiroutput:AnonlineRMANbackupoftheCDBwastakenanhourbeforeRestorePointR1wascreated.YouwanttorecoverPDB1toRestorePointR1.Howdoyouachievethis?A、ExecuteFLASHBACKPLUGGABLEDATABASEPDB1TORESTOREPOINTR1byusingRMANwhileconnectedtoPDB1.B、ExecuteFLASHBACKPLUGGABLEDATABASEPDB1TORESTOREPOINTR1byusingSQLwhileconnectedtoPDB1.C、ExecuteFLASHBACKPLUGGABLEDATABASEPDB1TORESTOREPOINTR1byusingSQLwhileconnectedtoCDB$ROOT.D、ExecuteFLASHBACKPLUGGABLEDATABASEPDB1TORESTOREPOINTR1byusingRMANwhileconnectedtoCDB$ROOT.E、Thiscannotbedoneduetothelackofacleanrestorepoint.答案:E22.Unifiedauditingisenabledinyourdatabase.TheHR_ADMINandOE_ADMINrolesexistandaregrantedsystemprivileges.Youexecutethemand:

SQL>CREATEAUDITPOLICYtable_audPRIVILEGESCREATEANYTABLE,DROPANYTABLE

ROLEShr_admin,oe_admin;Whichstatementistrue?A、ItsucceedsandneedstobeenabledtocaptureallSQLstatementsthatrequireeitherthespecifiedprivilegesoranyprivilegegrantedtotheHR_ADMINorOE_ADMINrole.B、Itfailsbecausethemanddoesnotspecifywhentheunifiedauditpolicyshouldbeenforced.C、ItsucceedsandstartscapturingonlysuccessfulSQLstatementsforalluserswhohaveeitherthespecifiedprivilegesorrolesgrantedtothem.D、Itfailsbecausesystemprivilegescannotbegrantedwithrolesinthesameauditpolicy.答案:A23.Choosethebestanswer.ExaminethisoutputofanexportfromthecurrentreleaseofanOraclemultitenantdatabase:$sqlplussystem/oracle.A、ItfailsbecauseDataPumpcannotbeusedwhileconnectedtotherootcontainer.B、ItcreatesafullexportoftherootcontainerandallPDBs.C、Itcreatesafullexportofonlytherootcontainer.D、ItcreatesafullexportoftherootcontainerandPDB1.答案:C24.Choosethebestanswer.Examinethisconfiguration:

1).CDB1isanOracleDatabase12cRelease2containerdatabase(CDB).

2).PDB1andPDB2aretwopluggabledatabases(PDBs)inCDB1.

Aftersuccessfullyperformingallthepreupgradetasks,youexecutethesemandsfromtheOracleDatabase18cenvironment:

$exportORACLE_SID=cdb1

$sqlplus/assysdba

SQL>STARTUPUPGRADE;

SQL>SHOWpdbsCON_IDCON_NAME

CON_IDCON_NAMEOPENMODERESTRICTED

2PDB$SEEDMIGRATEYES

3PDB1MOUNTEDYES

4PDB2MOUNTEDYES

SQL>ALTERPLUGGABLEDATABASEpdb1OPENUPGRADE;

Pluggabledatabasealtered.SQL>exit

$$ORACLE_HOME/perl/bin/perlcatctl.pl-C'PDB2'Whatistheoute?A、ItfailsbecausePDB$SEEDisinMIGRATEstate.B、OnlyCDB$ROOT,PDB$SEED,andPDB1areupgraded.C、OnlyCDB$ROOT,PDB$SEED,andPDB2areupgraded.D、ItfailsbecausePDB2isnotinUPGRADEstate.E、CDB$ROOT,PDB$SEED,PDB1,andPDB2areupgraded.F、OnlyCDB$ROOTandPDB$SEEDareupgraded.答案:B解析:-C是除了pdb225.Examinethisconfiguration:1).CDB1isanOracleDatabase12cRelease2databasecontainingpluggabledatabasesPDB$SEED,PDB1,andPDB2.2).PDB$SEEDisopenREADONLY.3).PDB1isopenREADWRITE.4).PDB2isMOUNTED.5).ORACLE_HOMEis/u01/app/oracle/product/18.1.0/dbhome_1.Youexecutethesemandsbeforeupgradingthedatabasetothecurrentrelease:Forwhichdatabaseswillfixupscriptsbecreated?$.oraenv

ORACLESID=[cdb1]?cdb1TheOraclebaseremainsunchangedwithvalue/u01/app/oracle

SSORACLEHOME/jdk/bin/java-jarpreupgrade.jarTERMINALTEXTA、CDB1,PDB$SEED,PDB1,andPDB2B、PDB$SEED,PDB1,andPDB2onlyC、CDB1andPDB$SEEDonlyD、CDB1,PDB1,andPDB2onlyE、CDB1,PDB$SEED,andPDB1only答案:E解析:升级之前需要打开所有的pdb,否则关闭的pdb是不包含在升级名单中。如果没有参数传递给preupgrade.jar,则它将针对所有容器数据库(CDB和PDB)运行。26.Inoneofyourdatabases,unifiedauditingisenabledandanSH.SALEStableexists.Yousuccessfullyexecutethesemands:

SQL>CREATEAUDITPOLICYsales_polACTIONSselectonsh.sales;SQL>AUDITPOLICYsales_pol;

WhichstatementistrueaboutSALES_POL?A、ItisenabledforallusershavingSELECTprivilegeonSH.SALES.B、OnlysuccessfulqueriesofSH.SALESarewrittentotheaudittrail.C、ItisonlyenabledforuserSH.D、Auditrecordsarealwaysstoredinanexternalauditfile.答案:A27.Choosethebestanswer.WhichstatementcorrectlydescribestheSQLprofilingperformedbytheSQLTuningAdvisor?A、Itisasetofremendationsbytheoptimizertochangetheaccessmethodsused.B、ItisauxiliaryinformationcollectedbytheoptimizerforaSQLstatementtoeliminateestimationerror.C、ItisasetofremendationsbytheoptimizertorestructureaSQLstatementtoavoidsuboptimalexecutionplans.D、ItisauxiliaryinformationcollectedbytheoptimizerforaSQLstatementtohelpusebetterjoinsorders.E、Itisasetofremendationsbytheoptimizertocreatenewindexes.答案:B28.Choosethebestanswer.Examinethisconfiguration:

1).CDB1isacontainerdatabase.

2).MON_USER_PREFIXissettoanemptystring.

3).PDB1isapluggabledatabaseinCDB1.

4).APP1_ROOTisanapplicationcontainerinCDB1.

5).APP1_PDB1isanapplicationPDBinAPP1_ROOT.Youexecutethesemands:

$sqlplussys/oraclelocalhost:1521/cdb1assysdbaSQL>CREATEROLErole1CONTAINER=CURRENT;

Whichistrue?A、ItwillreturnanerrorbecausecreationofalocalroleisnotallowedinCDB$ROOT.B、ROLE1willbecreatedonlyinCDB$ROOT.C、ItwillreturnanerrorbecausemonrolesmuststartwithC.D、ROLE1willbecreatedonlyinCDB$ROOTandAPP1_ROOT.E、ROLE1willbecreatedinCDB$ROOT,PDB1,APP1_ROOT,andAPP1_PDB1.答案:A29.InarecentAutomaticWorkloadRepository(AWR)reportforyourdatabase,younoticeahighnumberofbufferbusywaits.

Thedatabaseconsistsoflocallymanagedtablespaceswithfreelistmanagedsegments.

Onfurtherinvestigation,youfindthatbufferbusywaitsiscausedbycontentionondatablocks.Whichoptionwouldyouconsiderfirsttodecreasethewaiteventimmediately?A、DecreasingPCTUSEDB、DecreasingPCTFREEC、IncreasingthenumberofDBWNprocessD、UsingAutomaticSegmentSpaceManagement(ASSM)E、Increasingdb_buffer_cachebasedontheV$DB_CACHE_ADVICEremendation答案:D30.Choosethebestanswer.Examinethisconfiguration:

1).CDB1isanOraclecontainerdatabasefromanolderrelease.

2).PDB1,PDB2,PDB3,andPDB4arepluggabledatabasesinCDB1.AprioritylistUpgrdListhastheseentries:

1,pdb2

2,pdb1,pdb3

Youexecutethismand:

$/u01/app/oracle/product/18.1.0/db_1/rdbms/admin/dbupgrade-LUpgrdListInwhichorderwilltheupgradeoccur?A、CDB$ROOT,PDB$SEED,PDB2,PDB1,PDB3,andPDB4B、CDB$ROOT,PDB2,PDB1,andPDB3C、CDB$ROOT,PDB$SEED,PDB2,PDB1,andPDB3D、CDB$ROOT,PDB1,PDB2,PDB3,andPDB4E、CDB$ROOT,PDB$SEED,PDB1,PDB3,PDB2,andPDB4答案:C31.Examinethisconfiguration:

1).TheORCLdatabasedatafilesareinAutomaticStorageManagement(OracleASM)diskgroup+DATA.

2).ORCLusesdiskgroup+FRAfortheFastRecoveryArea.

3).LISTENERisthelistenerforORCL.

4).Thedatabase,listener,ASMinstance,andASMdiskgroupsaremanagedbyOracleRestart.

5).Allponentsarecurrentlyshutdown.

Youexecutethismand:Whatistheoute?A、TheORCLdatabase,theOracleASMinstances,the+DATAand+FRAdiskgroups,andtheLISTENERarestarted.B、OnlytheORCLdatabaseinstanceisstarted.C、OnlytheORCLdatabaseandtheASMinstancesarestarted.D、OnlytheORCLdatabaseinstance,theOracleASMinstance,andthe+DATAand+FRAdiskgroupsarestarted.E、OnlytheORCLdatabaseinstanceandthe+DATAand+FRAdiskgroupsarestarted.答案:A32.Examinetheseactions:

1).Createanewdatabaseforarecoverycatalog.

2).Createatablespacewithsufficientspaceinthecatalogdatabasefortherecoverycatalog.

3).ConfigureARCHIVELOGmodeforthecatalogdatabase.

4).Createausertoowntherecoverycatalogschemawithquotaonthetablespacethatwillcontainthecatalog.

5).GranttheRECOVERY_CATALOG_OWNERroletotherecoverycatalogschemaowner.

6).GranttheSYSBACKUPprivilegetotherecoverycatalogschemaowner.

WhicharetheminimumactionsthatmustbeperformedbeforeexecutingtheCREATECATALOGmand?A、2,4,5,6B、1,2,3,4,5,6C、1,2,4,5D、2,4,5E、1,3,4,5答案:D33.Choosethebestanswer.YouwanttotransporttheUNIVERSITYtablespacefromonedatabasetoanother.

TheUNIVERSITYtablespaceiscurrentlyopenread/write.

Thesourceanddestinationplatformshavethesameendianformat.Examinethislistofsteps:

1).MaketheUNIVERSITYtablespaceread-onlyonthesource

2).ExporttheUNIVERSITYtablespacemetadatausingEXPDP.

3).Createacross-platformbackupsetfromtheUNIVERSITYsourcesystem,usinganRMANmandthatincludestheDATAPUMPclause.

4).Copythecross-platformbackupsetstothedestinationsystem.

5).CopytheDataPumpdumpsetfromthesourcetothedestinationsystem.

6).Restorethecross-platformbackupsetonthedestinationsystemusinganRMANmandthatincludestheDATAPUMPclause.

7).ImporttheUNIVERSITYtablespacemetadatausingIMPDP.

8).MaketheUNIVERSITYtablespaceread/writeonthedestinationsystem.

Whicharetheminimumnumberofstepsrequired,inthecorrectorder,totransporttheUNIVERSITYtablespace?A、3,4,6B、2,3,4,5,6,7C、1,3,4,6,8D、1,2,3,4,5,6,7,8答案:C34.Younoticethattheperformanceofyourproduction24/7Oracle12cdatabasehassignificantlydegraded.Sometimesyouarenotabletoconnecttotheinstancebecauseithangs.Youdonotwanttorestartthedatabaseinstance.

Howcanyoudetectthecauseofthedegradedperformance?A、EnableMemoryAccessMode,whichreadsperformancedatafromSGA.B、UseemergencymonitoringtofetchdatadirectlyfromSGAforanalysis.C、RunAutomaticDatabaseDiagnosticMonitor(ADDM)tofetchinformationfromthelatestAutomaticWorkloadRepository(AWR)snapshots.D、UseActiveSessionHistory(ASH)dataandhanganalysisinregularperformancemonitoring,E、RunADDMindiagnosticmode.答案:B35.Choosethebestanswer.Examinethisconfiguration:

1).CDB1isacontainerdatabase.

2).APP_ROOTisanapplicationrootinCDB1.

3).APP_PDB1isanapplicationPDBinAPP_ROOT.

4).FLASHBACKDATABASEisON.

Youexecutethesemands:$sqlplussys/orac1e_4Ulocalhost:1521/cdb1SQL>SELECTcurrent_scnFROMv$database;

CURRENT_SCN

¡¡2074756

SQL>CREATETABLEcdb1_tab(c1NUMBER);

Tablecreated.

SQL>ALTERSESSIONSETCONTAINER=app_root;

Sessionaltered.

SQL>CREATETABLEapp_root_tab(c1NUMBER);Tablecreated.

SQL>ALTERSESSIONSETCONTAINER=app_pdb1;

Sessionaltered.

SQL>CREATETABLEapp_pdb1_tab(c1NUMBER);Tablecreated.

SQL>conn/assysdbaConnected.

SQL>ALTERPLUGGABLEDATABASEapp_rootCLOSE;

Pluggabledatabasealtered.

SQL>FLASHBACKPLUGGABLEDATABASEapp_rootTOSCN2074756;

Flashbackplete.

WhichtableorsetoftableswillexistaftertheFlashbackoperationhaspleted?A、CDB1_TAB,APP_ROOT_TAB,andAPP_PDB1_TABB、CDB1_TABandAPP_PDB1_TABC、CDB1_TABandAPP_ROOT_TABD、CDB1_TABonlyE、noneofthetables,becauseallthreetableswillbedropped答案:B36.Younoticethattheperformanceofyourproduction24x7Oracle12cdatabasehassignificantlydegraded.Sometimes,youarenotabletoconnecttothedatabaseinstancebecauseithangs.

Howcanyoudetectthecauseofthedegradedperformance?A、byperformingemergencymonitoringusingReal-TimeAutomaticDatabaseDiagnosticMonitor(ADDM)

TofetchdatadirectlyfromSGAforanalysisB、byrunningADDMtofetchinformationfromthelatestAutomaticWorkloadRepository(AWR)snapshotsC、byusingActiveSessionHistory(ASH)dataandperforminghanganalysisD、byrunningADDMindiagnosticmode答案:A37.AfterimplementingfullOracleDataRedaction,youchangethedefaultvaluefortheNUMBERdatatypeasfollows:

SQL>selectnumber_valuefromREDACTION_VALUES_FOR_TYPE_FULL;NUMBER_VALUE

0

SQL>execDBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1);

SQL>selectnumber_valuefromREDACTION_VALUES_FOR_TYPE_FULL;NUMBER_VALUE

-1

Afterchangingthevalue,younoticethatFULLredactioncontinuestoredactnumericdatawithzero.Whatmustyoudotoactivatethenewdefaultvaluefornumericfullredaction?A、Re-enableredactionpoliciesthatuseFULLdataredaction.B、Re-createredactionpoliciesthatuseFULLdataredaction.C、Re-connectthesessionsthataccessobjectswithredactionpoliciesdefinedonthem.D、Flushthesharedpool.E、Restartthedatabaseinstance.答案:E38.chooseoneYouwanttocreateatestdatabaseasareplicaofyourproductiondatabasewithminimuminterventionfromaDBA.

Whichmethodwouldyouuse?A、UseDBCAtocreateatemplatefromtheexistingdatabasetocontainthedatabasestructurewithdatafilesandthenusethesametemplatetocreatethedatabaseinthenewlocation.B、UseDatabaseConfigurationAssistant(DBCA)tocreateatemplatefromtheexistingdatabasetocontainthedatabasestructure.C、UseDBCAtocreateatemplatefromtheexistingdatabasetocontainthedatabasestructureandthenmanuallycopythedatabyusingOracleDataPump.D、CreatethedatabasebyusingtheCREATEDATABASE...mandandmanuallyimportdatabyusingDataPump.答案:A39.Choosethebestanswer.Examinethisconfiguration:

1).CDB1isacontainerdatabase.

2).DEFAULT_SHARINGisMETADATA.

3).APP_ROOTisanapplicationrootcontainedinCDB1.

4).APP_PDB1isanapplicationPDBcontainedinAPP_ROOT.

5).PANYAPPisanapplicationcontainedinAPP_ROOT.

6).EMPisamontablecreatedinAPP_ROOTandallitsapplicationPDBs,createdwhenversion1.0ofPANYAPPwasinstalled.

Youexecutethesemands:$sqlplussys/orac1elocalhost:1521/cdb1assysdbaSQL>ALTERSYSTEMSETDEFAULT_SHARING=DATA;

Systemaltered.

SQL>ALTERSESSIONSETCONTAINER=app_root;

Sessionaltered.

SQL>ALTERPLUGGABLEDATABASEAPPLICATIONpanyappBEGINUPGRADE'1.0'TO'2.0';

Pluggabledatabasealtered.

SQL>ALTERTABLEempADD(salNUMBERNOTNULL);

Tablealtered.

SQL>ALTERPLUGGABLEDATABASEAPPLICATIONpanyappENDUPGRADETO'2.0';

Pluggabledatabasealtered.

SQL>ALTERSESSIONSETCONTAINER=app_pdb1;

Sessionaltered.SQL>DESCemp;

NameNull?Type

ENONUMBER

ENAMEVARCHAR2(20)SQL>SELECT*FROMemp;

ENOENAME

100Alan

200Ben

SQL>ALTERPLUGGABLEDATABASEAPPLICATIONpanyappSYNC;

Whatwillbetheouteandwhy?A、SALwillbeaddedtoAPP_PDB1.EMP,with0incolumnsofexistingrows.B、SALwillbeaddedtoAPP_PDB1.EMP,withNULLsincolumnsofexistingrows.C、ItwillreturnanerrorbecausetheSYNCoperationisnotallowedwhenconstraintsareaddedtomonobjects.D、ItwillreturnanerrorbecauseEMPisnotemptyinAPP_ROOT.E、ItwillreturnanerrorbecauseEMP.SALisemptyinAPP_ROOT.答案:C40.Choosethebestanswer.Onthe10thofAugust,youimplementanincrementaldatabasebackupstrategyandconfigurearecoverywindowoffivedays.

Level0backupsaretakenonthe10th,17th,and24thofAugust.

Differentiallevel1incrementalbackupsaretakendailybetweenthelevel0backups.Todayisthe26thofAugust.

Whichbackupswillbeobsolete?A、allbackupspriorto10thofAugustB、allbackupspriorto22ndofAugustC、allbackupspriorto20thofAugustD、allbackupspriorto24thofAugustE、allbackupspriorto17thofAugust答案:E41.Yourproductiondatabaseisrunninginarchivelogmode.YouuseRMANwitharecoverycatalogtobackupyourdatabasetomediaandthedatabaseisuniquelyidentifiedintherecoverycatalog.Youwanttocreateatestdatabasefromtheproductiondatabaseandallowtheproductiondatabasetoremainopenduringtheduplicateprocess.Yourestorethedatabasebackupstoanewhostwiththesamedirectorystructureastheproductiondatabaseandwanttousetherecoverycatalogforfuturebackupsafterthedatabaseissuccessfullyrestoredtothenewhost.Howwouldyouachievethis?A、byusingtheRMANduplicatemandwithnofilenamechecktorecoverthedatabasetothenewhostB、byusingtheRMANswitchmandtosetthenewlocationforthedatafilesC、byusingtheRMANduplicatemandwithdbidandsetnewnamefortablespacetorecoverthedatabasetothenewhostD、bycreatinganewdatabaseinthenewhost,andthenusingtheRMANrecovermand答案:A42.Whatistheeffectofspecifyingthe"ENABLEPLUGGABLEDATABASE"clauseina"CREATEDATABASE"statement?A、Itwillcreateamultitenantcontainerdatabase(CDB)withonlytherootopened.B、ItwillcreateaCDBwithrootopenedandseedreadonly.C、ItwillcreateaCDBwithrootandseedopenedandonePDBmounted.D、ItwillcreateaCDBthatmustbepluggedintoanexistingCDB.E、ItwillcreateaCDBwithrootopenedandseedmounted.答案:B43.Examinethestatementsthatuseflashbacktechnologies:

1).FLASHBACKTABLEcustomersTOTIMESTAMPTO_TIMESTAMP('2013-02-0409:30:00','YYYYMM-DDHH:MI:SS');

2).SELECT*FROMcustomersASOFSCN123456;

3).FLASHBACKTABLEcustomersTOBEFOREDROP;

4).FLASHBACKDATABASETOTIMESTAMPTO_TIMESTAMP('2013-02-0409:30:00','YYYY-MM-DDHH:MI:SS');

5).SELECT*FROMcustomersVERSIONSBETWEENSCN123456AND123999;

6).ALTERTABLEcustomersFLASHBACKARCHIVE;

Whichsetofstatementsdependsontheavailabilityofrelevantundodataintheundotablespace?A、1,3,6B、1,2,5C、3,4,5D、2,3,5,6答案:B44.Choosethebestanswer.SQLPerformanceAnalyzer(SPA)hasreportedseveralregressedSQLstatementsforoneofyourdatabases.

WhichactioncouldhelpintheperformancemanagementoftheseregressedSQLstatements?A、CreateSQLplandirectivesforeachoftheregressedstatements.B、UseTheSQLTuningAdvisorforeachoftheregressedstatements.C、Createanadaptiveexecutionplanforeachoftheregressedstatements.D、UsetheSQLAccessAdvisorforeachoftheregressedstatements.答案:B45.ChoosethebestanswerYouwanttocreateaduplicatedatabaseDUP_DBfromyourproductiondatabasePRODonthesamehost.ThePRODdatabaseusesAutomaticStorageManagement(ASM)forstorage.RegularbackupsaretakenusingRMANconnectedtoarecoverycatalog.Youcreateanauxiliaryinstanceandwanttoexecutethemand:RMAN>DUPLICATETARGETDATABASETOdup_dbFROMACTIVEDATABASE;WhatisaprerequisiteforthesuccessfulexecutionofthismandA、RMANmustbeconnectedtothetargetdatabaseinstanceandtheauxiliaryinstance.B、AmostrecentbackupsetofthePRODdatabasemustexist.C、FlashbackmustbeenabledforthePRODdatabase.D、ThetargetdatabasemustbeinMOUNTstate.答案:A46.Choosethebestanswer.WhichoperatingsystemgroupisNOTneededtoperformanOracleDatabaseinstallation?A、OSASMB、OSRACDBAC、OSKMDBAD、OSDBAE、OSOPER答案:A47.AutomaticSharedMemoryManagementisdisabledforoneofyourdatabaseinstances.

SomeSQLstatementsperformpoorlyduetoexcessivehardparseactivity,thereby

温馨提示

  • 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

评论

0/150

提交评论