版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
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. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- GB/T 48464.1-2026微细气泡技术工业和消费类设备应用第1部分:基于气泡粒径和浓度评价微细气泡喷头性能的测试方法
- 初中七年级信息技术教学设计《图片处理与扉页制作》
- 初中八年级道德与法治第1单元走进社会生活期末复习教学设计
- 小学三年级科学第一单元研究土壤期中知识清单教学设计
- 初中心理健康教育九年级《情绪管理》教学设计
- 小学四年级劳动教育《巧手工艺坊·衣物架的制作》教学设计
- 小学二年级美术《落叶添趣》教学设计与实践探究
- 高中数学必修第四册《平面与平面垂直》教学设计
- 初中语文七年级下册《列夫·托尔斯泰》外貌描写与比喻修辞深度教学设计
- 高中政治一轮复习必修二经济与社会思维导图教学设计
- YY/T 0493-2026牙科学弹性体印模和咬合记录材料
- (2026)发展对象考试测试题库附参考答案
- 2026客服面试题及参考答案
- T/GDNSA 011-2025成人机械通气雾化吸入技术规范
- 人教版四年级(上)英语1-6单元语法专项训练
- 第6课 人民当家作主 第1课时 课件(内嵌视频)2026-2027学年道德与法治五年级上册统编版
- 药品经营和使用质量监督管理办法培训试题及答案
- 港口陆域形成施工方案
- 食材配送中心仓储管理操作手册
- 《新能源汽车电工电子技术》课程标准
- 中医胆囊结石护理要点说课
评论
0/150
提交评论