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