052-题库解析-6-20180615

052题库解析最新15道题题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案不断有新的考题出现，目前最新已经更新到130道题1、Whichtwocanbeconfiguredwithprofiles?•A.tablespacequotasforusers•B.thetimeafterwhichanidlesessionisterminated•C.defaulttablespaceforusers•D.defaultobjectprivilegesforusers•E.sessionCPUlimits•F.defaultsystemprivilegesforusers•CorrectAnswer:BE2、InwhichstatemustadatabasebetoenableARCHIVELOG?•A.NOMOUNT•B.OPENinRESTRICTEDmode•C.OPENinREADWRITEmode•D.MOUNT•E.OPENinREADONLYmode•CorrectAnswer:D3、YourdatabaseisopeninARCHIVELOGmode.LOG_ARCHIVE_DESTissettoFastRecoveryArea(FRA)anditis100%fullwhenalogswitchtakesplace.Noalternativeoroptionalarchivedestinationsaredefined.Whatistheoutcome?•A.Obsoletebackupsareautomaticallydeletedandnowarchivelogsaregenerated.•B.Thearchivelogentriesaremadeinthediagnosticdestinationandwhenspaceisavailable,nowarchivelogsaregenerated.•C.Noarchivelogsaregenerated.•D.Allactivesessionsaredisconnectedandtheirtransactionsrolledback.•E.Allactivesessionshanguntilthedatabaseadministrator(DBA)makesspaceavailableintheFRA.•CorrectAnswer:E4、WhichthreearetrueaboutOracledatabasesecurity?•A.Bydefault,SYSDBAconnectionshaveaccesstoallschemaobjects.•B.SYSDBAconnectionsarealwayssubjecttomandatoryauditing.•C.Bydefault,SYSOPERconnectionshaveaccesstothedatadictionary.•D.FineGrainedAuditingcanbeusedtorestrictaccesstosensitivedata.•E.SYSOPERconnectionsarealwayssubjecttomandatoryauditing.•F.MandatoryauditingisenabledbysettingAUDIT_SYSOPERATIONStoTRUE.•CorrectAnswer:ABE5.Whichthreestructurescanspanmultipledatafiles?•A.chainedrows•B.segments•C.temporarysegmentextents•D.indexextents•E.tableextents•F.migratedrows•CorrectAnswer:ABF6、ExaminetheseSQLstatementsandtheiroutput:A.Inactiveundowillneverberetainedformorethan15minutes.B.Theundotablespacecangrowautomaticallyifthereisnotenoughspacetoretainactiveundo.C.Inactiveundowillberetainedaslongaspossiblewithinthelimitsofthecurrentsizeoftheundotablespace.D.Inactiveundowillalwaysberetainedforatleast15minutes.E.Activeundowillberetainedaslongasneededbytransactions.CorrectAnswer:BE•7WhichthreecanreducelockcontentioninanOracledatabase?A.TheDatabaseResourceManagerB.profilesC.schedulingOLTPandbatchworkloadsatdifferenttimesD.manuallockingofdatabaseobjectsforDMLstatementsE.committingtransactionsinatimelymannerCorrectAnswer:CDE8、WhichtwoaretrueabouttheInventorydirectory?•A.Itisownedbytheoinstallgroup,whichmustbecreatedbeforeinstallingOraclesoftwareforthefirsttimeonaserver.•B.ItissharedbyallOraclesoftwareinstallationsonasingleserver.•C.ItshouldbecreatedbeforeinstallingOraclesoftwareforthefirsttimeonaserver.•D.ItisrequiredonlyforOracleGridInfrastructureandOracleDatabasesoftwareinstallations.•E.ItcanbecreatedonlyiftheORACLE_BASEenvironmentvariableisset.•CorrectAnswer:AB9、Whichistrueaboutunusableindexes?•A.Rebuildinganunusableindexalwaysrequiresatleasttwicethespaceoftheoriginalindex•B.RebuildinganunusableindexalwaysallowsDMLstatementsontheindex’stableduringtherebuild.•C.Rebuildingoccursautomaticallywhenanunusableindexischosenbytheoptimizerwhencreatinganexecutionplan•D.Rebuildinganunusableindexcreatesanewsegmentafterdroppingtheunusableindex.•CorrectAnswer:D10、Whichtwoaretrueaboutspacemanagementintablespaces?•A.Freelistsareusedformanagingfreespaceforsegmentsinlocallymanagedtablespaces.•B.Extentallocationmustbespecifiedasautomaticforautomaticsegmentspacemanagement(ASSM)tablespaces.•C.ASSMtablespacespreventrowchaining.•D.Locallymanagedtablespacestrackadjacentfreespaceautomaticallybyusingbitmaps.•E.LocallymanagedtablespaceshaveeitherASSMormanualsegmentspacemanagement(MSSM),andallthesegmentsinthesetablespacesaremanagedonewayortheother.•CorrectAnswer:DE11、Whichcommandisusedtodisplayfilesthatnolongerconformtothebackupretentionpolicy?•A.CROSSCHECKBACKUP•B.REPORTOBSOLETE•C.LISTEXPIREDBACKUP•D.SHOWDATAFILEBACKUPCOPIES•Answer:B12TableEMPresidesintheUSERStablespace.Examinethiscommand:SQLDROPTABLEempPURGE;WhichtwomethodswouldyouusetorecoverEMP?•A.FlashbackDrop•B.re-creatingthetableandreinsertingtherows•C.performingatablespacepointintimerecoveryofUSERS•D.FlashbackTransactionBackout•E.FlashbackTable•Answer:BC12WhichistrueaboutenablingAUTOEXTENDfordatafiles?•A.Itcanbeenabledfordatafilesonlyinsmallfiletablespaces.•B.ItcanbeenabledforanexistingdatafileinatablespacebyusingtheALTERTABLESPACEcommand.•C.Itcanbeenabledonlyfordatafilesinnon-OMFtablespaces.•D.Itcanbeenabledfordatafilesonlyinbigfiletablespaces.•E.Itcanbeenabledforanewdatafilethatisaddedtoatablespaceonlyiftheexistingdatafilesinthattablespacehaveautoextendenabled.•Answer:B13Inoneofyourdatabases:••ThedatabasedefaulttablespaceisEXAMPLE.••DEFERRED_SEGMENT_CREATIONisFALSE.•Examinethesecommands:•SQLCREATEUSERuser1IDENTIFIEDBYoracle_4UPASSWORDEXPIRE;•Usercreated.•SQLALTERUSERuser1ACCOUUNTUNLOCK;•Useraltered.•SQLGRANTCREATESESSIONtouser1;•Grantsucceeded.•SQLGRANTCREATETABLETOuser1WITHADMINOPTION;•Grantsucceeded.•Whichthreearetrue?•A.USER1cangranttheCREATETABLEprivilegetootherusers.•B.USER1canlogintothedatabaseinstance.•C.USER1cancreatetablesintheEXAMPLEtable