ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库400500之间题Word格式文档下载.docx
《ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库400500之间题Word格式文档下载.docx》由会员分享，可在线阅读，更多相关《ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库400500之间题Word格式文档下载.docx（49页珍藏版）》请在冰豆网上搜索。
B
Section:
（none）
QUESTION401
WhichcommandisusedtoconfigureRMANtoperformacompressedbackupforeverybackupexecuted?
BACKUPASCOMPRESSEDBACKUPSETDATABASE
BACKUPASCOMPRESSEDCOPYOFDATABASE
CONFIGUREDEVICETYPEDISKBACKUPTYPETOCOMPRESSEDBACKUPSET
CONFIGUREDEVICETYPEDISKBACKUPTYPECOMPRESS
E.
BACKUPDATABASECOMPRESS
C
QUESTION402
Youissuethefollowingcommand:
RMAN>
CONFIGUREBACKUPOPTIMIZATIONON;
Whatistheresultofthiscommandonyourbackups?
Anincrementalbackupstrategywillbeusedautomatically.
Read-onlydatafileswillnotbebackedupaslongasbackupsofthosefilesalreadyexistandthose
backupsmeetestablishedretentioncriteria.
RMANwillconfigureitselfformaximumperformanceatthecostofCPU.
RMANwillconfigureitselfforminimalOS/CPUimpactatthecostoftimetobackupthedatabase.
RMANwillautomaticallycompressbackups.
QUESTION403
WhatisthepurposeoftheRMANrecoverycatalog?
（Chooseallthatapply.）
ItmustbeusedbecauseallRMAN-relatedbackupandrecoverymetadatainformationiscontainedinit.
Itprovidesaconvenient,optional,repositoryofbackup-andrecovery-relatedmetadata.
ItprovidestheabilitytostoreRMANscriptsforglobalusebyanydatabasethathasaccesstotherepository.
ItprovidesameansofstoringallRMANbackupsetsphysicallyinanOracledatabaseserver.
Itprovidestheabilitytostorebackuprecordsformorethanayear.
BCE
QUESTION404
Whatprivilegesmustbegrantedtoallowanaccounttocreatetherecoverycatalog?
RECOVERY_CATALOG_OWNER
DBA
RESOURCE
SELECTANYDICTIONARY
CONNECT
AC
Explanation/Reference:
QUESTION405
Whichcommanddoyouusetocreatearecovery-catalogschema?
createrecoverycatalog
createcatalog
buildcatalog
catalogcreate
mountcatalog
QUESTION406
Ifyoubackupadatabasewithoutconnectingtotherecoverycatalog,whichoperationswillcausetherecoverycatalogtobeupdated?
Thenexttimeyoubackupthedatabasewhenyouarealsoconnectedtotherecoverycatalog
andthetargetdatabase
Thenexttimeyouareconnectedtothetargetdatabaseandtherecoverycatalogdatabaseand
issuetheresynccommand
ThenexttimeyouconnectRMANtojusttherecoverycatalog
ThenexttimeyouconnecttotherecoverycatalogandthetargetdatabasewithRMAN
Connectingtotherecoverycatalogandissuingtheresyncalldatabasescommand
AB
QUESTION407
Youhavecreatedascriptintherecoverycatalogcalledbackup_database.Whichofthefollowingcommandswouldsuccessfullyexecutethatscript?
run{openscriptbackup_database;
runscriptbackup_database}
run{engagescriptbackup_database;
}
run{runscriptbackup_database;
Run{executescriptbackup_database;
Thenamebackup_databaseisaninvalidnameforanRMANscript.TryingtorunitfromRMAN
wouldresultinanerror.
D
QUESTION408
Inwhatorderwouldyouexecutethefollowingstepstocreatearecoverycatalog?
Issuethecreatecatalogcommand.
Createtherecovery-catalogdatabase.
Createtherecovery-cataloguser.
Granttherecovery_catalog_ownerprivilegetotherecovery-cataloguser.
Issuetheregisterdatabasecommandfromthetargetdatabase.
F.
a,b,c,d,e
G.
b,a,d,c,e
H.
b,c,d,a,e
I.
b,c,d,e,a
J.
b,d,c,a,e
QUESTION409
HowwouldyougranttheRVPCuseraccesstospecificRMANdatabaserecordsintheRMANvirtualprivatecatalog?
IssuethegrantcommandfromtheSYSuser（orequivalent）ofthetargetdatabase.
IssuethegrantcommandfromtheSYSuser（orequivalent）oftherecovery-catalogdatabase.
Issuethegrantcommandfromtherecoverycatalog-owningschemauseraccountintherecoverycatalog.
IssuethegrantcommandfromRMANwhenconnectedtotherecoverycatalog-owningschema.
IssuethegrantcommandfromRMANwhenconnectedtothetargetdatabase.
QUESTION410
TheRVPCusercandowhichofthefollowing?
Registerdatabasesifgrantedtheregisterdatabaseprivilege
Seealldatabasesintherecovery-catalogschema
Seealldatabase-relatedmetadataintherecoverycatalogiftheyaregrantedaccesstothatdatabase
UnregisterdatabasesfromtheRVPCcatalogthatwerenotgrantedtotheRVPCcatalogownerwith
thegrantcommand
NotbeconnectedtowiththeRMANcommand-linecatalogparameterforbackuporrecoverypurposes
QUESTION411
Giventhescript
createscriptdb_backup_datafile_script
{backupdatafileand1,and2plusarchivelogdeleteinput;
}
Whatistheresultofrunningthiscommand?
Run{executescriptdb_backup_datafile_scriptusing2;
ThescriptwillfailsinceyouinstructedRMANtobackuponlyonedatafileratherthantwo.
Thescriptwillsuccessfullybackupdatafile3withouterror.
Thescriptwillfailsinceitusesasubstitutionvariablewhichisnotsupported.
Theexecutescriptcommandwillpromptforthevalueofand2sinceit'
snotincludedinthecommand.
Thescriptwillfailbecauseyoucannotusetheplusarchivelogcommandwhenbackingup
databasedatafiles.
QUESTION412
WhichisthecorrectwaytoconnecttoboththetargetdatabaseandtherecoverycatalogfromtheRMANcommandline?
AssumethatthetargetdatabaseiscalledORCLandthattherecoverycatalogdatabaseiscalledRCAT.Alsoassumethattherecovery-catalogowneriscalledRCAT_OWN.AssumetheenvironmentisconfiguredfortheORCLdatabase.（Chooseallthatapply.）
rmantarget=/catalog=/@rcat
rmantarget=/catalog=rcat_own/rcat_own
rmantarget=/catalog=rcat_own/rcat_own@RCAT
rmantarget=sys/robert@orclcatalog=rcat_own/rcat_own@RCAT
Youcannotconnecttothetargetdatabaseandtherecoverycatalogatthesametime.
CD
QUESTION413
Whatcommandwouldyouissuetoenableautomatedbackupsofcontrolfiles?
alterdatabasecontrolfileautobackupon
altersystemcontrolfileautobackupon
configurecontrolfileautobackupon
enablecontrolfileautobackup
QUESTION414
GiventhefollowingRMANcommands,choosetheoptionthatreflectstheorderrequiredtorestoreyourcurrentlyoperationalARCHIVELOG-modedatabase.
restoredatabase;
recoverdatabase;
shutdownimmediate
startup
restorearchivelogall;
alterdatabaseopen
a,b,c,d,e,f
c,b,a,d,e,f
c,b,a,d,f
c,a,b,d
K.
c,a,e,b,d,f
E
QUESTION415
WhichcommandsareusedforRMANdatabaserecovery?
restore
repair
copy
recover
replace
AD
QUESTION416
Givenacompletelossofyourdatabase,inwhatorderwouldyouneedtoperformthefollowingRMANoperationstorestoreit?
restorecontrolfile
restoredatabase
restorespfile
recoverdatabase
alterdatabaseopenresetlogs
b,a,c,d,e
a,c,b,d,f
c,a,b,d,e
c,a,b,d,f
e,a,b,d,c
QUESTION417
Ifyoulostyourentiredatabase,includingthedatabasespfile,controlfiles,onlineredologs,anddatabasedatafiles,whatkindofrecoverywouldberequiredwithRMAN?
Completedatabaserecovery.
Incompletedatabaserecovery.
Approximatedatabaserecovery.
Archiveddatabaserecovery.
ThedatabasecouldnotberecoveredwithRMAN.
QUESTION418
Whichcommandwillrestorealldatafilestothedate9/30/2008at18:
00hours?
restoredatafilesuntiltime'
09/28/2008:
21:
03:
11'
;
restoredatabasefilesuntiltime'
18:
00:
00'
restoredatabaseuntiltime'
recoverdatabaseuntiltime'
recoverdatabaseuntiltimestamp'
QUESTION419
Whatistheendresultofthesecommandsiftheyaresuccessful?
showretentionpolicy;
RMANconfigurationparametersfordatabasewithdb_unique_name
ORCLare:
CONFIGURERETENTIONPOLICYTOREDUNDANCY1;
#default
Backupdatabasetag=gold_copyplusarchivelogtag=gold_copydeleteinput;
Backupdatabasetag=silver_copyplusarchivelogtag=silver_copydeleteinput;
Attemptingtorestoresilver_copywillfail.
Attemptingtorestoregold_co
升级会员 