OCP考试052最新考试题库原题110817Word文档下载推荐.docx

OCP考试052最新考试题库原题110817Word文档下载推荐.docx

《OCP考试052最新考试题库原题110817Word文档下载推荐.docx》由会员分享，可在线阅读，更多相关《OCP考试052最新考试题库原题110817Word文档下载推荐.docx（7页珍藏版）》请在冰豆网上搜索。

B）Thechangeoccursimmediatelyinmemoryforstaticparametersbutitisnotpersistentafter

instancerestart.

C）Thechangeoccursimmediateinmemoryfordynamicparametersbutitisnotpersistentafter

D）Incanbeusedonlyifanspfileisused.

C

72.whichthreestatementsaretrueaboutinitializationparametersandfiles?

A）AnidleinstancemuststartwithaPFILE.

B）SessionmodifiableinitializationparameterscanonlybechangedbyauserwiththeDBArole.

C）TheALTERSYSTEMcommandcanbeusedtochangeparametervaluesforaninstancestarted

usingaPFILE.

D）AnSPFILEcanbecreatedfromanidleinstance.E）Sessionmodifiableinitializationparameterscanonlybechangedoncepersession.

F）TheALTERSYSTEMcommandcanbeusedtochangeparametervaluesforaninstancestarted

usinganSPFILE

G）SystemmodifiableinitializationparameterscanonlybechangedbytheSYSuser.

DFG

⼆十⼀一.Backup

73.TableEMPresidesintheUSERStablespace.Examinethiscommand:

SQL>

DROPTABLEempPURGE;

WhichtwomethodswouldyouusetorecoverEMP?

A）FlashbackTable.

B）re-creatingthetableandreinsertingtherows.C）performingatablespacepointintimerecoveryofUSERS.D）FlashbackTransactionBackout.

E）FlashbackDrop.

BC

74.Whichtwoaretrueaboutconsistentdatabasebackups?

A）TheycanonlybetakenbyusingRMANcommands.B）TheycanonlybetakenbyusingRMANwhenthedatabaseisinMOUNTstate.

C）TheycanonlybetakenwhenaRECOVERYCATALOGisused.D）TheycanonlybetakenifthedatabaseisinARCHIVELOGmode.E）TheycanonlybetakenifaNORMAL,TRANSACTIONAL,orIMMEDIATEshutdownhasbeenperformedandthebackupistakenbeforethedatabaseisreopened.

BE

75.Whichfouraretrueaboutconsistentdatabasebackups?

A）TheycanonlybetakenusingO/Sutilitiesifthedatabaseisinmountstate.

B）TheycanonlybetakenusingRMANwhenthedatabaseisinmountstate.

C）TheycanbetakenusingO/Sutilities.

D）TheycanonlybetakenusingRMANwhenthedatabaseinstanceisshutdown.

E）Theycanbetakenifthedatabaseisinarchivelogmode.F）Theycanbetakenbyusingrmancommands.

G）Theycanbetakenifthedatabaseisinnoarchivelogmode.

CEFG

76.Whichthreecanbeusedtoscheduleautomatedbackupsofthedatabase?

A）acronjob

B）EnterpriseManagerDatabaseControlC）DBMS_SCHEDULERD）DBMS_BACKUP_RESTOREE）expdpF）RMAN

ABC

77.WhichfourcanbeusedtoscheduleautomatedbackupsofanOracledatabase?

A）dataGuardB）DBMS_JOB

C）EnterpriseManagerD）anacronjobs

E）cronjobs

F）AutomaticStorageManagement（ASM）

BCDE

78.Whichtwotoolsorutilitiescanbeusedtoconfigureandscheduleon-linedatabasebackupstorunautomatically?

A）theRMANcommandlineutilityB）SQL*PLUS

C）EnterpriseManagerCloudControl

D）TheDatabaseConfigurationAssistant（DBCA）E）theDBMS_SCHEDULERpackage

CE

79.YourdatabaseisopeninARCHIVELOGmode.LOG_ARCHIVE_DESTissettoFastRecoveryArea（FRA）anditis100%fullwhenalogswitchtakes

place.Noalternativeoroptionalarchivedestinationsaredefined.Whatistheoutcome?

A）Allactivesessionshanguntilthedatabaseadministrator（DBA）makesspaceavailableintheFRA

B）B）Noarchivelogsaregenerated.

C）Thearchivelogentriesaremadeinthediagnosticdestinationandwhenspaceisavailable,new

archivelogaregenerated.

D）Allactivesessionsaredisconnectedandtheirtransactionsrolledback.

E）Obsoletebackupsareautomaticallydeletedandnewarchivelogsaregenerated.

E（验证过）

80.Inwhichtwocasesisaconsistentdatabasebackupcreated?

A）whentheRMANBACKUPASCOPYcommandisusedwhilethedatabaseisopen

B）whentheRMANBACKUPcommandisusedwhilethedatabaseisOPENREADONLY

C）whentheRMANBACKUPASCOPYcommandisusedwhilethedatabaseisOPENRESTRICTED

D）whentheRMANBACKUPcommandisusedwhilethedatabaseisMOUNTED

E）whenO/Scommandsareusedtocopydatabasefilesafteradatabaseinstanceisshutdownnormally

DE

81.Whichcommandisusedtodisplayfilesthatnolongerconformtothebackupretentionpolicy?

A）LISTEXPIREDBACKUPB）REPORTOBSOLETE.

C）SHOWDATAFILEBACKUPCOPIES.D）CROSSCHECKBACKUP.

B

⼆十⼆Recover

82.Whichtwoaffectthetimetakenforinstancerecovery?

A）Sizeofarchivelogs.

B）SizeofexistingRMANbackupsets.C）FAST_START_MTTR_TARGETvalue.D）SizeofUNDOtablespace.E）UNDO_RETENTIONvalue.F）Sizeofredologs.

CF

⼆十三.Tablespace

83.Whichtwoaretrueaboutspacemanagementintablespaces?

A）Freelistsareusedformanagingfreespaceforsegmentsinlocallymanagedtablespaces.

B）Locallymanagedtablespacestrackadjacentfreespaceautomaticallybyusingbitmaps.

C）LocallymanagedtablespaceshaveeitherASSMormanualsegmentspacemanagement（MSSM）,andallthesegmentsinthesetablespacearemanagedonewayortheother.

D）Extentallocationmustbespecifiedasautomaticforautomaticsegmentspacemanagement（ASSM）tablespaces.E）ASSMtablespacespreventrowchaining.

84.Whichfourstatementsaretrueabouttablespacespacemanagement?

A）ASSMpreventsrowchaining.

B）Locallymanagedtablespacestrackadjacentfreespaceusingbitmaps.C）Locallymanagedtablespacescanmanagesegmentswithautomaticsegmentspacemanagement（ASSM）.

D）Locallymanagedtablespacestrackadjacentallocatedspaceusingbitmaps.

E）ASSMpreventsrowmigration.

F）LocallymanagedtablespacescanmanagesegmentswithfreelistsG）Bigfiletablespacescanbedictionaryorlocallymanaged.

BCFG

85.Yourdatabaseisconfiguredinarchivelogmode.TheUSERS01tablespaceiscurrentlyonline.

Youarerequiredtotakethetablespaceoffline.

Whichclauseorclausesensurethatnomediarecoveryisrequiredwhenthetablespaceisbroughtbackonline?

A）eithertheNORMALortheTEMPORARYclauseB）onlytheTEMPORARYclause

C）onlytheNORMALclause

D）eithertheNORMALortheIMMEDIATEclauseE）onlytheIMMEDIATEclause.

C（验证过）

86.whichtwostatementsaretrueabouttablespaces?

A）Adatabasecancontainmultipleundotablespaces.B）AdatabaseinstancestoresundodataintheSYSTEMtablespaceifnoundotablespaceexists.

C）AdatabaseinstancehangsiftheSYSAUXtablespacebecomesunavailable.

D）Adatabasecancontainonlyasingletemporarytablespace.E）AdatabasewithalocallymanagedSYSTEMtablespacecanhavedictionary-managedusertablespaces.

AE

87.whichfourstatementsaretrueabouttablespaces?

A）Asingleinstancedatabasecanhavemultipletemptablespacescreated.B）Asingleinstancedatabasecanhavemultipletemptablespaceusedsimultaneouslybytheinstance.C）TheSYSAUXtablespacecanbealteredOFFLINE.

D）Asingleinstancedatabasecanhavemultipleundotablespacesusedsimultaneouslybytheinstance.

E）TheSYSTEMtablespacecanbealteredOFFLINEFORRECOVERY.F）Asingleinstancedatabasecanhavemultipleundotablespacecreated.G）TheSYSAUXtablespacecanbealteredREADONLY.（验证过）

ABCF

88.WhichistrueaboutenablingAUTOEXTENDfordatafiles?

A）Itcanbeenabledforanewdatafilethatisaddedtoatablespaceonlyiftheexistingdatafilesinthattablesapcehaveautoextendenabled.B）Itcanbeenabledonlyfordatafilesinnon-OMFtablespaces.C）Itcanbeenabledfordatafilesonlyinbigfiletablespaces.D）Itcanbeenabledfordatafilesonlyinsmallfiletablespaces.E）ItcanbeenabledforanexistingdatafileinatablespacebyusingtheALTERTABLESPACEcommand.

E

89.WhichistrueabouttheSYSTEMandSYSAUXtablespaces？

A）Bothtablespacesmustbeonlineforadatabasetobeaccessible.B）TheSYSAUXtablespacecanbemaderead-onlybuttheSYSTEMtablespacecannot.

C）OnlytheSYSTEMtablespacecontainsdatadictionarytables.D）Bothtablespacescanbeusedfortemporarystorageifnotemporarytablespaceisdefined.

90.WhichthreetablespacecanbesettoOFFLINEIMMEDIATEinanOracleDatabase？

A）TheSYSTEMtablespace.

B）TheUndotablespacecurrentlyusedbytheinstance.C）AtablespacecontaininganRMANCATALOG.

D）AtablespacecontaininganEnterpriseManagerrepository.

E）TheSYSAUXtablespace（除非启用了介质恢复,否则不允许立即脱机）

CDE

91.Examinethesefactsaboutadatabase.

1.ThedatabasedefaulttabpespaceisUSERS.

2.DEFERRED_SEGMENT_CREATIONisTRUE.

3.ThedefaulttablespaceofUSER1istbs1.

4.USER1hasonlytheseprivileges:

•CREATESESSION•CREATETABLE

•UNLIMITEDquotaontbs1

ExaminethesecommandsexecutedbyUSER1:

CREATETABLEemp（enoNUMBER,enameVARCHAR2（20））TABLESPACETBS1;

Tablecreated.

CREATEINDEXemp_inxONemo（eno）TABLESPACEUSERS;

Indexcreated.

INSERTINTOempVALUES（NULL,’Alan’）;

WhatwillbetheoutcomeoftheINSERToperationandwhy?

A）ItwillfailbecauseanindexedcolumncannothaveNULLvalues.B）ArowwillbeinsertedintoEMPandanindexentrywillbemadeintoEMP_IDX.C）ItwillfailbecauseUSER1hasnoquotaonUSERS.

D）ArowwillbeinsertedintoEMPandanindexentrywillbeinsertedintoavirtualcolumnofEMPbecauseUSER1hasnoquotaanUSERS.E）ArowwillbeinsertedintoEMPbutnoindexentrywillbemadeintoEXP_IDX.Answer：

92.SCOTT.CUSTisintheSALEStablespace.SCOTTexecutesthesecommands:

INSERTINTOcostVALUES（101,’JACK’）;

1rowcreated.

INSERTINTOcostVALUES（102,’SMITH’）;

ASaDBA,dothisinadifferentsession:

ALTERTABLESPACEsalesREADONLY;

Whichtwostatementsaretrue?

A）Scott’stransactionisautomaticallyrolledbackandthetablespacebecomesread-only.

B）TheALTERTABLESPACEcommandfails.C）Scott’stransactionisautomaticallycommittedandthetablespacebecomesread-only.

D）Thecommandhangsandthehangwillendifthetransactioniscommitted.E）Thecommandhangsandthehangwillendifthetransactionisrolledback.

DE（已验证