OCP考试052最新考试题库原题20518.docx
- 文档编号:7068030
- 上传时间:2023-01-16
- 格式:DOCX
- 页数:5
- 大小:17.66KB
OCP考试052最新考试题库原题20518.docx
《OCP考试052最新考试题库原题20518.docx》由会员分享,可在线阅读,更多相关《OCP考试052最新考试题库原题20518.docx(5页珍藏版)》请在冰豆网上搜索。
OCP考试052最新考试题库原题20518
052题库解析
OCP考试052最新考试题库原题-2-20180518
题库新特点:
●更加灵活,题库的顺序与考试时的顺序每场都在变化
●更加考验知识点的掌握,题库答案为二,考试时要求选择
最佳一个答案
●不断有新的考题出现,目前最新已经更新到130道题
1、.WhichtwoaretrueabouttheArchive(ARCn)processes?
❑A)Theyautomaticallydeleteobsoletearchivelogstomakespacefornewarchivelogs.
❑B)TheyareusedduringInstancerecovery.
❑C)Theyarchiveredodirectlyfromtheredologbuffer.
❑D)TheyareenabledonlywhenthedatabaseIsInARCHTVELOCmode.
❑E)Theycreatearchivelogsaftereverylogswitch.•Answer:
DE
2、WhichtwoaretrueaboutOptimizerStatistics?
❑A)TheydonotpersistacrossInstancerestarts.
❑B)TheyareautomaticallyupdatedwhenDDLstatementsexecute.
❑C)TheyaregatheredbytheManageabilityMonitor(MMON)backgroundprocess.
❑D)TheycanbegatheredbyexecutingthePL/SQLproceduresintheDBMS_STATSpackage.
❑E)Theycanbeusedtodeterminetheeventsonwhichadatabaseinstancewaited.
❑F)TheyprovideInformationtotheOptimizersothatitcandetermineoptimalexecutionplansforSQLstatements.
•Answer:
DF
3、Whichstructurecanspanmultipledatafiles?
❑A)apermanenttablespace
❑B)abigfiletablespace❑C)atemporarytablespace❑D)asegment
❑E)anextent
•Answer:
ACD
4、Forwhichrequirementshouldyouconfiguresharedservers?
❑A)accommodatinganincreasingnumberofuserswhorunshort-duration,infrequentqueriesinanOLTPenvironmentwithlimitedmemory
❑B)accommodatinganincreasingnumberofuserswhorunanalyticalqueriesinaDSSenvironmentwithlimitedmemory
❑C)submittingbackupjobsatregular,24-hourIntervalsinanOLTPenvironmentwithlimitedmemory
❑D)performingbulk-loadoperationsinaDSSenvironmentwithlimitedmemory
❑E)usingRecoveryManager(RMAN)torecoveradatabase•Answer:
A
5、Whichtwoaffectthetimetakenforinstancerecovery?
❑A)sizeofredologs
❑B)sizeofUNDOtablespace❑C)FAST_START_MTTR_TARGETvalue❑D)sizeofarchivelogs
❑E)sizeofexistingRMANbackupsets❑F)UNDO_RETENTIONvalue•Answer:
AC
6、YouareinstallingOracleGridInfrastructurebyusingtheOracleUniversalInstaller(OUI).
Youselectthe"InstallandConfigureGridInfrastructureforaStandaloneServer"option.
WhichtaskisperformedbyOUIaspartofthisinstallation?
❑A)creationandconfigurationofEnterpriseManagerCloudControlontheserver
❑B)creationofprivilegedoperatingsystemgroupsthatareusedforOSauthentication
❑C)creationofageneralpurposedatabase
❑D)creationofanASMdiskgroupandregistrationofASMcomponentswithOracleRestart
•Answer:
D
7、Whichistrueaboutexternaltables?
❑A)TheORACLE_DATAPUMPaccessdrivercanbeusedtowritedatatoexternaltables.
❑B)Segmentsareallocatedforexternaltables.❑C)Theydonotsupportpartitioning.❑D)TheymayhaveIndexes.
❑E)DMLoperationsmaybeperformedonexternaltables.•Answer:
C
8、WhichtwoaretrueabouttheFastRecoveryArea(FRA)?
❑A)Itshouldbelargerthanthedatabase.
❑B)SpacemanagementIntheFRAIsInfluencedbythedatabasebackupretentionpolicy.
❑C)AdatabasemustbeinARCHIVELOGmodetousetheFRA.
❑D)Itmustresideonthesamefilesystemasthedatabasedatafiles.
❑E)OnlyconsistentbackupscanbestoredintheFRA.•Answer:
AB
9、WhichistrueabouttheAutomaticDiagnosticRepository(ADR)?
❑A)Itincludesdiagnosticdataforcriticalerrorsforeachserverandbackgroundprocess.
❑B)ItslocationisalwayssetbytheORACLE_BASEvariable.❑C)ItisusedonlyiftheDIAGNOSTIC_DESTparameteris
manuallyconfigured.
❑D)Itonlycontainsthealertlogandtracefilesforbackgroundprocesses.
•Answer:
A
10、Whichtwoaretrueaboutconsistentdatabasebackups?
❑A)TheycanonlybetakenwhenaRECOVERYCATALOGisused.
❑B)TheycanonlybetakenifthedatabaseIsinARCHIVELOGmode.
❑C)TheycanonlybetakenIfshutdownNORMAL,TRANSACTIONAL,orIMMEDIATEshutdownhasbeenperformedandthebackupistakenbeforethedatabaseisreopened.
❑D)TheycanonlybetakenbyusingRMANcommands.❑E)TheycanonlybetakenbyusingRMANwhenthedatabase
isinMOUNTstate.
•Answer:
CE
11、WhichthreearetrueaboutUNDOdata?
•❑A)Itisusedtorollbackfailedtransactions.
•❑B)ItisusedtorewindadatabasebyusingFLASHBACK
DATABASE.
•❑C)ItisusedtorecoverdroppedtablesbyusingFLASHBACK
TABLE…TOBEFOREDROP.
•❑D)ItisusedtoenableROLLBACKstatementstorollback
uncommittedupdates.
•❑E)Itisusedtoprovidereadconsistency.
•❑F)Itisusedduringonlinebackupstoguaranteetheir
consistency.
•Answer:
ADE
12、WhichtwotypesofInformationcanbefoundinthealertlog?
•❑A)instancerecoverydetails
•❑B)arecordofallDDLstatementsperformedbynon-DBA
users
•❑C)arecordofallactionsperformedbySYSandSYSTEM•❑D)criticalerrorsencounteredbybackgroundprocesses•❑E)valuesofallInitializationparameterswheneveran
InstanceIsrestarted
•Answer:
AD
13、WhichtwoaretrueaboutAWRsnapshots?
•❑A)TheyarestoredIntheSYSAUXtablespace.
•❑B)TheyarenotgeneratedifSTATISTICS_LEVELIssetto
TYPICAL.
•❑C)TheycanbemodifiedbyusingDMLs.•❑D)Theycanberetainedforever.•❑E)Theyarealwayscreatedautomatically.•Answer:
AD
14、Whichcommandisusedtodisplayfilesthatnolongerconformtothebackupretentionpolicy?
•❑A)REPORTOBSOLETE•❑B)SHOWDATAFILEBACKUPCOPIES•❑C)CROSSCHECKBACKUP•❑D)LISTEXPIREDBACKUP•Answer:
A
•15、Whichtwoaretrueaboutspacemanagementin
tablespaces?
•❑A)LocallymanagedtablespaceshaveeitherASSMormanualsegmentspacemanagement(MSSM),andallthesegmentsinthesetablespacesaremanagedonewayortheother.
•❑B)Locallymanagedtablespacestrackadjacentfreespace
automaticallybyusingbitmaps.
•❑C)Extentallocationmustbespecifiedasautomaticfor
automaticsegmentspacemanagement(ASSM)tablespaces.
•❑D)ASSMtablespacespreventrowchaining.
•❑E)Freelistsareusedformanagingfreespaceforsegments
inlocallymanagedtablespaces.
•Answer:
AB
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- OCP 考试 052 最新 题库 20518