2024年Oracle認證歷年考試高頻考點試題附帶答案

2024年Oracle認證歷年考試高頻考點試題附帶答案（圖片大小可自由調(diào)整）第1卷一.參考題庫(共25題)1.You?are?working?as?a?DBA?in?a?company.?The?datafiles?in?the?database?are?as?follows： ?? On?Monday，?you?tried?to?start?up?the?database?but?failed?because?all?the?control?files?were?missing.?You?recreated?the?control?file?using?the?script?you?have?created?by?issuing?the?ALTER?DATABASE?BACKUP?CONTROLFILE?TO?TRACE?command.?What?is?the?prerequisite?for?recreating?the?control?file？（）A、?All?the?datafiles?should?be?listed?in?the?CREATE?CONTROLFILE?statement.B、?The?DATA2.dbf?and?DATA3.dbf?datafiles?should?be?listed?in?the?CREATE?CONTROLFILE?statement.?C、?The?SYSTEM01.dbf?datafile?should?be?listed?in?the?CREATE?CONTROLFILE?statement.D、?The?SYSAUX01.dbf?datafile?should?be?listed?in?the?CREATE?CONTROLFILE?statement.2.Users?are?performing?a?large?volume?of?inserts?and?deletes?on?the?application?tables?in?the?APPS?tablespace.?You?observe?that?there?are?several?warning?alerts?being?generated?for?the?APPS?tablespace?space?usage?metrics.?Currently，?the?warning?threshold?for?the?tablespace?space?usage?metrics?is?set?to?70%.? To?make?the?generated?alerts?more?useful?as?a?problem?identification?tool，?you?want?to?reduce?the?frequency?of?alert?generation?for?the?tablespace?space?usage?metrics?for?the?APPS?tablespace.?What?should?you?do？（）A、disable?SQL?tracing?for?theAPPS?tablespaceB、disable?logging?attribute?for?the?APPS?tablespaceC、modify?the?tablespace?to?be?a?dictionary-managed?tablespaceD、increase?the?critical?threshold?value?for?the?tablespace?space?usage?metrics?for?the?APPS?tablespaceE、increase?the?warning?threshold?value?for?the?tablespace?space?usage?metrics?for?the?APPS?tablespace3.In?your?production?database?there?is?a?job，?CALC_STAT，?which?has?been?scheduled?to?run?every?Friday?at?5：00?p.m.?CALC_STAT?updates?the?optimizer?statistics?for?the?objects?owned?by?the?APPS?schema.?You?want?the?task?to?be?generic，?thereby?allowing?users?to?modify?the?attributes?of?the?task?at?run?time?without?affecting?the?original?task. Which?component?of?Oracle?Scheduler?must?you?define?to?achieve?this？（）A、WindowB、ProgramC、Job?classD、Window?group4.You?are?maintaining?your?OLTP?database?in?Oracle10g.?You?have?not?set?the?warning?level?and?critical?level?threshold?values?for?space?usage?of?the?DATA1?tablespace.?What?will?be?the?impact？（）A、?No?warning?level?or?critical?level?alert?will?be?generated.B、?A?warning?level?alert?will?never?be?generated，?but?a?critical?level?alert?will?be?generated?when?97?percent?space?of?the?DATA1?tablespace?is?used.C、?A?critical?level?alert?will?never?be?generated，?but?a?warning?level?alert?will?be?generated?when?85?percent?space?of?the?DATA1?tablespace?is?used.D、?A?warning?level?alert?will?be?generated?at?85?percent?space?usage?of?the?DATA1?tablespace，?and?a?critical?level?alert?is?generated?at?97?percent?space?usage?of?the?DATA1?tablespace.5.Youwanttosetthefollowinginitializationparametersforyourdatabaseinstance: LOG_ARCHIVE_DEST_1='LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3='LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4='LOCATION=/disk4/archMANDATORY' Identifythestatementthatcorrectlydescribesthissetting.（）A、TheMANDATORYlocationmustbeaflashrecoveryarea.B、Theoptionaldestinationsmaynotusetheflashrecoveryarea.C、ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATORY.D、Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.6.Exhibit，View?the?Exhibit?and?examine?the?Resource?Manager?settings?for?the?groups?at?different?levels.?Which?two?effects?would?be?the?result?of?this?setting？?（） A、?The?members?of?LOW_GROUP?would?get?more?priority?than?those?of?OTHER_GROUPS.B、?The?members?of?SYS_GROUP?would?get?most?of?the?CPU?allocation?at?level?1.C、?The?members?of?LOW_GROUP?would?get?most?of?the?CPU?allocation?because?it?has?CPU?allocation?at?two?different?levels.D、?The?members?of?LOW_GROUP?would?get?no?CPU?allocation?at?level1?if?the?members?of?OTHER_GROUPS?are?using?all?the?CPU?at?level?2.E、?The?members?of?SYS_GROUP?would?get?no?CPU?allocation?at?level?1?if?the?members?of?OTHER_GROUPS?are?using?all?the?CPU?at?level?2.7.You?need?to?check?the?EMP_EAST?partition?in?the?EMPLOYEES?table?for?physical?corruptions.?You?also?need?to?verify?that?the?rows?belong?to?the?correct?partition.?Which?option?could?you?use？（）A、?LogMinerB、?The?DBNEWID?utilityC、?The?DBVERIFY?utilityD、?The?ANALYZE?commandE、?The?RMAN?REPORT?commandF、?The?RMAN?CROSSCHECK?command.G、?The?RMAN?BLOCKRECOVER?command.8.You?have?only?two?redo?log?groups?and?these?groups?get?overwritten?several?times?in?a?day.?Your?database?operates?in?NOARCHIVELOG?mode?and?user/x7fmanaged?consistent?backups?are?performed?every?Sunday?night.?On?Thursday?morning，?you?find?that?an?important?table?has?been?dropped?and?purged.? With?reference?to?this?scenario，?up?to?what?point?in?time?can?the?data?be?recovered？（）A、until?Thursday?morningB、until?last?Sunday’s?backupC、until?Wednesday?eveningD、until?that?point?in?time?when?the?database?is?openedE、until?that?point?in?time?when?the?recovery?is?performedF、until?that?point?in?time?when?the?table?is?dropped?and?purged9.ClicktheExhibitbuttontoexaminethestructureoftheEMPLOYEES,DEPARTMENTS,andLOCATIONStables. Twonewdepartmentsareaddedtoyourcompanyasshown:DEPARTMENT_IDDEPARTMENT_NAMEMGR_IDLOCATION_ID 9998Engineering123 9999AdministrativeBoston Youneedtolistthenamesofemployees,thedepartmentIDs,thedepartmentnames,andthecitieswherethedepartmentsare,eveniftherearenoemployeesinthedepartmentsandevenifthedepartmentsarenotyetassignedtoalocation.YouneedtojointheEMPLOYEES,DEPARTMENTS,andLOCATIONStablestoretrievethisinformation. Whichstatementdoyouexecutetoretrievethisinformation?（）A、SELECTe.last_name,d.department_id,d.department_name,l.cityFROMdepartmentsdRIGHTOUTERJOINemployeeseONd.department_id=e.department_idRIGHTOUTERJOINlocationslONd.location_id=l.location_id;B、SELECTe.last_name,d.department_id,d.department_name,l.cityFROMdepartmentsdFULLOUTERJOINemployeeseONd.department_id=e.department_idFULLOUTERJOINlocationslONd.location_id=l.location_id;C、SELECTe.last_name,d.department_id,d.department_name,l.cityFROMdepartmentsdLEFTOUTERJOINemployeeseONd.department_id=e.department_idLEFTOUTERJOINlocationslONd.location_id=l.location_id;D、SELECTlast_name,department_id,department_name,cityFROMdepartmentsdNATURALJOINemployeeseNATURALJOINlocationsl;10.Whichtwostatementsaretrueabouttheuseoftheprocedureslistedinthevsysaux_occupants.move_procedurecolumn?（）A、TheproceduremaybeusedforsomecomponentstorelocatecomponentdatatotheSYSAUXtablespacefromitscurrenttablespace.B、TheproceduremaybeusedforsomecomponentstorelocatecomponentdatafromtheSYSAUXtablespacetoanothertablespace.C、AllthecomponentsmaybemovedintoSYSAUXtablespace.D、AllthecomponentsmaybemovedfromtheSYSAUXtablespace.11.You?have?not?configured?Oracle?Managed?Files?（OMF）?in?your?database.?You?do?not?want?to?scan?the?entire?datafile?every?time?an?incremental?backup?is?performed.?You?decide?to?enable?the?block?change?tracking?feature.?Which?statement?will?you?use?to?enable?the?block?change?tracking?feature？（）A、?ALTER?SYSTEM?ENABLE?BLOCK?CHANGE?TRACKING；B、?ALTER?DATABASE?ENABLE?BLOCK?CHANGE?TRACKING；C、?ALTER?SYSTEM?ENABLE?BLOCK?CHANGE?TRACKING?USING?FILE?；D、?ALTER?DATABASE?ENABLE?BLOCK?CHANGE?TRACKING?USING?FILE?；12.YouspecifyanonzerovaluefortheMEMORY_TARGETinitializationparameter,butdonotsetthePGA_AGGREGATE_TARGETortheSGA_TARGETparameters.Yourestartyourdatabaseinstance. Whichstatementabouttheresultistrue?（）A、Thedatabaseinstancestarts,andOraclesetsthedefaultvalueofSGA_TARGETtothesamevalueasSGA_MAX_SIZEB、Thedatabaseinstancestarts,andOracleautomaticallytunesmemoryandallocates60percenttotheSGAand40percenttothePGAC、Thedatabaseinstancestarts,butAutomaticMemoryManagementisdisabledD、ThedatabaseinstancewillnotstartbecauseyoudidnotspecifythePGA_AGGREGATE_TARGETorSGA_TARGETparameter13.ExaminethestructureoftheEMPLOYEEStable: EMPLOYEE_IDNUMBERPrimaryKey FIRST_NAMEVARCHAR2(25) LAST_NAMEVARCHAR2(25) HIRE_DATEDATE WhichUPDATEstatementisvalid?（）A、UPDATEemployeesSETfirst_name='John'SETlast_name='Smith'WHEREemployee_id=180;B、UPDATEemployeesSETfirst_name='John',SETlast_name='Smith'WHEREemployee_id=180;C、UPDATEemployeesSETfirst_name='John'ANDlast_name='Smith'WHEREemployee_id=180;D、UPDATEemployeesSETfirst_name='John',last_name='Smith'WHEREemployee_id=180;14.Youexecutedthefollowingcommandsinadatabasesession: Whatcouldhavecausedtherecyclebintocleanup?（）A、Thereisdemandforspacefromthenewtable從B、TheundotablespacedoesnothavesufficientfreespaceC、ThenewtablenameisthesameasthetablenameintherecyclebinD、Thetemporarytablespacethatisassignedtoyoudoesnothavesufficientfreespace15.When?is?an?implicit?anchor?created?（）A、When?an?object?is?enclosed?by?another?object.?B、When?a?page?break?after?pagination?property?is?enabled.?C、When?a?link?is?created?between?two?objects.?D、When?a?keep?with?anchoring?object?pagination?property?is?enabled.16.Your?database?is?up?and?running?and?one?of?your?three?control?files?is?accidentally?erased.?You?start?RMAN?and?run?the?following?command：?? RESTORE?CONTROLFILE?FROM?AUTOBACKUP；?? Which?of?the?following?statements?is?true？（）?A、?The?command?restores?only?the?missing?control?file.B、?The?command?restores?all?the?control?files.C、?The?command?fails?because?the?database?is?running.D、?This?is?the?correct?way?to?address?this?problem.E、?This?is?not?the?correct?way?to?address?this?problem.17.Using?the?LIST?command?in?Recovery?Manager?（RMAN），?which?two?pieces?of?information?from?the?RMAN?repository?can?be?listed？?（）A、backups?that?can?be?deletedB、stored?scripts?in?the?recovery?catalogC、backup?sets?and?image?copies?that?are?obsoleteD、only?the?most?recent?backup?sets?or?image?copiesE、backups?that?do?not?have?the?AVAILABLE?status?in?RMAN?repository18.Given： What?is?the?result？（）A、Compilation?fails.B、Cannot?add?ToppingsC、The?code?runs?with?no?output.D、A?NullPointerException?is?thrown?in?Line?4.19.Given： Which?three?are?true？（）A、Cat?is-a?AnimalB、Cat?is-a?JumperC、Dog?is-a?AnimalD、Dog?is-a?JumperE、Cat?has-a?AnimalF、Beagle?has-a?Tail20.Whichthreetaskscanbeperformedusingaduplicatedatabase?（）(Choosethree.)A、TestingthebackupandrecoveryproceduresB、TestingtheupgradeofanOracledatabasetoanewreleaseC、TestingtheeffectofanapplicationchangesondatabaseperformanceD、Continuouslyupdatingarchivelogfilesfromthetargetdatabasetosupportfailover21.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.22.Anexistingmaster-slavesetupiscurrentlyusingadelayedreplicationofonehour.Themasterhascrashedandtheslavemustbe"rolledforward"toprovideallthelatestdata.TheSHOWSLAVESTATUSindicatesthefollowingvalues:RELAY_LOG_FILE=hostname-relay-bin.00004RELAY_LOG_POS=1383 Whichcommandsetwouldmaketheslavecurrent?（）A、STOPSLAVE;CHANGEMASTERTOMASTER_DELAY=0,RELAY_LOG_FILE='hostnamerelay-bin.00004',RELAY_LOG_POS=1383B、STOPSLAVE;CHANGEMASTERTORELAY_LOG_FILE='hostname-relay-bin.00004',RELAY_LOG_POS=1383C、STOPSLAVE;CHANGEMASTERTOMASTER_DELAY=0;STARTSLAVED、STOPSLAVE;SETGLOBALmaster_delay=0;STARTSLAVE23.WhatistheeffectofincreasingthevalueoftheASM_POWER_LIMITparameter?（）A、ThenumberofDBWRprocessesincreasesB、ThenumberofASMBprocessesincreasesC、ThenumberofDBWR_TO_SLAVESincreasesD、TherebalancingoperationinanASMinstancecompletesmorequickly,butcanresultinhigherI/Ooverhead24.You?are?using?flat?files?as?the?data?source?for?one?of?your?data?warehousing?applications.?To?optimize?theapplication?performance，?you?plan?to?move?the?data?from?the?flat?files?to?clustered?tables?in?an?Oracle?database.While?migrating?the?data，?you?want?to?have?minimal?impact?on?the?database?performance?and?optimize?the?dataload?operation.? Which?method?would?you?use?to?load?data?into?the?Oracle?database（）A、Use?the?external?table?population.B、Use?the?Oracle?Data?Pump?export?and?import?utility.C、Use?the?conventional?path?data?load?of?the?SQL*Loader?utility.D、Use?the?INSERT?INTO...SELECT?command?to?load?the?data25.Examine?the?following?commands?executed?in?your?database：?SQL>?ALTER?SESSION?RECYCLEBIN=ON；?Session?altered? SQL?>?CREATE?TABLE?emp?TABLESPACE?tbsfd?AS?SELECT?*?FROM?hr.employees；? Table?created.? Further，?you?executed?the?following?command?to?drop?the?table：? SQL>?DROP?TABLE?emp；Table?dropped.? What?happens?in?this?scenario？（）A、The?table?is?moved?to?the?SYSAUX?tablespace.B、The?table?is?moved?to?the?SYSTEM?tablespace.C、The?table?is?removed?from?the?database?permanently.D、The?table?is?renamed?and?remains?in?the?TBSFD?tablespace.第2卷一.參考題庫(共25題)1.Whichsyntaxturnsanexistingconstrainton?（）A、ALTERTABLEtable_nameENABLEconstraint_name;B、ALTERTABLEtable_nameSTATUS=ENABLECONSTRAINTconstraint_name;C、ALTERTABLEtable_nameENABLECONSTRAINTconstraint_name;D、ALTERTABLEtable_nameTURNONCONSTRAINTconstraint_name;2.You?work?as?a?database?administrator?for?S.?You?added?atablespaceto?your?database.?Because?of?the?changes?to?the?physical?structure?of?your?database，?you?performed?a?backup?of?the?control?file?to?trace.?After?this，?you?lost?only?the?control?files?and?the?instance?aborted?due?to?a?hardware?failure.?How?would?you?proceed?to?recover?the?database？（）A、Start?the?instance?and?open?the?database，?instance?recovery?automatically?recoverscontrol?filesB、Create?a?file?based?on?the?contents?of?the?trace?file?and?save?it?to?the?control?file?locations?and?start?the?databaseC、Re-create?the?database?（The?recovery?of?the?control?file?is?not?possible?because?you?have?lost?all?the?control?files.）D、Start?the?instance，?in?the?NOMOUNTstate，re-create?the?control?file?using?the?CREATE?CONTROLFILE?command?stored?in?the?trace?file.E、Start?the?instance?and?MOUNT?the?database，?then?re-create?the?control?file?using?the?CREATE?CONTROLFILE?command?stored?in?the?trace?file.3.Your?production?database?is?running?in?the?ARCHIVELOG?mode?and?the?ARCn?process?is?functional.?You?have?two?online?redo?log?groups.?Which?three?background?processes?would?be?involved?when?a?log?switch?happens？（）A、?log?writerB、?archivalC、?process?monitorD、?system?monitorE、?change?tracking?writerF、?database?writer4.在設(shè)置撤消表空間的自動管理功能時，DBA通過使用相關(guān)的初始化參數(shù)對自動撤消表空間進行配置。下面的4個參數(shù)中，哪一個不是與自動撤消管理功能相關(guān)的參數(shù)？（）A、UNDO_MANAGEMENTB、UNDO_TABLESPACEC、UNDO_RETENTIOND、TRANSACTIONS5.Given： 11.String?test?=?"This?is?a?test"； 12.String[]?tokens?=?test.split（"/s"）； 13.System.out.println（tokens.length）； What?is?the?result？（）A、0B、1C、4D、Compilation?fails.6.The?listener?uses?dynamic?information?about?the?database?and?instance?it?has?received?through?service?registration?before?using?information?statically?configured.?Some?services?such?as?heterogeneous?services?and?external?procedures?require?the?use?of?information?statically?configured?within?listener.ora.?In?order?to?support?this，?which?tool?could?be?used?to?configure?the?listener?statically？（）A、Oracle?Net?ManagerB、Listener?Control?UtilityC、Oracle?Net?Control?UtilityD、Oracle?Net?Configuration?Assistant7.Examinethestatement:Createsynonymempforhr.employees;Whathappenswhenyouissuethestatement?（）A、Anerrorisgenerated.B、YouwillhavetwoidenticaltablesintheHRschemawithdifferentnames.C、YoucreateatablecalledemployeesintheHRschemabasedonyouEMPtable.D、YoucreateanalternativenamefortheemployeestableintheHRschemainyourownschema.8.You?have?set?the?value?of?the?NLS_TIMESTAMP_TZ_FORMAT?parameter?in?the?parameter?file?to?YYYY-MM-DD.?The?default?format?of?which?two?data?types?would?be?affected?by?this?setting？?（）A、?DATEB、?TIMESTAMPC、?INTERVAL?YEAR?TO?MONTHD、?INTERVAL?DAY?TO?SECONDE、?TIMESTAMP?WITH?LOCAL?TIME?ZONE9.You?are?installing?Oracle?Database?11g?on?your?server.?During?the?installation?Oracle?Universal?Installer?（OUI） prompts?you?to?enter?the?path?of?the?inventory?directory?and?also?prompts?you?to?specify?an?operating?systemgroup?name.? Which?statement?is?true?in?this?case（）A、The?ORACLE_BASE?parameter?is?not?set.B、The?installation?is?being?performed?by?the?root?user.C、The?operating?system?group?that?will?be?specified?should?have?root?user?as?its?member.D、The?installation?is?being?performed?without?the?"Create?Starter?Database"?option?selected.E、The?operating?system?group?that?will?be?specified?must?have?permission?to?write?to?the?inventory?directory10.WhataretwomethodsoftakingabinarybackupofaMysqlServerusingInnoDBstorageengine?（）A、FilesystemsnapshotsB、MysqldumpslowC、MysqlhotcopyD、Mysqldumpwith–binary-dataoptionE、MysqlEnterpriseBackup11.While?tuning?a?SQL?statement，?the?SQL?Tuning?Advisor?finds?an?existing?SQL?profile?for?the?statement?that?has?stale?statistics?available.?What?would?the?optimizer?do?in?this?situation？（）??A、?It?updates?the?existing?SQL?profiles?with?current?statisticsB、?It?makes?the?statistics?information?available?to?GATHER_STATS_JOBC、?It?initiates?the?statistics?collection?process?by?running?GATHER_STATS_JOBD、?It?logs?a?warning?message?in?the?alert?log?so?that?the?DBA?can?perform?statistics?collection?manually12.Which?of?these?are?valid?Flashback?Database?recovery?point?parameters？（）?A、?SCNB、?TimestampC、?Named?recovery?pointD、?Transaction?IDE、?Session?ID13.當需要在數(shù)據(jù)庫運行時修改最大并發(fā)使用限制或者警告限制，可以使用如下（）語句。A、ALTERSYSTEMB、ATLERTABLEC、ALTERVIEWD、ALTERTRIGER14.A?company?has?a?business?application?that?provides?its?users?with?many?different?reports： receivables?reports，?payables?reports，?revenue?projects，?and?so?on.?The?company?has?just?purchased?somenew，?state-of-the-art，?wireless?printers，?and?a?programmer?has?been?assigned?the?task?of?enhancing?all?ofthe?reports?to?use?not?only?the?company’s?old?printers，?but?the?new?wireless?printers?as?well.?When?theprogrammer?starts?looking?into?the?application，?the?programmer?discovers?that?because?of?the?design?of?theapplication，?it?is?necessary?to?make?changes?to?each?report?to?support?the?new?printers. Which?two?designconcepts?most?likely?explain?this?situation？?（）A、InheritanceB、Low?cohesionC、Tight?couplingD、High?cohesionE、Loose?couplingF、Object?immutability15.Anapplicationaccessesasmalllookuptablefrequently.Younoticethattherequireddatablocksaregettingagedoutofthedefaultbuffercache. Howwouldyouguaranteethattheblocksforthetableneverageout?（）A、ConfiguretheKEEPbufferpoolandalterthetablewiththecorrespondingstorageclause.B、Increasethedatabasebuffercachesize.C、ConfiguretheRECYCLEbufferpoolandalterthetablewiththecorrespondingstorageclause.D、ConfigureAutomataSharedMemoryManagement.E、ConfigureAutomaticMemoryManagement16.Ml?Managed?Servers?in?a?domain?must?run?the?of?the?OrcleWebLogic?Server?software（）A、?same?version?B、?different?versionsC、?same?patch?setD、?most?recent?patch?set17.To?increase?the?availability?of?an?Advanced?Replication?environment，?you?can?add?a?new?master?to?a?replication?group?without?quiescing?the?group.?This?is?achieved（）.A、Only?when?the?new?master?site?already?has?existing?replication?groups.?B、By?issuing?a?single?command?to?create,?populate,?and?activate?the?new?master.?C、When?the?master?definition?site?is?not?the?same?for?all?of?the?master?groups.?D、Without?impacting?end?users?who?are?executing?data?manipulation?language?(DML)?commands?on?the?replicated?tables.18.Given：? Which?code，?inserted?at?line?15，?creates?an?instance?of?the?Point?class?defined?in?Line？（）A、?Line?l?=?new?Line（）?；?l.Point?p?=?new?l.Point（）；B、?Line.Point?p?=?new?Line.Point（）；C、?The?Point?class?cannot?be?instatiated?at?line?15.D、?Point?p?=?new?Point（）；19.Oracle內(nèi)置程序包由（）用戶所有。A、sysB、systemC、scottD、Public20.Youupgradedyourdatabasefrompre-12ctoamultitenantcontainerdatabase(CDB)containingpluggabledatabases(PDBs). Examinethequeryanditsoutput: WhichtwotasksmustyouperformtoadduserswithSYSBACKUP,SYSDG,andSYSKMprivilegetothepasswordfile?（）A、AssigntheappropriateoperatingsystemgroupstoSYSBACKUP,SYSDG,SYSKM.B、GrantSYSBACKUP,SYSDG,andSYSKMprivilegestotheintendedusers.C、Re-createthepasswordfilewithSYSBACKUP,SYSDG,andSYSKMprivilegeandtheFORCEargumentsettoNo.D、Re-createthepasswordfilewithSYSBACKUP,SYSDG,andSYSKMprivilege,andFORCEargumentssettoYes.E、Re-createthepasswordfileintheOracleDatabase12cformat.21.Click?the?Exhibit?button. Which?three?code?fragments，?added?individually?at?line?29，?produce?the?output?100？（）A、n?=?100；B、i.setX（?100?）；C、o.getY（）.setX（?100?）；D、i?=?new?Inner（）；?i.setX（?100?）；E、o.setY（?i?）；?i?=?new?Inner（）；?i.setX（?100?）；F、i?=?new?Inner（）；?i.setX（?100?）；?o.setY（?i?）；22.The?current?time?is?12：00?noon.?You?want?to?recover?the?USERS?tablespace?from?a?failure?that?occurred?at?11：50?a.m.?You?discover?that?the?only?member?of?an?unarchived?redo?log?group?containing?information?from?11：40?a.m.?onwards?is?corrupt.? With?reference?to?this?scenario，?if?you?are?not?using?Recovery?Manager?（RMAN），?which?recovery?method?would?you?use？（）A、time-based?recoveryB、log?sequence?recoveryC、cancel-based?recoveryD、change-based?recovery23.Oracle管理數(shù)據(jù)庫存儲空間的最小數(shù)據(jù)存儲單位是（）。A、數(shù)據(jù)塊B、表空間C、表D、區(qū)間24.Which??statements?regarding?the?server?parameter?file?（SPFILE）?are?true（）A、An?SPFILE?is?a?binary?file.B、An?SPFILE?cannot?reside?on?a?client.C、An?SPFILE?cannot?contain?static?parameters.D、An?SPFILE?can?store?changes?persistently?across?instance?restarts.E、An?SPFILE?can?be?read?by?the?database?server，?but?it?is?not?written?to?by?the?server.F、An?SPFILE?must?be?created?manually，?before?creating?a?database，?even?if?you?use?the?DatabaseConfiguration?Assistant?（DBCA）?to?create?the?database25.Which?two?statements?are?true？（）A、It?is?possible?for?more?than?two?threads?to?deadlock?at?once.B、The?JVM?implementation?guarantees?that?multiple?threads?cannot?enter?into?a?deadlocked?state.C、Deadlocked?threads?release?once?their?sleep（）?method’s?sleep?duration?has?expired.D、Deadlocking?can?occur?only?when?the?wait（），?notify（），?and?notifyAll（）?methods?are?used?incorrectly.E、It?is?possible?for?a?single-threaded?application?to?deadlock?if?synchronized?blocks?are?used?incorrectly.F、If?a?piece?of?code?is?capable?of?deadlocking，?you?cannot?eliminate?the?possibility?ofdeadlocking?byinsertinginvocations?of?Thread.yield（）.第3卷一.參考題庫(共25題)1.ExaminetheSQLstatementsthatcreatesORDERStable: CREATETABLEorders (SER_NONUMBERUNIQUE, ORDER_IDNUMBER, ORDER_DATEDATENOTNULL STATUSVARCHARD2(10) CHECK(statusIN('CREDIT','CASH')), PROD_ID_NUMBER REFERENCESPRODUCTS(PRODUCT_ID), ORD_TOTALNUMBER, PRIMARYKEY(orderid,orderdate)); ForwhichcolumnswouldanindexbeautomaticallycreatedwhenyouexecutetheaboveSQLstatement?（）A、SER_NOB、ORDER_IDC、STATUSD、PROD_IDE、ORD_TOTALF、CompositeindexonORDER_IDandORDER_DATE2.YouaddedaPHONE_NUMBERcolumnofNUMBERdatatypetoanexistingEMPLOYEEStable.TheEMPLOYEEStablealreadycontainsrecordsof100employees.Now,youwanttoenterthephonenumbersofeachofthe100employeesintothetable.Someoftheemployeesmaynothaveaphonenumberavailable. Whichdatamanipulationoperationdoyouperform?（）A、MERGEB、INSERTC、UPDATED、ADDE、ENTERF、Youcannotenterthephonenumbersfortheexistingemployeerecords.3.In?what?view?are?you?likely?to?see?the?following?output？（）?? SID?SERIAL#?EVENT?SECONDS_IN_WAIT? 121?269?RMAN?backup?&?recovery?I/O?2? 129?415?SQL*Net?message?from?client?63?130?270?SQL*Net?message?from?client??A、?V$SESSION_EVENTB、?V$SESSIONC、?V$WAITSD、?V$WAITSTATE、?V$SYSSTAT4.You?noticed?that?the?index?tablespace?in?your?database?requires?a?recovery.?However，?instead?of?performing?a?media?recovery，?you?decided?to?re-create?the?indexes?in?a?new?tablespace.?Which?two?options?would?you?use?to?reduce?the?time?it?takes?to?re-create?the?indexes？（）A、?ONLINEB、?REVERSEC、?PARALLELD、?COMPRESSE、?NOLOGGINGF、?COMPUTE?STATISTICS5.ABCCorp.isimplementing11iOracleApplications.Thecompanyhastwolocaladministratorsinseparatelocations.Theyneedtoensurethatonlyarelevantsetofusersisvisibletoeachoftheselocaladministrators. Whichactionwillmeettherequirement?（）A、createaseparateroleforeachlocaladministratorB、specifyuseradministrationprivilegesinOracleUserManagementC、useDataSecuritytoproviderelevantaccesstoeachlocaladministratorD、useFunctionSecuritytoproviderelevantaccesstoeachlocaladministrator6.下列哪個子句實現(xiàn)對一個結(jié)果集進行分組和匯總？（）A、HAVINGB、ORDERBYC、WHERED、GROUPBY7.Which?three?statements?are?true?about?logical?structures?of?the?Oracle?database（）A、Each?segment?contains?one?or?more?extents.B、Multiple?tablespaces?can?share?a?single?data?file.C、A?data?block?is?the?smallest?unit?of?input/output?（I/O）?in?data?files.D、It?is?possible?to?have?tablespaces?of?different?block?sizes?in?a?database.E、Each?data?block?in?the?database?always?corresponds?to?one?operating?system?block.8.Whichoperatorcanbeusedwithamultiple-rowsubquery?（）A、=B、LIKEC、BETWEEND、NOTINE、ISF、9.Which?of?the?following?options?is?true?about?shutting?down?an?Automatic?Storage?Management?（ASM）?instance？（）??A、?If?the?SHUTDOWN?IMMEDIATE?command?is?issued?to?the?ASM?instance，?the?ASM?instance?immediately?shuts?down.B、?If?the?SHUTDOWN?ABORT?command?is?issued?to?the?ASM?instance，?the?ASM?instance?will?shut?down?all?the?database?instances?and?then?shut?down?immediately.C、?If?the?SHUTDOWN?NORMAL?command?is?issued?to?the?ASM?instance，?before?shutting?down，?the?ASM?instance?waits?for?the?dependent?database?instances?to?shut?down.D、?If?the?SHUTDOWN?TRANSACTIONAL?command?is?issued?to?the?ASM?instance，?the?ASM?instance?passes?the?same?SHUTDOWN?command?to?the?dependent?database?instances，?but?does?not?wait?for?any?active?transactions?to?complete?before?it?shuts?down.10.Where?can?you?obtain?information?about?full?database?backup?set?created?using?RMAN，?if?the?control?file?was?used?as?the?repository？（）A、V$BACKUPSETB、RC_DATABASEC、V$BACKUP_SETD、RC_BACKUP_SET11.After?performing?a?clean?shut?down?of?the?database?instance?for?maintenance，?you?mount?the?database?andthen?execute?a?command?to?open?the?database：SQL>?ALTER?DATABASE?OPEN； Which?two?statements?are?true（）A、The?online?redo?log?files?and?online?data?files?are?opened.B、All?the?online?data?file?headers?are?checked?for?consistency.C、Insta