OCP考试052最新考试题库原题40601.docx
《OCP考试052最新考试题库原题40601.docx》由会员分享，可在线阅读，更多相关《OCP考试052最新考试题库原题40601.docx（6页珍藏版）》请在冰豆网上搜索。
OCP考试052最新考试题库原题40601
052题库解析
OCP考试052最新考试题库原题-4-20180601
题库新特点：
更加灵活，题库的顺序与考试时的顺序每场都在变化
更加考验知识点的掌握，题库答案为二，考试时要求选择
最佳一个答案
不断有新的考题出现，目前最新已经更新到130道题
1、YourdatabaseIsconfiguredInarchivelogmode.TheUSERS01tablespaceIscurrentlyonline.Youarerequiredtotakethetablespaceoffline.
WhichclauseorclausesensurethatnomediarecoveryisrequiredwhenthetablespaceIsbroughtbackonline?
•❑A）eithertheNORMALortheTEMPORARYclause•❑B）onlytheNORMALclause
•❑C）onlytheTEMPORARYclause•❑D）eithertheNORMALortheIMMEDIATEclause•❑E）onlytheIMMEDIATEclause•Answer:
B
1offlinetemporary表空间时，如果表空间中没有offline的数据文件，则online该表空间时不需要介质恢复。
2offlinetemporary表空间时，不会对已经offline的数据文件执行检查点操作，仅仅对online的数据文件执行检查点操作
3offlinetemporary表空间时，对于离线表空间之前已经offline的数据文件，则online该表空间时，offline数据文件需要介质恢复。
•2、Whichtwostatementsaretrueabouttablespaces?
•❑A）Adatabasecancontainmultipleundotablespaces.
•❑B）Adatabasecancontainonlyasingletemporary
tablespace.
•❑C）AdatabaseinstancestoresundodataIntheSYSTEM
tablespaceIfnoundotablespaceexists.
•❑D）AdatabaseinstancehangsIftheSYSAUXtablespace
becomesunavailable.
•❑E）AdatabasewithalocallymanagedSYSTEMtablespace
canhavedictionary-managedusertablepaces.
•Answer:
AE
•3、YouwanttoInstallOracle11gdatabasesoftwareand
createadatabaseonASMImmediatelyaftertheInstall.
YourplanistoinstallbothOracledatabaseandGridInfrastructure.Whichtwoaretrueinthisscenario?
•❑A）GridInfrastructuremustbeinstalledfirst.
•❑B）BothproductsmustbeInstalledbythesameOSuser.•❑C）EachproductmustbeInstalledInadifferent
ORACLE_HOME.
•❑D）BothproductscansharetheOSgroupassignedtotheir
OSDBAandOSOPERprivilegedgroups
•❑E）Bothproductsmustbeinstalledbyusingthesame
ORACLE_BASE.
•❑F）Bothproductsmustbeofthesameversion.•Answer:
AC
4、WhichistrueaboutinvalidPL/SQLobjects?
•❑A）Theyareautomaticallyrecompiledagainstthenewdefinitionofareferencedobjectatthesametimeasthereferencedobjectismodified.
•❑B）TheycanbemanuallyrecompiledonlybyusingSQL
commands.
•❑C）Theyareautomaticallyrecompiledagainstthenew
definitionofareferencedobjectwhentheyarecalled.
•❑D）TheymustbemanuallyrecompiledbeforetheycanbeusedifaDDLisperformedonatablethatisreferencedinthePL/SQLobject.
•Answer:
D
5、WhichistrueabouttheSYSTEMandSYSAUXtablespaces?
•❑A）TheSYSAUXtablespacecanbemaderead-onlybutthe
SYSTEMtablespacecannot.
•❑B）Bothtablespacescanbeusedfortemporarystorageifno
temporarytablespaceisdefined.
•❑C）OnlytheSYSTEMtablespacecontainsdatadictionary
tables.
•❑D）Bothtablespacesmustbeonlineforadatabasetobe
accessible.
•Answer:
A
6、Whichtwoaretrueaboutroles?
•❑A）Arolecanbepassword-protected.
•❑B）Arolecanbegrantedtoanotherrole.
•❑C）Onlyonedefaultrolecanbegrantedtoauser.
•❑D）Arolecanbegrantedonlymultiplesystemprivilegesnot
multipleobjectprivileges.
•❑E）ArolecanbecreatedonlybyauserwiththeSYSDBA
privilege.
•Answer:
AB
7、YouareplanningasoftwareinstallationforbothOracleDatabase11gRelease1andRelease2.
YouplantohaveatleaseonedatabaseforeachreleasemanagedbyGridInfrastructureforaStandaloneServer.
Whichthreearetrueinthisscenario?
•A）Oracle11gRelease1databasesmustbemanagedbyGridInfrastructure
11gRelease1.
•B）BothdatabasescanbemanagedbyGridInfrastructure11gRelease2.
•C）BothOracleversionsandGridInfrastructurecanbeownedbythesame
O/Saccount.
•D）GirdInfrastructuremustbeinstalledbeforebothOracleDatabase
versions.
•E）Eachversionofthedatabasemaybemanagedbyaseparateversionof
GridInfrastructure.
•F）BothOracleversionsandGridInfrastructurecanbeinstalledunderthe
sameORCALE_BASE.
•Answer:
ADE
•
8、Whichtwoaretrueaboutdatadictionaryanddynamicperformanceviews（v$views）?
•A）AlldatabaseusershaveaccesstoALL_*views.
•B）Datadictionaryviewoutputissubjecttoreadconsistency.•C）ThedefiningqueriesforOraclesupplieddynamic
performanceviewsarestoredInthedatadictionary.
•D）Allv$viewsdisplayoutputwhenqueries,iftheinstanceisin
nomountstate
•E）Alldatabaseusershaveaccesstoallv$views.•Answer:
AB
9、YOURDB_RECOVERY_FILE_DEST_SIZEIs8G.
Currently,5GofthespaceIsusedofwhich4Gconsistsofobsoletebackups.
Youexecutethiscommand:
SQL>ALTERSYSTEMSETdb_recovery_file_dest_size=2G;Whatistheoutcome?
•A）ItchangesDB_RECOVERY_FILE_DEST_SIZEto5G.
•B）ItchangesDB_RECOVERY_FILE_DEST_SIZEto2Gwithout
deletingvalidbackups.
•C）ItfallsbecauseDB_RECOVERY_FILE_DEST_SIZEisastatic
parameter.
•D）ItchangesDB_RECOVERY_FILE_DEST_SIZEto2Ganddeletes
theobsoletebackups.
•E）Itfailsbecausethenewsizeislessthan5G.•Answer:
D
10、Whichistrueaboutlogicalandphysicaldatabasestructures?
（Choosethebestanswer）
•A.Anundotablespacehasatempfileinsteadofadatafile.•B.Asegmentcanconsistofextentsofdifferentsizes.
•C.Apermanenttablespacecanonlycontaintablessegments
andindexsegments.
•D.Atablespacecanconsistofdatablocksofdifferentsizes.•E.Anextentalwaysconsistsofphysicallycontiguousdata
blocksinstorage.
•CorrectAnswer:
B
•11、Inwhichstatecanyoubackupadatabasein
ARCHIVELOGMODEusingRMAN?
•A.NOMOUNT,MOUNT,ANDOPEN•B.NOMOUNTANDMOUNTONLY•C.OPENONLY
•D.MOUNTANDOPENONLY•E.OPENRESTRICTEDONLY•CorrectAnswer:
D
12、Examinethesefactsaboutadatabase:
1.USERSisthedatabasedefaulttablespace.
2.USER1,USER2,ANDUSER3havetheCREATESESSIONprivilege.
3.TheyalsohaveUNLIMITEDQUOTAonthedefaulttablespaceUSERS.
4.Theyhavenootherprivileges.Examinethesecommands:
SQL>conn/assysdbaConnected.
SQL>GRANTCREATETABLETOuser1WITHADMINOPTION;Grantsucceeded.
SQL>connuser1/oracle_4UConnected.
SQL>GRANTCREATETABLETOuser2;Grantsucceeded.
SQL>GRANTCREATETABLETOuser3WITHADMINOPTION;Grantsucceeded.
12、Whichtwoaretrue?
•A.Anyuserwithcreatetablewithadminoptioncanrevokecreatetable
fromuser1.
•B.IfSYSrevokescreatetablefromuser1,itisrevokedfromuser2butnot
fromuser3.
•C.OnlySYSandUSER1canrevokeCREATETABLEfromUSER3.•D.OnlySYSCANREVOKECREATETABLEFROMUSER1.
•E.IfSYSrevokescreatetablefromuser1,itisnotrevokedfromUSER2and
USER3.
•CorrectAnswer:
AE
13、Whichtwoaretrueaboutexternaltables?
•A.TheysupporttheORACLE_DATAPUMPaccessdriver.•B.Theyhaveextents.
•C.TheysupportallDMLoperations.•D.TheycanalwaysbeupdatedusingSQL.•E.TheycanbestoredinanASMClusterFileSystem（ACFS）.•CorrectAnswer:
AE
14、Inoneofyourdatabases:
*ThedatabasedefaulttablespaceisEXAMPLE.*Deferred_segment_creationisfalse.Examinethesecommands:
SQL>createuseruser1identifiedbyoracle_4upasswordexpire;Usercreated.
SQL>alteruseruser1accountunlock;Useraltered.
SQL>grantcreatesessiontouser1;Grantsucceeded.
SQL>grantcreatetabletouser1withadminoption;Grantsucceeded.
14、
Whichthreearetrue?
•A.user1canlogintothedatabaseinstance.•B.user1cangrantthecreatetableprivilegetootherusers.•C.user1cancreatetablesintheexampletablespace.•D.user1mustchangeit’spasswordatfirstlogin.•E.user1cancreateindexesinexampletablespace.•CorrectAnswer:
ABD
15、Whichistruewhenadatabaseinstanceisshutdown?
•A.Onlytransactionalandnormalmodeswaitforalluncommittedtransactionstocommitorrollbackandthenclosethedatabase.
•B.Immediate,transactional,andnormalmodesallresultina
checkpoint.
•C.Neithertheimmediatenortheabortmoderollsback
uncommittedtransactions.
•D.Immediate,transactional,andnormalmodeswaitforalluncommittedtransactionseithertocommitorrollbackandthenclosethedatabase.
•CorrectAnswer:
AB
升级会员 