OCP考试052最新考试题库原题60615Word格式.docx

OCP考试052最新考试题库原题60615Word格式.docx

《OCP考试052最新考试题库原题60615Word格式.docx》由会员分享，可在线阅读，更多相关《OCP考试052最新考试题库原题60615Word格式.docx（5页珍藏版）》请在冰豆网上搜索。

•A.tablespacequotasforusers

•B.thetimeafterwhichanidlesessionisterminated•C.defaulttablespaceforusers

•D.defaultobjectprivilegesforusers•E.sessionCPUlimits

•F.defaultsystemprivilegesforusers•CorrectAnswer:

BE

2、InwhichstatemustadatabasebetoenableARCHIVELOG?

•A.NOMOUNT

•B.OPENinRESTRICTEDmode•C.OPENinREADWRITEmode•D.MOUNT

•E.OPENinREADONLYmode•CorrectAnswer:

D

3、YourdatabaseisopeninARCHIVELOGmode.

LOG_ARCHIVE_DESTissettoFastRecoveryArea（FRA）anditis100%fullwhenalogswitchtakesplace.

Noalternativeoroptionalarchivedestinationsaredefined.Whatistheoutcome?

•A.Obsoletebackupsareautomaticallydeletedandnowarchivelogsare

generated.

•B.Thearchivelogentriesaremadeinthediagnosticdestinationandwhen

spaceisavailable,nowarchivelogsaregenerated.

•C.Noarchivelogsaregenerated.

•D.Allactivesessionsaredisconnectedandtheirtransactionsrolledback.•E.Allactivesessionshanguntilthedatabaseadministrator（DBA）makes

spaceavailableintheFRA.

•CorrectAnswer:

E

4、WhichthreearetrueaboutOracledatabasesecurity?

•A.Bydefault,SYSDBAconnectionshaveaccesstoallschemaobjects.•B.SYSDBAconnectionsarealwayssubjecttomandatoryauditing.•C.Bydefault,SYSOPERconnectionshaveaccesstothedatadictionary.•D.FineGrainedAuditingcanbeusedtorestrictaccesstosensitivedata.•E.SYSOPERconnectionsarealwayssubjecttomandatoryauditing.

•F.MandatoryauditingisenabledbysettingAUDIT_SYSOPERATIONSto

TRUE.

ABE

5.Whichthreestructurescanspanmultipledatafiles?

•A.chainedrows

•B.segments

•C.temporarysegmentextents•D.indexextents

•E.tableextents

•F.migratedrows

ABF

6、ExaminetheseSQLstatementsandtheiroutput:

A.Inactiveundowillneverberetainedformorethan15minutes.B.Theundotablespacecangrowautomaticallyifthereisnotenoughspacetoretainactiveundo.

C.Inactiveundowillberetainedaslongaspossiblewithinthelimitsofthecurrentsizeoftheundotablespace.

D.Inactiveundowillalwaysberetainedforatleast15minutes.E.Activeundowillberetainedaslongasneededbytransactions.CorrectAnswer:

BE

•7

WhichthreecanreducelockcontentioninanOracledatabase?

A.TheDatabaseResourceManagerB.profiles

C.schedulingOLTPandbatchworkloadsatdifferenttimesD.manuallockingofdatabaseobjectsforDMLstatementsE.committingtransactionsinatimelymannerCorrectAnswer:

CDE

8、WhichtwoaretrueabouttheInventorydirectory?

•A.Itisownedbytheoinstallgroup,whichmustbecreated

beforeinstallingOraclesoftwareforthefirsttimeonaserver.

•B.ItissharedbyallOraclesoftwareinstallationsonasingle

server.

•C.ItshouldbecreatedbeforeinstallingOraclesoftwareforthe

firsttimeonaserver.

•D.ItisrequiredonlyforOracleGridInfrastructureandOracle

Databasesoftwareinstallations.

•E.ItcanbecreatedonlyiftheORACLE_BASEenvironment

variableisset.

AB

9、Whichistrueaboutunusableindexes?

•A.Rebuildinganunusableindexalwaysrequiresatleasttwice

thespaceoftheoriginalindex

•B.RebuildinganunusableindexalwaysallowsDMLstatements

ontheindex’stableduringtherebuild.

•C.Rebuildingoccursautomaticallywhenanunusableindexis

chosenbytheoptimizerwhencreatinganexecutionplan

•D.Rebuildinganunusableindexcreatesanewsegmentafter

droppingtheunusableindex.

10、Whichtwoaretrueaboutspacemanagementintablespaces?

•A.Freelistsareusedformanagingfreespaceforsegmentsin

locallymanagedtablespaces.

•B.Extentallocationmustbespecifiedasautomaticfor

automaticsegmentspacemanagement（ASSM）tablespaces.

•C.ASSMtablespacespreventrowchaining.

•D.Locallymanagedtablespacestrackadjacentfreespace

automaticallybyusingbitmaps.

•E.LocallymanagedtablespaceshaveeitherASSMormanualsegmentspacemanagement（MSSM）,andallthesegmentsinthesetablespacesaremanagedonewayortheother.

DE

11、Whichcommandisusedtodisplayfilesthatnolongerconformtothebackupretentionpolicy?

•A.CROSSCHECKBACKUP•B.REPORTOBSOLETE•C.LISTEXPIREDBACKUP•D.SHOWDATAFILEBACKUPCOPIES•Answer:

B

12TableEMPresidesintheUSERStablespace.Examinethiscommand:

SQL>

DROPTABLEempPURGE;

WhichtwomethodswouldyouusetorecoverEMP?

•A.FlashbackDrop

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

•E.FlashbackTable•Answer:

BC

12WhichistrueaboutenablingAUTOEXTENDfordatafiles?

•A.Itcanbeenabledfordatafilesonlyinsmallfiletablespaces.•B.Itcanbeenabledforanexistingdatafileinatablespaceby

usingtheALTERTABLESPACEcommand.

•C.Itcanbeenabledonlyfordatafilesinnon-OMFtablespaces.•D.Itcanbeenabledfordatafilesonlyinbigfiletablespaces.

•E.Itcanbeenabledforanewdatafilethatisaddedtoatablespaceonlyiftheexistingdatafilesinthattablespacehaveautoextendenabled.

•Answer:

B

13Inoneofyourdatabases:

••Thedatabasedefaulttablespace