1z0062英文最新版.docx
《1z0062英文最新版.docx》由会员分享,可在线阅读,更多相关《1z0062英文最新版.docx(88页珍藏版)》请在冰豆网上搜索。
1z0062英文最新版
1.
Examinethedetailsoftheuncompressed,non-partitionedheaptableCITIES.
Namenulltype
CITYIDNOTNULLNUMBER(4)
CITY_NAMEVARCHAR2(50)
Examinethecommand:
SQL>ALTERTABLEcitiesSHRINKSPACECOMPACT;
Whatmustyoudobeforeexecutingit?
A)Makesurethatrowmovementisdisabled
B)Disableanyconstraintsonthetable.
C)Makesurethatrowmovementisenabled.
D)Makeanyinvisibleindexesonthetablevisible.
E)Makeallindexesonthetableinvisible.
答案:
C
解释:
段收缩前,保证表空间是ASSM,且启用了行移动
2.
AdatabaserunsinNOARCHTVELOGmode.
Backupschedulingforthisdatabasemustbeautomatedbeforeupgradingtoanewversionofthedatabase.
Whichtwotoolsorutilitiescandothis?
A)SOLDeveloper
B)DatabaseupgradeAssistant(DBUA)
C)OracleEnterpriseManagerCloudControl
D)OracleEnterpriseManagerDatabaseExpress(EMExpress)
E)DatabaseConfigurationAssistant(DBCA)
答案:
BC
解释:
DBUA在12的版本中加入特性,可以选择在升级的过程中执行RMAN备份。
3.
Youmustcreateatable,DAILY_ORDERS,foraDSSapplication.
Datashouldbecompressedwhenusingdirect-pathINSERTthetablewillalsobeusedforoccasionalDssqueries.
Loadperformanceiscritical
Whichcompressionoptionsatisfiestheserequirements?
A)COLUMNSTORECOMPRESSFORQUERYHIGH
B)ROWSTORECOMPRESSADVANCED
C)COLUNNSTORECOMPRESSFORQUERYLOW
D)COLUNNSTORECOMPRESSFORARCHIVEHIGH
E)COLUNNSTORECOMPRESSFORARCHIVELOW
答案:
B
行存储压缩
4.
Examinethesecommandsandoutput:
SELECTopen_modefromv$database;
------------------------------------
READWRITE
ARCHIVELOGLIST;
DatabaselogmodeNoarchiveMode
AutomaticarchiveDsiabled
ArchivedestinationUSE_DB_RECOVERY_FILE_DEST
Nowexaminethesesteps
1)STARTUPNOMOUNT
2)STARTUPMOUNT
3)STARTUPFORCE
4)ALTERDATABASEARCHIVELOG
5)ALTERDATABASEMOUNT;
6)ALTERDATABASEOPWENRESETLOGS
7)SHUTDOWNIMMEDIATE
8)ALTERDATABASEOPEN;
IdentifytherequiredstepsinthecorrectordertochangethedatabasetoruninARCHIBELOGmode.
A)7,1,4,5,6
B)7,2,4,8
C)3,4,8
D)7,2,4,6
E)3,4,6
答案:
B
Shutdownimmediate关库-启动mount-更改archivelog模式-open库
5.
AdatabaserunsinARCHIVELOGmode.
DailyfulldatabasebackupsaretakenwithRMANwhichisconfiguredtoperformcontrolfileautobackup.
Thecontrolfileandredologfilesaremulti-plexed
Inwhichtwocasesismediarecoveryrequired?
A)lossofonecopyofthecontrolfile
B)lossofallinactiveonlineredologgroupmembers
C)lossofdatafilesthatbelongtotheSYSAUXtablespace
D)physicalcorruptionofdata
E)lossofadatafilethatbelongstotheactiveundotablespace
答案:
CD
C属于SYSAUX表空间的数据文件丢失D数据的物理损坏
6.
Examinetheseconfigurationdetails:
1.AFastRecoveryArea(FRA)hasbeenspecifiedforadatabase.
2.ThedatabaseinstanceisinARCHIVELOGmode
3.ThedefaultlocationforarchivedredologfilesistheFRA.
WhichtwotypesoffilesareremovedautomaticallyduetospacepressureintheFRA?
A)obsoletespfiles
B)Mirroredcopiesofonlinelogs
C)expiredRMANdatabasebackupsets
D)flashbacklogs
E)expiredRMANimagecopies
F)obsoleteRMANdatabasebackupsets
答案:
AF
解释:
expired是本来RMAN以为存在但是实际上在磁盘或者磁带上已经被删除了的文件。
A过时spfilesF过时RMAN数据库备份集
7.
Examinethisconfigurationforoneofyourdatabases:
1.UNDO_RETENTIONparameteris1000
2.retentionisnotguaranteed
3.theundotablespaceisfixedsize.
Whichtwostatementsaretrue?
A)Inactiveundoisretainedforatleast1000secondsiffreeundospaceisavailable.
B)Activeundoisretainedforonlyfor1000seconds.
C)Expiredundoisretainedfor1000secondseveniftransactionsfailduetolackofspaceintheundotablespace.
D)Inactiveundoisretainedfor1000secondseveniftransactionsfailduetolackofspaceintheundotablespace.
E)Activeundoneverbecomesexpired.
答案:
AE
A如果空闲的撤销空间可用,非活动的撤销将保留至少1000秒
E活动撤销永远不会过期。
8.
YoumustupgradeyourOracle11gDatabasetoOracle12cR2.Whichmethodcanyouuse?
A)UseEnterpriseManagerExpress.
B)UseSQL*Developer
C)UsetheDatabaseCreationAssistant(DBCA)toupgrade
D)PerformadirectupgradebyrunningtheDatabaseUpgradeAssistant(DBUA).
E)Performarollingupgrade.
答案:
D
通过运行数据库升级助手(DBUA)执行直接升级。
9.
Examinethecommand:
SQL>CREATETABLESPACEtest1DATAFILE‘/u01/app/oracle/oradata/orcl/test1.dbf’SIZE5MAUTOEXTENDONAUTOALLOCATE;
Whichtwostatementsaretrue?
A)Thetablespace,TEST1,canhaveallocatedextentsofdifferentsizes
B)Thetablespace,TEST1,canhavefreeextentsofdifferentsizes
C)Tablespacefreespaceistrackedinthedatadictionary.
D)Datafile,TESTO1.DBF,canautoextendtoamaximumsizeof5M.
E)Allocatedandfreeextentsizesarealwaysmultiplesof1M.
答案:
AC
10.
Whichtwocanbeusedtocreateandpopulateatablefromthecontentsofatextualflatfile?
A)UseCREATETABLE...ASSELECTfromanORACLEDATAPUMPtypeexternaltable.
B)UseSQL*LOADERconventionalpathload.
C)UseSQL*LOADERdirectpathload.
D)UseDATAPUMPimport.
E)UseCREATETABLE...ASSELECTfromanORACLELOADERtypeexternaltable.
答案:
AE
解释:
SQL*LOADER不能创建表。
11.
AnewdatabasehasnoRMANbackupsyet.
Examinethesecommands:
CONFIGURERETENTIONPOLICYTOREDUNDANCY2;
RMAN>BACKUPTABLESPACESYSTEM;
..
backupsetcomplete,elapsedtime:
00:
00:
03
..
RMAN>BACKUPTABLESPACESYSTEM,SYSAUX;
..
backupsetcomplete,elapsedtime:
00:
00:
04
RNAN>BACKUPDATABASE
..
backupsetcomplete,elapsedtime:
00:
00:
07
..
Whichtwoaretrueabouttheexecutionofthethirdbackupcommand?
A)AbackupisperformedfortheSYSTEM(改成SYSAUX)tablespace.
B)AbackupisnotperformedfortheSYSAUXOrSYSTEMtablespaces.
C)ThefirstbackupoftheSYSTEMtablespaceisconsideredexpired.
D)ThefirstbackupoftheSYSTEMtablespaceisalwaysconsideredobsolete.
E)ThefirstbackupoftheSYSTEMtablespaceisconsideredexpiredbydefault
F)ThefirstbackupoftheSYSTEMtablespaceisalwaysconsideredexpired.
答案:
AC
注释:
REDUNDANCY2代表设置配置两份
C(考试中这里加了default)系统表空间的第一次备份被认为过期了。
印刷错误expledxplired,应为expired
12.
Examinethiscommand:
SQL>ALTERSYSTEMSETENABLE_DDL_LOGGING=TRUE;Whichtwostatementsaretrue?
启动DDL日期记录=TRUE
A)AllDDLstatementsareloggedintoatextfileinAutomaticDiagnosticRepository(ADR)home
B)Somedatadefinitionlanguage(DDL)statementsarewrittentothecontrolfile.
C)Alldatadefinitionlanguage(DDL)statementsarewrittentothecontrolfile.
D)SomeDDLstatementsarewrittentoatextfileintheADRhome.
E)TheAlertLogstillcontainssomeDDLstatements.
F)SomeDDLstatementsarewrittentoanXML.,fileintheADRhome.
答案:
DF
D写入到ADRhome中的TEXT文件中
F写入到ADRhome中的XML文件中
13.
WhichtwostatementsaretrueaboutOraclenetworkconnections?
A)Alistenermaysometimesbelisteningonbehalfofonlyonedatabaseinstance
B)Thelistenercanspawnanewserverprocesstodealwithanewconnection.
C)Thelistenercontinuouslymonitorsaconnectionaftertheuserprocessconnectstoaservicehandler.
D)Aconnectionrequestfromaremoteclientisalwaysfirstreceivedbyalistenerlisteningonport1521.
E)Thelistenerchecksauser'sauthenticationcredentialsandcreatesasessionifthecredentialsarevalid.
答案:
BE
考点:
oracle侦听器网络连接
B侦听器可以生成一个新的服务器进程来处理新连接。
E侦听器检查用户的身份验证凭据,如果凭据有效,则创建会话
14.
Whichfouraretrueaboutcreatingandrunningaremotedatabaseschedulerjobs?
A.Adatabasedestinationmustexistorbecreatedfortheremotedatabase.
B.Adatabasedestinationgroupmustexistorbecreatedforajobtorunonmultipleremotedatabases.
C.Acredentialisoptionalforaremotedatabasejob.错必须要有安全凭证不然会被终止连接
D.Itmustrunasauserthatisdefinedontheremotedatabase.
E.AdestinationisoptionalforaremotedatabasejobbecauseDBlinkscanbeusedinstead.错必须是安全验证通过的制定标
F.Acredentialmustbecreatedtodefinetheremoteuser.
G.Remotedatabasejobsalwaysrunasthesameuserwhosubmitsthejobonthelocaldatabase.错可以不同同一身份
ANS:
ABDF
中文翻译:
关于创建和运行远程数据库调度程序作业,哪四个是正确的?
A.数据库作业必须为远程数据库创建且存在。
B.要在多个远程数据库上运行作业,必须存在或创建数据库目标组。
C.安全凭证对于远程数据库作业是可选的。
D.它必须以在远程数据库上定义的用户身份运行。
E.对于远程数据库作业,标是可选的,因为可以代替使用DBlinks。
F.必须创建一个凭证来定义远程用户。
G.远程数据库作业始终以在本地数据库上提交作业的同一用户身份运行。
15.
whatisarequirementforcreatingaremotedatabaseschedulerjob?
A.Theremotedatabasejobmustrunasauserthatisvalidontargetremotedatabase
B.Aprivatedatbaselinkmustbecreatedfromtheoriginatingdatabasetothetargetremotedatabase不用私有只要能连接就行
C.ThetargetremotedatabaseonwhichthejobisshceduledmustbeOracleDatabase11gRelease2orlater11.1以上版本就支持了
D.Thetargetremotedatabasemustbeonadifferenthostfromtheoriginatingschedulerdatabasehost可以在同一台主机不同的实例下
ANS:
A
中文翻译:
创建远程数据库调度程序作业有什么要求?
A.远程数据库作业必须是对目标远程数据库有效的用户身份运行
B.从原始数据库到标远程数据库必须创建一个私有的datbase链接,
C.对其进行任务调度的标远程数据库必须是OracleDatabase11g第2版或更高版本
D.标远程数据库必须与原始调度程序数据库主机位于不同的主机上
16.
WhichtwostatementsaretrueaboutSQL*LoaderExpressModeinanOracle12cdatabase?
A.ItloadsdatafasterthanconventionalSQL*Loader.错官方文档没有说明
B.ItrequiresEnterpriseManagerExpresstobeconfigured.错不需要企业管理器
C.ItloadsdatamoreefficientlythanconventionalSQL*Loader.错官方文档没有说明
D.Itcanloaddatainparallel.
E.Nodatafileneedstobespecified.
ANS:
DE
中文翻译
关于Oracle12c数据库中的SQL*LoaderExpressMode,以下哪两个陈述是正确的?
A.它比传统的SQL*Loader更快地加载数据。
B.它要求配置EnterpriseManagerExpress。
C.比传统的SQL*Loader加载数据效率更高。
D.它可以并行加载数据。
E.无需指定数据文件。
17.
WhichthreestatementsaretruePFILES,SPFILESorboth?
A.SPFILESandPFILESmaybothbeeditedwithanO/Seditingutility.错SPFILE是二进制的无法直接编辑
B.AllSPFILEparameterscanbemodifiedsuccessfullywiththeSCOPE=MEMORYclause.加载进内存的参数是有限制的不是全都能用
C.SomeSPFILEparameterscanbemodifiedsuccessfullywiththeSCOPE=MEMORYclause.
D.APFILEcanbecreatedbyanidleinstance.
E.ASPFILEcanb