2024年計算機考試-Oracle認證筆試參考題庫含答案

“人人文庫”水印下載源文件后可一鍵去除，請放心下載?。▓D片大小可任意調節(jié)）2024年計算機考試-Oracle認證筆試參考題庫含答案“人人文庫”水印下載源文件后可一鍵去除，請放心下載！第1卷一.參考題庫(共75題)1.The?EMP_DEPT?block?in?your?EMPLOYEE?form?is?based?on?a?view?in?an?Oracle8?database.?The?items?in?this?block?have?the?Update?Allowed?property?set?to?Yes.?Which?database?feature?makes?it?possible?to?permanently?modify?the?underlying?view?（）A、REF?cursor.?B、Instead?Of?trigger.?C、Stored?procedure?that?returns?object?values.?D、The?underlying?view?cannot?be?modified?because?DML?on?a?view?is?not?supported.2.YoudiscoverthatyourRecycleBincontainstwotableswiththesamename,MY_TABLE.YoualsohaveatablenamedMY_TABLEinyourschema. Youexecutethefollowingstatement: FLASHBACKTABLEmy_tableTOBEFOREDROPRENAMETOmy_table2; Whatwillbetheresultofexecutingthisstatement?（）A、OneofthetablesisrecoveredfromtheRecycleBinusingaFirstInFirstOut(FIFO)approach.B、OneofthetablesisrecoveredfromtheRecycleBinusingaLastInFirstOut(LIFO)approach.C、BoththetablesarerecoveredfromtheRecycleBinwithonetablerenamedtoMY_TABLE2andtheothertoasystem-generatedname.D、NoneofthetablesarerecoveredfromtheRecycleBin,andthestatementreturnsanerror.3.Given： What?is?the?result？（）A、2.1.0B、2.1.1C、3.2.1D、3.2.24.YouareusingthecontrolfiletomaintaininformationaboutthedatabasebackupsthatarebeingperformedbyRecoveryManager(RMAN).Identifytwoscenariosiswhichyoumusthavearecoverycatalog.（）A、TostorethebackupinformationofmultipledatabaseB、TorestricttheamountofspacethatisusedbythebackupsC、TomaintainabackupforacertaintimeissetbytheCONTROL_FILE_RECORD_KEEP_TIMEparameter.D、TolistthedatafilesthatwereinatargetdatabaseatagiventimebyusingtheAToptionofREPORTSCHEMAcommand.5.Whichoptionprovidesahierarchyofdatasecurityacrosslinesofbusiness?（）A、AlertsB、Multi-OrgC、FlexfieldsD、SharedentitiesE、BusinessIntelligence6.While?creating?a?database?using?Database?Configuration?Assistant?tool，?you?created?a?database?default?temporary?tablespace.?Which?activity?would?cause?the?default?temporary?tablespace?of?the?database?to?be?used？（）A、the?CREATE?TABLE?..?commandB、sorting?of?the?SYSTEM?tablespace’s?dataC、sorting?of?data?required?by?recursive?SQL?statementsD、the?CREATE?TABLE?..?ORGANIZATION?EXTERNAL?..?commandE、sorting?of?data?if?the?users?have?not?been?allocated?temporary?tablespace?explicitlyF、sorting?of?data?if?the?users?have?been?allocated?temporary?tablespace?explicitly7.WhichtwostatementsaretrueaboutencryptingRMANbackup?（）(Choosetwo.)A、ThetransparentencryptionofbackupsusestheencryptionwalletB、ThedatabaseusesthesameencryptionkeyforeveryencryptedbackupC、ThepasswordencryptionofbackupsonlyusesthepasswordwhilecreatingandrestoringbackupD、Iftransparentencryptionisconfigured,youcannotusetheSETENCRYPTIONBYPASSWORDcommandtomakepassword-protectedbackups.8.Given: Whatistheresult?（）A、r，t，t，B、r，e，o，C、Compilationfails.D、Anexceptionisthrownatruntime.9.Which?command?is?used?to?begin?a?tablespace?point-in-time?recovery？（）??A、?Restore?tablespaceB、?Recover?tablespaceC、?Tablespace?recoverD、?Recover?to?timeE、?recover?datafile10.Whichthreestatementsaboutsubqueriesaretrue?（）A、Asinglerowsubquerycanretrieveonlyonecolumnandonerow.B、Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.C、Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.D、Amultiplerowsubquerycanbecomparedusingthe"；>；"；operator.E、AsinglerowsubquerycanusetheINoperator.F、Amultiplerowsubquerycanusethe"；="；operator.11.You?are?using?Oracle?Database?10g.?The?LOG_ARCHIVE_FORMAT?parameter?is?set?to? ’LOG%t_%s_%r.dbf’.? Why?is?%r?used?in?the?file?name?format？（）?A、to?uniquely?identify?the?archived?log?files?with?the?restore?operationB、to?uniquely?identify?the?archived?log?files?with?the?redo?log?group?numberC、to?uniquely?identify?the?archived?log?files?for?each?incarnation?of?the?databaseD、to?uniquely?identify?the?archived?log?files?with?the?number?of?recovery?operations?performed12.Your?database?in?running?in?the?ARCHIVELOG?mode.?You?issue?the?following?command?to?back?up?datafile?2?in?your?database.?? RMAN>?COPY?DATAFILE?2?TO?’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’；?? Which?two?statements?are?true?regarding?the?backup?created?using?this?command？（）A、?The?copy?of?the?datafile?created?is?stored?in?the?RMAN?repository.B、?The?copy?of?the?datafile?created?can?be?viewed?using?the?LIST?BACKUP?command.C、?The?copy?of?the?datafile?created?using?this?COPY?command?can?be?placed?only?on?the?disk.D、?The?copy?of?the?datafile?created?is?similar?to?the?backup?of?the?file?created?using?the?BACKUP?command.E、?The?copy?of?the?datafile?created?can?be?used?for?recovering?the?database?using?the?user-managed?recovery?method.13.Which?two?statements?about?the?SQL?Management?Base?（SMB）?are?true？（）?A、?It?contains?only?SQL?profiles?generated?by?SQL?Tuning?Advisor.B、?It?stores?plans?generated?by?the?optimizer?using?a?stored?outline.C、?It?is?part?of?the?data?dictionary?and?stored?in?the?SYSAUX?tablespace.D、?It?is?part?of?the?data?dictionary?and?stored?in?the?SYSTEM?tablespace.E、?It?contains?the?statement?log，the?plan?history，plan?baselines，and?SQL?profiles.14.You?need?to?import?all?definitions?of?objects?belonging?to?the?TS_EMPLOYEES?tablespace?by?using?the?export?file?expdat.dmp.?Which?import?statement?is?correct？（）A、imp?hr/hr?TABLES=（ts_employees）?rows=yB、imp?system/manager?FROMUSER=hr?file=expdat.dmpC、imp?hr/hr?TRANSPORT_TABLESPACE=y?file=expdat.dmpD、imp?system/manager?TRANSPORT_TABLESPACE=y?TABLESPACE=ts_employees15.Which?is?the?correct?WebLogic?Server?distribution?version?to?download?if?you?want?to?install?WebLogic?Server?12c?to?run?in?64?bit?mode?on?a?64?bit?Linux?X86?（）A、Linux?x86?with?64?bit?JVMB、ZIP?distribution?for?LinuxC、Linux?x86?with?32?bit?JVMD、Generic?distributionE、Network?installer16.In?your?production?database，?you?have?observed?that?the?database?server?performance?degrades?whenever?there?is?a?switch?between?the?log?groups.?On?further?investigation，?you?find?that?the?database?is?running?in?ARCHIVELOG?mode?and?the?archived?log?files?are?being?written?to?the?same?disk?that?is?used?to?store?the?redo?log?members.? Which?two?actions?would?you?take?to?improve?the?performance?of?the?database?server？（）A、increase?the?size?of?the?redo?log?bufferB、increase?the?number?of?redo?log?groupsC、increase?the?number?of?log?writer?processesD、increase?the?number?of?ARCn?processesE、change?the?appropriate?LOG_ARCHIVE_DEST_n?parameter?to?place?the?archived?log?files?in?a?separate?location17.You?want?to?create?a?template?to?be?used?as?a?standard?for?all?company?reports.?What?is?the?easiest?way?to?do?this?（）A、Open?an?existing?template?file,?rename?it?and?modify?the?template?objects.?B、Open?the?report?wizard?and?create?a?new?template.?C、Open?the?layout?model?and?copy?the?paste?items?from?the?default?templates?provided?in?report?builder.?D、Templates?cannot?be?modified?in?release?2.18.YouhavethreetemporarytablespacegroupsnamedG1,G2,andG3inyourdatabase.Youarecreatinganewtemporarytablespaceasfollows: CREATETEMPORARYTABLESPACETEMP1TEMPFILE'/u1/data/temp1.dbf'SIZE10M TABLESPACEGROUP''; Whichstatementregardingtheabovecommandiscorrect?（）A、ItwillcreatethetablespaceTEMP1ingroupG1.B、ItwillcreatethetablespaceTEMP1ingroupG3.C、ItwillnotaddthetablespaceTEMP1toanygroup.D、ItwillcreatethetablespaceTEMP1inthedefaultgroup.19.AdatabaseinstanceisusinganAutomaticStorageManagement(ASM)instance,whichhasadiskgroup,DGROUP1,createdasfollows: SQL>CREATEDISKGROUPdgroup1NORMALREDUNDANCY FAILGROUPcontroller1DISK'/devices/diska1','/devices/diska2' FAILGROUPcontroller2DISK'/devices/diskb1','/devices/diskb2'; WhathappenswhenthewholeCONTROLLER1Failuregroupisdamaged?（）A、Thetransactionsthatusethediskgroupwillhalt.B、ThemirroringofallocationunitsoccurswithintheCONTROLLER2failuregroup.C、ThedataintheCONTROLLER1failuregroupisshiftedtotheCONTROLLER2failuregroupandimplicitrebalancingistriggered.D、TheASMdoesnotmirroranydataandnewlyallocatedprimaryallocationunits(AU)arestoredintheCONTROLLER2failuregroup.20.在Oracle中，在執(zhí)行SQL語句時，你不小心使用Update命令將所有的ID值設置成了11111，那么使用（）命令可以取消這一操作。A、EXITB、COMMITC、ROLLBACKD、UNDO21.WhichtierinOracleE-BusinessSuiteisresponsibleforstoringapplicationdata?（）A、databasetierB、applicationtierC、client(desktop)tierD、bothdatabasetierandapplicationtier22.Given： Which?change?can?you?make?to?Target?without?affecting?Client？（）A、Line?4?of?class?Target?can?be?changed?to?return?i++；B、Line?2?of?class?Target?can?be?changed?to?private?int?i?=?1；C、Line?3?of?class?Target?can?be?changed?to?private?int?addOne（）{D、Line?2?of?class?Target?can?be?changed?to?private?Integer?i?=?0；23.Given： Which?command-line?invocations?will?compile？（）A、javac?Mule.javaB、javac?-source?1.3?Mule.javaC、javac?-source?1.4?Mule.javaD、javac?-source?1.5?Mule.java24.When?performing?an?incomplete?recovery?of?the?whole?database，?what?must?be?true?about?the?data?files?that?are?restored？（）A、AB、BC、CD、D25.Assuming?that?the?serializeBanana（）?and?the?deserializeBanana（）?methods?will?correctly?use?Javaserialization?and?given： What?is?the?result？（）A、restore?400B、restore?403C、restore?453D、Compilation?fails.E、An?exception?is?thrown?at?runtime.26.You?are?creating?a?job?class.?You?want?access?to?the?detailed?information?for?all?the?runs?of?each?job?in?the?class?and?every?operation?performed?on?every?job?in?the?class.?Which?setting?will?you?use?for?the?LOGGING_LEVEL?parameter？（）A、?LOGGING_OFFB、?LOGGING_RUNSC、?LOGGING_FULLD、?LOGGING_NULL27.Matthew?has?recently?joined?NetFx?Corporation?as?a?junior-level?Database?Administrator?（DBA）.?He?is?asked?by?his?supervisor?to?verify?the?database?for?data?block?corruptions.?He?uses?the?DBVERIFY?utility?and?finds?that?two?data?blocks?are?corrupted?in?the?database.?? What?should?Matthew?use?to?identify?the?corrupted?blocks?as?well?as?datafiles?containing?these?blocks？（）?A、?datafileB、?alert?logC、?dynamic?viewsD、?control?file?script28.Which?statement?is?true?regarding?RMAN?components？（）A、Each?target?database?requires?its?own?recover?catalog.?B、RMAN?scripts?can?be?stored?in?the?recovery?catalog?or?the?target?control?file.?C、A?channel?is?a?stream?of?data?to?a?device?type?and?corresponds?to?one?server?session.?D、The?RMAN?executable?interprets?sever?session?commands?and?establishes?connections?to?the?targetdatabase.29.Exhibit： View?the?Exhibit?to?see?the?information?on?existing?tablespaces?of?the?PROD?database.? You?observe?that?a?large?volume?of?INSERTs?and?DELETEs?are?happening?on?the?TRANS?table?residing?in?the?USERS?tablespace，?and?you?suspect?that?the?TRANS?table?is?fragmented.?Which?advisory?component?would?you?refer?to，?in?order?to?find?the?information?about?table?fragmentation？（）A、Memory?AdvisorB、Segment?AdvisorC、SQL?Tuning?and?Access?AdvisorsD、Automatic?Workload?Repository?（AWR）E、Automatic?Database?Diagnostic?Monitor?（ADDM）30.ThePRODUCTStablehasthesecolumns: PRODUCT_IDNUMBER(4) PRODUCT_NAMEVARCHAR2(45) PRICENUMBER(8,2) EvaluatethisSQLstatement: SELECT* FROMPRODUCTS ORDERBYprice,product_name; WhatistrueabouttheSQLstatement?（）A、Theresultsarenotsorted.B、Theresultsaresortednumerically.C、Theresultsaresortedalphabetically.D、Theresultsaresortednumericallyandthenalphabetically.31.Given: Whichmethodwillcompletethisclass?（）A、publicintcompareTo(Objecto){/*morecodehere*/}B、publicintcompareTo(Scoreother){/*morecodehere*/}C、publicintcompare(Scores1,Scores2){/*morecodehere*/}D、publicintcompare(Objecto1,Objecto2){/*morecodehere*/}32.Ateamofprogrammersisinvolvedinreviewingaproposeddesignforanewutilityclass.Aftersomediscussion,theyrealizethatthecurrentdesignallowsotherclassestoaccessmethodsintheutilityclassthatshouldbeaccessibleonlytomethodswithintheutilityclassitself. Whatdesignissuehastheteamdiscovered?（）A、TightcouplingB、LowcohesionC、HighcohesionD、LoosecouplingE、WeakencapsulationF、Strongencapsulation33.WhichstatementmostaccuratelydescribestheimplementationofaSQLAccessAdvisorrecommendation?（）A、SQLAccessAdvisorrecommendationsareautomaticallyimplemented.B、IndividualSQLAccessAdvisorrecommendationscanbescheduledforimplementation.C、AllSQLAccessAdvisorrecommendationsforaspecifictaskmustbeimplementedatthesametime.D、SQLAccessAdvisorrecommendationsareautomaticallyscheduledforimplementationduringthemaintenancewindow.E、Noneoftheabove.34.在Oracl中，哪種表分區(qū)維護操作可以將非分區(qū)表轉換為分區(qū)表的分區(qū)（）。A、添加分區(qū)B、結合分區(qū)C、交換表分區(qū)D、合并分區(qū)35.Whichtwostatementsaboutsequencesaretrue?（）A、YouuseaNEXTVALpseudocolumntolookatthenextpossiblevaluethatwouldbegeneratedfromasequence,withoutactuallyretrievingthevalue.B、YouuseaCURRVALpseudocolumntolookatthecurrentvaluejustgeneratedfromasequence,withoutaffectingthefurthervaluestobegeneratedfromthesequence.C、YouuseaNEXTVALpseudocolumntoobtainthenextpossiblevaluefromasequencebyactuallyretrievingthevaluefromthesequence.D、YouuseaCURRVALpseudocolumntogenerateavaluefromasequencethatwouldbeusedforaspecifieddatabasecolumn.E、Ifasequencestartingfromavalue100andincrementedby1isusedbymorethenoneapplication,thenalloftheseapplicationscouldhaveavalueof105assignedtotheircolumnwhosevalueisbeinggeneratedbythesequence.F、YouuseREUSEclausewhencreatingasequencetorestartthesequenceonceitgeneratesthemaximumvaluedefinedforthesequence.36.Which?two?initialization?parameters?would?you?set?to?enable?Automatic?Shared?MemoryManagement？（）A、?set?SHARED_POOL_SIZE?to?zeroB、?set?STATISTICS_LEVEL?to?BASICC、?set?SGA_TARGET?to?a?non-zero?valueD、?set?DB_CACHE_SIZE?to?a?non-zero?valueE、?set?STATISTICS_LEVEL?to?TYPICAL?or?ALL37.You?plan?to?collect?the?Automatic?Workload?Repository?（AWR）?data?every?Monday?morning?for?a?month.?You?want?Oracle?Database?to?automatically?create?a?baseline?every?Monday?and?remove?the?old?baseline.? What?is?the?correct?action?to?achieve?this？（）??A、?Create?and?populate?a?SQL?Tuning?Set?from?the?AWR?on?every?Monday.B、?Change?the?RETENTION?setting?for?the?AWR?snapshots?to?7?days?on?Monday.C、?Create?a?repeating?baseline?template.D、?Insert?a?finding?directive?for?future?ADDM?tasks.38.Which?statement?is?true?about?a?whole?consistent?database?backup?on?a?database?running?in?ARCHIVELOG?mode（）A、The?backup?will?consist?of?used?data?blocks?only.B、The?database?must?be?shut?down?to?accomplish?the?backup.C、The?backup?can?be?accomplished?without?shutting?down?the?database.D、The?backup?will?contain?all?database?files?that?have?never?been?backed?up.39.假設需要更改表名“CUSTOMER”為“CUSTOMER_CHANGE”，可以使用（）語句。A、ALTERTABLECUSTOMERRENAMECUSTOMER_CHANGEB、ALTERTABLECUSTOMERRENAMETOCUSTOMER_CHANGEC、RENAMETABLECUSTOMERTOCUSTOMER_CHANGED、RENAMETABLECUSTOMERCUSTOMER_CHANGE40.Your?database?is?in?the?NOARCHIVELOG?mode.?Since?last?night’s?offline?backup，?the?logs?in?group?1?have?been?written?to?twice.?This?morning，?the?SYSTEM?data?file?has?become?corrupted.?Up?to?what?point?can?it?be?recovered？（）A、until?the?last?commitB、cannot?be?recoveredC、until?the?last?offline?backupD、until?the?beginning?of?the?last?transaction41.You?work?as?a?database?administrator?for?Certkiller?.com.?In?your?database?server，?the?parameter?PLSQL_OPTIMIZE_LEVEL?has?been?set?to?2.?What?would?this?setting?achieve？（）A、It?degrades?the?run?time?and?compiler?performance.B、It?provides?better?run?time?and?compiler?performance.C、It?provides?better?optimization?of?the?statement?during?parse?time.D、It?forces?the?rule?based?optimizer?to?be?used?for?statement?optimization.E、It?provides?better?run?time?performance?but?slightly?degraded?compiler?performance.?F、It?provides?better?run?time?performance?but?slightly?degraded?run?time?performance.42.ClicktheExhibitbutton.Whichthreecodefragments,addedindividuallyatline29,producetheoutput100?（） A、n=100;B、i.setX(100);C、o.getY().setX(100);D、i=newInner();i.setX(100);E、o.setY(i);i=newInner();i.setX(100);F、i=newInner();i.setX(100);o.setY(i);43.You?work?as?a?database?administrator?for?Certkiller?.com.?While?granting?a?role，SELECT_CATALOG_ROLE，?to?a?user，?Certkiller，?using?Oracle?Enterprise?Manager?10g?Database?Control，?you?have?cleared?the?DEFAULT?check?box.?What?will?be?the?result？（）A、The?user?cannot?use?the?role?at?all.B、The?role?would?not?be?granted?to?the?user.C、The?user?needs?to?enable?the?role?explicitly.D、The?user?can?start?using?the?role?immediately.E、The?user?would?have?the?admin?option?for?the?role.44.You?work?as?a?database?administrator?for?Certkiller?.com.?You?are?using?Recovery?Manager?（RMAN）?for?backup?and?recovery?of?your?database.?You?executed?the?delete?command?in?RMAN?to?delete?a?backup?of?atablespace.?Which?statement?is?true?in?this?scenario？（）A、AB、BC、CD、DE、E45.Adatamanipulationlanguagestatement（）.A、completesatransactiononatableB、modifiesthestructureanddatainatableC、modifiesthedatabutnotthestructureofatableD、modifiesthestructurebutnotthedataofatable46.Which?statement?is?true?regarding?Oracle?Shared?Server?architecture？（）A、A?dispatcher?can?support?multiple?client?connects?concurrently?while?a?shared?server?process?can?be?dedicated?to?only?one?dispatcher.?B、Under?the?Oracle?Shared?Server?architecture,?client-user?processes?connect?to?shared?user?processes.C、Each?dispatcher?has?its?own?request?queue,?which?is?monitored?every?three?seconds?by?the?dispatcher.?D、Oracle?Shared?Server?required?Oracle?Net?Service?even?if?the?client?and?shared?server?processes?reside?on?the?same?machine.47.Which?of?the?following?file?should?be?configured?for?dynamic?service?registration？（）A、LISTENER.ORAB、SQLNET.ORAC、INIT.ORAD、TNSNAMES.ORA48.What?is?the?result?of?increasing?the?value?of?the?parameter?ASM_POWER_LIMIT?during?a?rebalance?operation？（）??A、?The?ASM?rebalance?operation?will?likely?consume?fewer?resources?and?complete?in?a?shorter?amount?of?time.B、?The?ASM?rebalance?operation?will?consume?fewer?resources?and?complete?in?a?longer?amount?of?time.C、?The?ASM?rebalance?operation?will?be?parallelized?and?should?complete?in?a?shorter?amount?of?time.D、?There?is?no?ASM_POWER_LIMIT?setting?used?in?ASM.E、?None?of?the?above.49.Given： What?is?the?result？（）A、0，0，0B、150，60，0C、Compilation?fails.D、150，150，15050.Given： What?is?the?result？（）A、2?-1B、2?-4C、2?-5D、3?-1E、3?-451.What?is?the?implication?of?setting?the?initialization?parameter?FAST_START_MTTR_TARGET?to?0?in?your?database？（）A、MTTR?Advisor?would?be?disabled.B、Redo?Log?Advisor?would?be?disabled.C、Automatic?tuning?of?checkpoint?would?be?disabled.D、Checkpoint?information?would?not?be?written?to?the?alert?log?file.52.This?is?a?special?WebLogic?Server?instance?included?by?the?WebLogic?Server?Domains.? It?represents?a?central?point?from?which?you?configure?and?manage?all?resource?domain.?（）A、?Managed?ServerB、?Web?ServerC、?Administration?ServerD、?Node?Server53.Which?commands?are?used?for?RMAN?database?recovery？（）A、?restoreB、?repairC、?copyD、?recoverE、?replace54.You?are?managing?an?Oracle?Database?11g?database?with?ASM?storage.?The?ASM?disk?group?has?the?COMPATIBLE.ASM?attribute?set?to?11.1.? Which?statements?are?true?regarding?extent?management?and?allocation?units?in?the?ASM?disk?group？（）A、?The?au_size?disk?group?attribute?determines?the?size?of?allocation?units?in?the?disk?group.?B、?The?allocation?unit?size?may?vary?but?the?extent?size?is?fixed.C、?The?allocation?unit?size?and?extent?size?are?fixed?for?all?the?disks?in?a?disk?group?and?cannot?be?changed.D、?Extent?management?is?completely?automated.55.User?SCOTT?executes?the?following?command?on?the?EMP?table?but?has?not?issued?COMMIT，?ROLLBACK，?orany?data?definition?language?（DDL）?command： SQL>?SELECT?ename?FROM?emp?WHERE?job=’CLERK’?FOR?UPDATE?OF?empno； SCOTT?has?opened?another?session?to?work?with?the?database?instance.? Which?three?operations?would?waitwhen?issued?in?SCOTT’s?second?session（）A、LOCK?TABLE?emp?IN?SHARE?MODE；B、LOCK?TABLE?emp?IN?EXCLUSIVE?MODE；C、UPDATE?emp?SET?sal=sal*1.2?WHERE?job=ANAGER？UPDATE?emp?SET?sal=sal*1.2?WHERE?job=？ANAGER？D、INSERT?INTO?emp（empno，ename）?VALUES?（1289，’Harry’）；E、SELECT?ename?FROM?emp?WHERE?job=’CLERK’?FOR?UPDATE?OF?empno56.You?are?the?Database?Administrator?（DBA）?of?your?company.?You?execute?the?following?statement?on?an?Oracle?10g?instance：?? SQL>?ALTER?SYSTEM?SWITCH?LOGFILE；?? Which?two?tasks?are?performed?when?the?statement?is?executed？?（）A、?The?DBWn?process?writes?to?the?datafile.B、?Changes?in?the?background?process?are?recorded.C、?The?log?file?is?updated?with?the?current?SCN?number.D、?The?System?Change?Number?（SCN）?is?recorded?in?the?control?file.E、?The?changes?to?the?listener?configuration?in?the?listener.ora?file?are?recorded.57.Because?of?a?power?outage，?instance?failure?has?occurred.?From?what?point?in?the?redo?log?does?recovery?begin?and?where?does?it?end？?（）A、current?redo?log?and?inactive?redo?logB、checkpoint?position?to?end?of?redo?logC、beginning?of?redo?log?to?end?of?redo?logD、all?redo?logs?before?the?point?of?last?commitE、beginning?of?redo?log?to?checkpoint?position58.Given： What?is?the?result？（）A、Mr.?John?DoeB、An?exception?is?thrown?at?runtime.C、Compilation?fails?because?of?an?error?in?line?12.D、Compilation?fails?because?of?an?error?in?line?15.E、Compilation?fails?because?of?an?error?in?line?20.59.When?manually?configuring?the?SGA，which?of?the?following?parameter?changes?requires?an?instance?restart?to?take?effect？（）?? "First?Test，?First?Pass"?-??97 Oracle?1Z0-053?ExamA、?DB_CACHE_SIZEB、?SHARED_POOL_SIZEC、?LARGE_POOL_SIZED、?JAVA_POOL_SIZEE、?SGA_MAX_SIZEF、?SORT_AREA_SIZE60.Inwhichtwocaseswouldyouuseanouterjoin?（）A、ThetablesbeingjoinedhaveNOTNULLcolumns.B、Thetablesbeingjoinedhaveonlymatcheddata.C、ThecolumnsbeingjoinedhaveNULLvalues.D、Thetablesbeingjoinedhaveonlyunmatcheddata.E、Thetablesbeingjoinedhavebothmatchedandunmatcheddata.F、Onlywhenthetableshaveaprimarykey-foreignkeyrelationship.61.OnyourOracle12cdatabase,youIssuethefollowingcommandstocreateindexes SQL>CREATEINDEXoe.ord_customer_ix1ONoe.orders(customers_id,sales_rep_id)INVISIBLE; SQL>CREATEBITMAPINDEXoe.ord_customer_ix2ONoe.orders(customers_id,sales_rep_id); Whichtwostatementarecorrect?（）A、Boththeindexesarecreated;however,onlytheORD_COSTOMERindexisvisible.B、TheoptimizerevaluatesindexaccessfromboththeIndexesbeforedecidingonwhichindextouseforqueryexecutionplan.C、OnlytheORD_CUSTOMER_IX1indexiscreated.D、OnlytheORD_CUSTOMER_IX2indexiscreated.E、Boththeindexesareupdatedwhenanewrowisinserted,updated,ordeletedIntheorderstable.62.IdentifythepersistentconfigurationsettingforthetargetdatabasethatcanbesetforthebackupbyusingRMAN.（）A、BackupretentionpolicyB、DefaultbackupdevicetypeC、DefaultdestinationsforbackupsD、MultiplebackupdevicetypesforsinglebackupE、Defaultsectionsizeforbackups63.Identifythreevalidmethodsofopening,pluggabledatabases(PDBs).（）A、ALTERPLUGGABLEDATABASEOPENALLISSUEDfromtherootB、ALTERPLUGGABLEDATABASEOPENALLISSUEDfromapdbC、ALTERPLUGGABLEDATABASEPDBOPENissuedfromtheseedD、ALTERDATABASEPDBOPENissuedfromtherootE、ALTERDATABASEOPENissuedfromthatpdb

F、ALTERPLUGGABLEDATABASEPDBOPENissuedfromanotherpdbG、ALTERPLUGGABLEDATABASEOPENissuedfromthatpdb64.顯示本月月末的日期（）A、selectlast_date(sysdate)fromdual;B、selectfinally_day(sysdate)fromdual;C、selectlast_day(sysdate)fromdual;D、selecttail_day(sysdate)fromdual;65.Acompanyhasabusinessapplicationthatprovidesitsuserswithmanydifferentreports: receivablesreports,payablesreports,revenueprojects,andsoon.Thecompanyhasjustpurchasedsomenew,state-of-the-art,wirelessprinters,andaprogrammerhasbeenassignedthetaskofenhancingallofthereportstousenotonlythecompany'soldprinters,butthenewwirelessprintersaswell.Whentheprogrammerstartslookingintotheapplication,theprogrammerdiscoversthatbecauseofthedesignoftheapplication,itisnecessarytomakechangestoeachreporttosupportthenewprinters. Whichtwodesignconceptsmostlikelyexplainthissituation?（）A、InheritanceB、LowcohesionC、TightcouplingD、HighcohesionE、LoosecouplingF、Objectimmutability66.A?redo?log?file?is?corrupted?while?the?database?is?open；?as?a?consequence，?databa