ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库400500之间题Word格式文档下载.docx
- 文档编号:18644190
- 上传时间:2022-12-30
- 格式:DOCX
- 页数:49
- 大小:31.04KB
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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库400500之间题 11 管理 Z0053 题库 400500 之间
链接地址:https://www.bdocx.com/doc/18644190.html