2024年計(jì)算機(jī)考試-Oracle認(rèn)證考試近5年真題集錦（頻考類試題）帶答案

（圖片大小可自由調(diào)整）2024年計(jì)算機(jī)考試-Oracle認(rèn)證考試近5年真題集錦（頻考類試題）帶答案第I卷一.參考題庫(共100題)1.You?have?created?a?job?class，?CUST_JOB_1，?with?two?jobs，?CUST_JOB_1_A?and?CUST_JOB_1_B.?Which?two?statements?are?true？?（）A、?The?member?jobs?would?get?dropped?when?the?job?class?is?dropped.B、?Both?the?jobs?would?be?executed?concurrently.C、?The?member?jobs?would?get?disabled?when?the?job?class?is?dropped.D、?The?attributes?defined?at?the?class?level?would?be?applied?to?both?the?jobs.E、?Jobs?in?the?job?class?must?have?been?assigned?the?same?priority.2.Using?a?bitmap?structure?to?manage?database?object?space?has?several?benefits?over?using?freelist?structures.?Which?three?are?benefits?of?managing?space?using?automatic-segment-space?managed?objects？（）A、It?readily?responds?to?dynamic?changes?for?concurrent?access.?B、It?improves?performance?and?space?utilization?in?a?multiple-instance?environment.?C、It?requires?fewer?space?related?options?then?freelist?managed?structures.?D、It?improves?performance?for?SYSTEM?tablespaces?where?a?high?degree?of?concurrency?is?required.3.假定某非本機(jī)數(shù)據(jù)庫的全局?jǐn)?shù)據(jù)庫名為ORCL.COM，數(shù)據(jù)庫實(shí)例的SID為ORCL，定義的這個(gè)數(shù)據(jù)庫的連接串為ORCLDB，數(shù)據(jù)庫的用戶名為scott，口令為tiger.那么以下哪個(gè)命令可以登錄這個(gè)數(shù)據(jù)庫（）A、sqlplusscott/tigerB、sqlplusscott/tiger@ORCL.COMC、sqlplusscott/tiger@ORCLD、sqlplusscott/tiger@ORCLDBE、以上所述都不正確4.Which?two?statements?are?true?regarding?hot?patching？（）A、?It?requires?relinking?of?the?Oracle?binary.B、?It?does?not?require?database?instance?shutdown.C、?It?can?detect?conflicts?between?two?online?patches.D、?It?is?available?for?installing?all?patches?on?all?platforms.?E、?It?works?only?in?a?single?database?instance?environment.5.What?view?might?you?use?to?try?to?determine?how?long?a?particular?backup?will?take?（）A、V$SESSION_EVENT?B、V$SESSION?C、V$W0041ITSD、V$WAITSTAT?E、V$SESSION_LONGOPS?6.You?want?to?create?a?new?optimized?database?for?your?transactional?production?environment?to?be?used?by?a?financial?application.?While?creating?the?database，?you?want?the?Oracle?software?to?take?care?of?all?basic?settings?to?optimize?the?database?performance.?Which?method?would?you?use?to?achieve?this?objective？（）A、Use?the?CREATE?DATABASE?..?command?to?create?the?database?with?Oracle-managed?files.?B、Use?the?Database?Configuration?Assistant?(DBCA)?to?create?the?database?with?Oracle-managed?files.?C、Use?Enterprise?Manager?to?create?a?new?database?with?the?Online?Transaction?Processing?(OLTP)?option.?D、Use?Database?Configuration?Assistant?(DBCA)?to?create?the?database?with?Transaction?Processing?template.?E、Use?the?CREATE?DATABASE?..?command?to?create?the?database?with?Automatic?Storage?Management?(ASM)?file?system.7.ExaminethedescriptionoftheEMPLOYEEStable: Whichstatementshowsthemaximumsalarypaidineachjobcategoryofeachdepartment?（）A、SELECTdept_id,job_cat,MAX(salary)

FROMemployees

WHEREsalary>MAX(salary);B、SELECTdept_id,job_cat,MAX(salary)

FROMemployees

GROUPBYdept_id,job_cat;C、SELECTdept_id,job_cat,MAX(salary)

FROMemployees;D、SELECTdept_id,job_cat,MAX(salary)

FROMemployees

GROUPBYdept_id;E、SELECTdept_id,job_cat,MAX(salary)

FROMemployees

GROUPBYdept_id,job_cat,salary;8.You?have?three?databases，?FINDB，?PAYDB?and?ADMINDB，?located?in?Sydney，?Tokyo?and?Singapore?respectively.?You?want?to?perform?administrative?tasks?which?include?starting?up?and?shutting?down?the?databases，?creating?and?managing?tablespaces?and?database?users，?and?taking?regular?backups，?for?all?of?the?three?databases?from?London.?Which?component?must?be?enabled?and?running?on?each?host?machine?to?achieve?your?objective？（）A、Oracle?Management?AgentB、Enterprise?Manager?with?Grid?ControlC、Enterprise?Manager?with?Database?ControlD、Operating?System?Socket?for?incoming?requestsE、Real?Application?Cluster?（RAC）?with?three?instancesF、Enterprise?Manager?with?Generic?Database?Management9.在登錄到OracleEnterpriseManager時(shí)，要求驗(yàn)證用戶的身份。下面不屬于可以選擇的身份是（）。A、NormalB、SYSOPERC、SYSDBAD、Administrator10.WhatistrueofusinggroupfunctionsoncolumnsthatcontainNULLvalues?（）A、GroupfunctionsoncolumnsignoreNULLvalues.B、GroupfunctionsoncolumnsreturningdatesincludeNULLvalues.C、GroupfunctionsoncolumnsreturningnumbersincludeNULLvalues.D、GroupfunctionsoncolumnscannotbeaccuratelyusedoncolumnsthatcontainNULLvalues.E、GroupfunctionsoncolumnsincludeNULLvaluesincalculationsifyouusethekeywordINC_NULLS.11.You?are?working?on?a?CATDB?database?that?contains?an?Oracle?Database?version?11.1?catalog?schema?owned?by?the?user?RCO11.?The?INST1?database?contains?an?Oracle?Database?version?10.1?catalog?schema?owned?by?the?user?RCAT10.? You?want?the?RMAN?to?import?metadata?for?database?IDs?1423241?and?1423242，?registered?in?RCAT10，?into?the?recovery?catalog?owned?by?RCO11.?You?executed?the?following?commands：?RMAN>?CONNECT?CATALOG?rco11/password@catdb? RMAN>?IMPORT?CATALOG?rcat10/oracle@inst1?NO?UNREGISTER；?? Which?two?statements?are?true?regarding?the?tasks?accomplished?with?these?commands？（）A、?They?import?all?metadata?from?the?RCAT10?catalog.B、?They?unregister?the?database?from?the?RCAT10?catalog.C、?They?do?not?register?the?databases?registered?in?the?RCAT10?catalog.D、?They?register?all?databases?registered?in?the?RCAT10?catalog.12.DESCstudent的作用是什么？13.WhichareDMLstatements?（）A、COMMITB、MERGEC、UPDATED、DELETEE、CREATEF、DROP...14.Oracle9i?provides?a?database?package?called?dbms_redefinition?to?perform?an?online?rebuild?of?a?table.? Which?two?steps?are?you?recommended?to?do?prior?to?issuing?thedbms_redefinition_start_redef?table?procedure?call？（）A、Grand?privileges?on?the?interim?table.B、Invoke?the?dbms_redefinition.can_redef_table?procedure.C、Invoke?the?dbms_redefinition.sync_interim_table?procedure.D、Create?any?triggers，?indexes，?or?constraints?on?the?interim?table.E、Create?an?empty?interim?table?with?all?the?desired?characteristics.15.The?user?HR?receives?the?following?error?while?inserting?data?into?the?TTK?table：ERROR?at?line?1： ORA-01653：?unable?to?extend?table?HR.TTK?by?128?in?tablespace?SMD?Upon?investigation，?you?find?that?SMDis?a?small?file?tablespace. Which?three?action?would?allow?the?user?to?insert?data（）A、Add?a?data?file?to?the?SMD?tablespace.B、Add?a?data?file?to?the?temporary?tablespace?associated?with?the?user?HR.C、Resize?the?data?file?associated?with?the?SMD?tablespace?to?make?it?larger.D、Alter?the?data?file?associated?with?the?SMD?tablespace?to?grow?automatically.E、Change?the?segment?space?management?for?the?SMD?tablespace?to?automatic16.ExaminethestructureoftheEMPLOYEESandNEW_EMPLOYEEStables:EMPLOYEES EMPLOYEE_IDNUMBERPrimaryKey FIRST_NAMEVARCHAR2(25) LAST_NAMEVARCHAR2(25) HIRE_DATEDATE NEWEMPLOYEES EMPLOYEE_IDNUMBERPrimaryKey NAMEVARCHAR2(60) WhichDELETEstatementisvalid?（）A、DELETEFROMemployeesWHEREemployee_id=(SELECTemployee_idFROMemployees);B、DELETE*FROMemployeesWHEREemployee_id=(SELECTemployee_idFROMnew_employees);C、DELETEFROMemployeesWHEREemployee_idIN(SELECTemployee_idFROMnew_employeesWHEREname=('Carrey')'D、DELETE*FROMemployeesWHEREemployee_idIN(SELECTemployee_idFROMnew_employeesWHERElast_name=('Carrey')'17.下列哪一個(gè)操作可以用來為一個(gè)備份操作手動(dòng)分配通道？（）A、ALLOCATECHANNELB、CREATECHANNELC、CHANNELALLOCATED、CREATELINK18.To?save?time?configuring?some?custom?network?facilities，?a?junior?administrator?in?your?company? attempts?to?copy?some?entries?from?the?/etc/inetd.conf?file?on?a?Solaris?8?OS?server?into?the?/etc/inetd.conf?on?a?Solaris?10?OS?server.?The?junior?administrator?is?unable?to?determine?why?services?do?not?start.? Which?two?commands?can?you?run?on?the?Solaris?10?OS?server?to?start?the?services？（）A、?inetconv?-fB、?inetcfg?-i?/etc/inetd.confC、?inetcfg?-o?/etc/inetd.confD、?inetconv?-f?-i?/etc/inetd.confE、?inetconv?-forceimport?-o?/etc/inetd.conf19.These?are?the?details?about?V$FLASHBACK_DATABASE_STAT：?SQL>?DESC?v$FLASHBACK_DATABASE_STAT? Name????????????????????Null？??????????????Type? -------------?--------?--------------? BEGIN_TIME???????????????????????????????DATE? END_TIME?????????????????????????????????DATE? FLASHBACK_DATA????????????????????????NUMBER? DB_DATA??????????????????????????????????NUMBER? REDO_DATA???????????????????????????????NUMBER? ESTIMATED_FLASHBACK_SIZE?????????????NUMBER? Which?two?statements?regarding?the?V$FLASHBACK_DATABASE_STATview?aretrue？?（）A、?BEGIN_TIME?is?the?time?at?which?Flashback?logging?is?enabled.B、?END_TIME?is?the?time?at?which?the?query?is?executed?on?the?view.C、?REDO_DATA?is?the?number?of?bytes?of?redo?data?written?during?the?interval.D、?This?view?contains?information?about?flashback?data?pertaining?to?the?last?24?hours.E、?FLASHBACK_DATA?is?the?amount?of?flashback?data?generated?since?the?database?was?opened.20.TheEMPLOYEEtableshasthesecolumns: LAST_NAMEVARCHAR2(35) SALARYNUMBER(8,2) COMMISSION_PCTNUMBER(5,2) Youwanttodisplaythenameandannualsalarymultipliedbythecommission_pctforallemployees.ForrecordsthathaveaNULLcommission_pct,azeromustbedisplayedagainstthecalculatedcolumn. WhichSQLstatementdisplaysthedesiredresults?（）A、SELECTlast_name,(salary*12)*commission_pctFROMEMPLOYEES;B、SELECTlast_name,(salary*12)*IFNULL(commission_pct,0)FROMEMPLOYEES;C、SELECTlast_name,(salary*12)*NVL2(commission_pct,0)FROMEMPLOYEES;D、SELECTlast_name,(salary*12)*NVL(commission_pct,0)FROMEMPLOYEES;21.Given： What?creates?the?appropriate?DateFormat?object?and?adds?a?day?to?the?Date?object？（）A、35.?DateFormat?df?=?DateFormat.getDateFormat（）；42.?d.setTime（?（60?*?60?*?24）?+?d.getTime（））；B、35.?DateFormat?df?=?DateFormat.getDateInstance（）；42.?d.setTime（?（1000?*?60?*?60?*?24）?+?d.getTime（））；C、35.?DateFormat?df?=?DateFormat.getDateFormat（）；42.?d.setLocalTime（?（1000*60*60*24）?+?d.getLocalTime（））；D、35.?DateFormat?df?=?DateFormat.getDateInstance（）；42.?d.setLocalTime（?（60?*?60?*?24）?+?d.getLocalTime（））；22.You?need?to?create?a?trigger?to?locate?the?Product?report?in?the?Rpt_Server,?run?the?report,?and?test?the?status?of?the?report.?Which?three?built-ins?would?you?use?to?accomplish?this?task?（）A、RUN_PRODUCT?B、SET_REPORT_OBJECT_PROPERTY?C、RUN_REPORT_OBJECT?D、FIND_REPORT_OBJECT?E、REPORT_OBJECT_STATUS?F、COPY_REPORT_OBJECT_OUTPUT23.What?feature?comes?into?play?to?help?ensure?the?completion?of?the?backup?should?one?of?three?backup?devices?fail?during?a?backup?that?is?using?three?different?channels?（）A、Channel?failoverB、Restartable?backups?C、Rescheduable?backups?D、Automatic?backup?recovery?E、Channel?recovery24.Whichtwostatementscompleteatransaction?（）A、DELETEemployees;B、DESCRIBEemployees;C、ROLLBACKTOSAVEPOINTC;D、GRANTSELECTONemployeesTOSCOTT;E、ALTERTABLEemployees

SETUNUSEDCOLUMNsal;F、SelectMAX(sal)

FROMemployees

WHEREdepartment_id=20;25.YouareconnectedusingSQL*Plustoamultitenantcontainerdatabase(CDB)withSYSDBAprivilegesandexecutethefollowingsequencestatements:WhatistheresultofthelastSETCONTAINERstatementandwhyisitso?（）A、ItsucceedsbecausethePDB_ADMINuserhastherequiredprivileges.B、ItfailsbecausecommonusersareunabletousetheSETCONTAINERstatement.C、ItfailsbecauselocalusersareunabletousetheSETCONTAINERstatement.D、IffailsbecausetheSETCONTAINERstatementcannotbeusedwithPDB$SEEDasthetargetpluggabledatabase(PDB).26.用于在啟動(dòng)實(shí)例時(shí)配置數(shù)據(jù)庫，確定Oracle11g的運(yùn)行環(huán)境文件是（）。A、參數(shù)文件B、數(shù)據(jù)文件C、可執(zhí)行文件D、控制文件27.You?have?set?the?value?of?the?NLS_TIMESTAMP_TZ_FORMAT?parameter?in?the?parameter?file?to?YYYY/x7fMM/x7fDD.?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?ZONE28.ClicktheExhibitbuttontoexaminethestructuresoftheEMPLOYEES,DEPARTMENTS,andTAXtables. Forwhichsituationwouldyouuseanonequijoinquery?（）A、tofindthetaxpercentageforeachoftheemployeesB、tolistthename,job_id,andmanagernameforalltheemployeesC、tofindthename,salary,andthedepartmentnameofemployeeswhoarenotworkingwithSmithD、tofindthenumberofemployeesworkingfortheAdministrativedepartmentandearninglessthan4000E、todisplayname,salary,managerID,anddepartmentnameofalltheemployees,eveniftheemployeesdonothaveadepartmentIDassigned29.Which?two?statements?are?true?about?mouse?button?variables?（）A、SYSTEM.MOUSE_BUTTON_PRESSED?returns?a?string.?B、SYSTEM.MOUSE_BUTTON_PRESSED?returns?a?numeric?value.?1Z0-132?World?Leaders?InCertifications?Material?-?T?C、A?possible?value?for?SYSTEM.MOUSE_BUTTON_MODIFIERS?is?Control+Alt+Delete.?D、SYSTEM.MOUSE_BUTTON_MODIFIERS?can?only?be?references?in?form-level?triggers.?E、SYSTEM.MOUSE_BUTTON_MODIFIERS?identifies?which?special?key?was?pressed?in?conjunction?with?the?usual?mouse?button?action.?30.In?the?parameter?file?of?the?production?database，?the?BACKGROUND_DUMP_DEST?parameter?is?set?to?$ORACLE_HOME/users.?Which?two?types?of?files?would?you?find?in?this?location？（）A、the?alert?log?fileB、the?core?dump?filesC、the?change?tracking?fileD、the?user?session?trace?filesE、the?database?audit?trail?filesF、the?background?process?trace?files31.You?work?as?a?database?administrator?for?S.?One?of?the?user?sessions?was?terminated?abnormally?in?the?middle?of?a?transaction.?What?does?Oracle?database?do?to?recover?it？（）A、Uses?undo?data?for?roll?forwardB、Uses?Flashback?Log?for?recoveryC、Uses?online?redo?logs?to?roll?backD、Uses?undo?data?to?roll?back?the?transactionE、Uses?Recovery?Manager?（RMAN）?to?roll?backF、Uses?the?System?Monitor?（SMON）?background?process?to?perform?instance?recovery32.WhichthreeareDATETIMEdatatypesthatcanbeusedwhenspecifyingcolumndefinitions?（）A、TIMESTAMPB、INTERVALMONTHTODAYC、INTERVALDAYTOSECONDD、INTERVALYEARTOMONTHE、TIMESTAMPWITHDATABASETIMEZONE33.WhichfouractionsarepossibleduringanOnlineDatafileMoveoperation?（）A、CreatinganddroppingtablesinthedatafilebeingmovedB、PerformingfileshrinkofthedatafilebeingmovedC、QueryingtablesinthedatafilebeingmovedD、PerformingBlockMediaRecoveryforadatablockinthedatafilebeingmovedE、FlashingbackthedatabaseF、ExecutingDMLstatementsonobjectsstoredinthedatafilebeingmoved34.Whichthreearetrueregardingtheuseofouterjoins?（）A、YoucannotuseINoperatorinaconditionthatinvolvesanouterjoin.B、Youuse(+)onbothsidesoftheWHEREconditiontoperformanouterjoin.C、Youuse(*)onbothsidesoftheWHEREconditiontoperformanouterjoin.D、Youuseanouterjointoseeonlytherowsthatdonotmeetthejoincondition.E、IntheWHEREcondition,youuse(+)followingthenameofthecolumninthetablewithoutmatchingrows,toperformanouterjoin.F、YoucannotlinkaconditionthatisinvolvedinanouterjointoanotherconditionbyusingtheORoperator.35.Users?in?your?production?database?complain?that?they?are?getting?the?following?error?message?while?trying?to?insert?rows?into?the?ORDERS?table：? ERROR?at?line?1：? ORA/x7f01654：?unable?to?extend?index?USERS.ORDERS_IND?by?8?in?tablespace?INDEXES? While?investigating，?you?find?that?the?INDEXES?tablespace?has?run?out?of?space?and?there?is?no?more?free?space?on?the?disk?where?the?data?files?are?available.? Which?two?actions?could?you?perform?to?overcome?this?error?without?affecting?the?queries?that?are?currently?being?executed？（）A、drop?and?re-create?the?indexB、coalesce?the?ORDERS_IND?indexC、coalesce?the?INDEXES?tablespaceD、drop?and?re-create?the?ORDERS?tableE、rebuild?the?index?online?and?move?it?to?another?tablespace36.You?received?these?error?messages?because?the?client?cannot?find?the?desired?database：?? ORA-12198：?TNS：could?not?path?to?destination? ORA-12203：?TNS：unable?to?connect?to?destination? Which?action?would?be?appropriate?in?helping?to?resolve?the?errors？（）A、AB、BC、C37.Which?dynamic?view?displays?the?status?of?block-change?tracking?（）A、V$BLOCK_CHANGE?B、V$BLOCK_CHANGE_TRACKING?C、V$BLOCKCHANGE?D、V$BLOCK_TRACKING38.View?the?Exhibit?to?examine?the?output?of?the?DBA_OUTSTANDING_ALERTS?view. After?30?minutes，?you?executed?the?following?command：? SQL>?SELECT?reason，metric_value?FROM?dba_outstanding_alerts；?REASON?????????METRIC_VALUE? ------------------------------------------------------------??------------? Tablespace?[TEST]?is?[28?percent]full??28.125? What?could?be?the?reason?for?the?elimination?of?the?other?rows?in?the?output（）A、An?Automatic?Workload?Repository?snapshot?has?been?taken?recently.B、The?non-threshold-based?alerts?are?transferred?to?DBA_ALERT_HISTORY.C、The?threshold?alerts?conditions?are?cleared?and?the?alerts?are?transferred?to?DBA_ALERT_HISTORY.D、The?threshold?alerts?related?to?database?metrics?are?permanently?stored?in?DBA_ALERT_HISTORY?but?not?the?threshold?alerts?related?to?instance?metrics.39.Yourdatabaseinstanceisrunning.YouarenotabletoaccessOracleEnterpriseManagerDatabaseControlbecausethelistenerisnotstarted.Whichtoolorutilitywouldyouusetostartthelistener?（）A、OracleNetManagerB、ListenerControlutilityC、DatabaseConfigurationAssistantD、OracleNetConfigurationAssistant40.WhichthreeactionsarerequiredtoconfiguretheFlashbackDatabase?（）A、setFlashRecoveryAreaB、enableFlashbackloggingC、createFLASHBACKtablespaceD、startthedatabaseintheARCHIVELOGmodeE、startthedatabaseintheNOARCHIVELOGmode41.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?script42.WhichofthefollowinginformationwillbegatheredbytheSQLTestCaseBuilderfortheproblemspertainingtoSQL-relatedproblems?（）A、ADRdiagnosticfilesB、alltheoptimizerstatisticsC、initializationparametersettingsD、PL/SQLfunctions,procedures,andpackagesE、thetableandindexdefinitionsandactualdata43.EvaluatetheSQLstatement: Whatistheresultofthestatement?（）A、Thestatementproducesanerroratline1.B、Thestatementproducesanerroratline3.C、Thestatementproducesanerroratline6.D、Thestatementreturnstheemployeename,salary,departmentID,andmaximumsalaryearnedinthedepartmentoftheemployeeforalldepartmentsthatpaylesssalarythenthemaximumsalarypaidinthecompany.E、Thestatementreturnstheemployeename,salary,departmentID,andmaximumsalaryearnedinthedepartmentoftheemployeeforallemployeeswhoearnlessthanthemaximumsalaryintheirdepartment.44.TheEMPtableexistsinyourschema.Youwanttoexecutethefollowingquery: SELECTename,sal FROMemp ASOFTIMESTAMP(SYSTIMESTAMP-INTERVAL'6'MINUTE) WHEREename='ALLEN'; Whataretheminimumrequirementsforthestatementtoexecutesuccessfully?（）A、ARCHIVELOGmodemustbeenabledB、RowMovementmustbeenabledforthetableC、FLASHBACKmustbesettoONforthedatabaseD、TheUNDO_MANAGEMENTparametermustbesettoAUTOE、TheUNDO_RETENTIONparametermustbesetappropriately45.You?are?working?on?an?instance?started?using?the?SPFILE.?You?want?to?move?the?Flash?Recovery?Areaof?your?database?to?a?new?location.?You?want?the?Flashback?log?files?to?be?stored?in?the?new?location.?Given?below?are?the?steps?to?accomplish?the?task?in?random?order：? 1）Shut?down?the?instance.? 2）Change?the?value?of?the?DB_RECOVERY_FILE_DEST?initialization?parameter?to?a?new?value.? 3）Execute?the?ALTER?DATABASE?FLASHBACK?OFF?command.? 4）Start?up?the?instance?and?mount?the?database.? 5）Execute?the?ALTER?DATABASE?FLASHBACKON?command.? 6）Open?the?database.? Select?the?correct?order?in?which?these?tasks?need?to?be?performed.?（）A、2，1，4，3，5，6B、1，4，3，2，6，5C、1，4，2，6，3，5D、3，2，1，4，5，646.You?issued?the?following?statement：?? SQL>ALTER?DATABASE?ENABLE?RESUMABLE?TIMEOUT?n；?? What?will?be?the?result?of?issuing?the?above?statement？（）A、The?command?will?not?execute?successfully?because?TIMEOUT?is?an?invalid?clause?with?the?ALTER?DATABASE?ENABLE?RESUMABLE?command.B、?The?command?will?not?execute?successfully?because?resumable?space?allocation?is?enabled?at?the?session?level.C、?The?command?will?execute?successfully?and?resumable?space?will?be?allocated?at?the?session?level.D、?The?command?will?execute?successfully?and?resumable?space?will?be?allocated?at?the?instance?level.47.Given: Whatistheresult?（）A、81B、82C、91D、92E、Compilationfails.F、Anexceptionisthrownatruntime.48.Whendefiningafunctionactivity,whatistrueabouttheResultType?（）(Choosetwo.)A、ResultTypeisoptional.B、ResultTypeismandatory.C、ResultTypecanbechangedafteritisassignedtothefunctionactivity.D、ResultTypeshouldbelongtothesameitemtypeasthefunctionactivity49.Which?two?operations?can?be?flashed?back?using?the?Flashback?technology？?（）A、DROP?USER?SMITH；B、DROP?TABLE?EMPLOYEES；C、DROP?TABLESPACE?USERS；D、ALTER?TABLE?SALES_REP?DROP?PARTITION?P1；E、ALTER?TABLE?EMPLOYEES?DROP?COLUMN?DESIG_ID；50.Using?Oracle?Enterprise?Manager?to?set?SGA?pool?values?manually，?for?which?of?the?following?pools?does?Oracle?EM?offer?advice?to?set?the?value?appropriately？（）?A、?DB_CACHE_SIZEB、?SHARED_POOL_SIZEC、?LARGE_POOL_SIZED、?JAVA_POOL_SIZEE、?SGA_MAX_SIZEF、?SORT_AREA_SIZE51.寫出三種以上常用的數(shù)據(jù)類型。52.Examinethestatement: GRANTselect,insert,update ONstudent_grades TOmanager WITHGRANTOPTION; Whichtwoaretrue?（）A、MANAGERmustbearole.B、ItallowstheMANAGERtopassthespecifiedprivilegesontootherusers.C、ItallowstheMANAGERtocreatetablesthatrefertotheSTUDENT_GRADEStable.D、ItallowstheMANAGERtoapplyallDMLstatementsontheSTUDENT_GRADEStable.E、ItallowstheMANAGERtheabilitytoselectfrom,insertinto,andupdatetheSTUDENT_GRADEStable.F、ItallowstheMANAGERtheabilitytoselectfrom,deletefrom,andupdatetheSTUDENT_GRADEStable.53.Which?type?of?PL/SQL?construct?would?you?use?to?automatically?correct?the?error?resulting?from?a?statement?that?was?suspended?due?to?a?space-related?problem？（）A、?functionsB、?packageC、?procedureD、?database?triggerE、?anonymous?PL/SQL?block54.Whichsyntaxturnsanexistingconstrainton?（）A、ALTERTABLEtable_nameENABLEconstraint_name;B、ALTERTABLEtable_nameSTATUS=ENABLECONSTRAINTconstraint_name;C、ALTERTABLEtable_nameENABLECONSTRAINTconstraint_name;D、ALTERTABLEtable_nameTURNONCONSTRAINTconstraint_name;55.Whichtwostatementsaretrueaboutconstraints?（）A、TheUNIQUEconstraintdoesnotpermitanullvalueforthecolumn.B、AUNIQUEindexgetscreatedforcolumnswithPRIMARYKEYandUNIQUEconstraints.C、ThePRIMARYKEYandFOREIGNKEYconstraintscreateaUNIQUEindex.D、TheNOTNULLconstraintensuresthatnullvaluesarenotpermittedforthecolumn.56.比較非歸檔日志模式和歸檔日志模式的區(qū)別。57.You?issue?the?following?command?on?the?RMAN?prompt.?? RMAN>?REPORT?NEED?BACKUP?DAYS?=?5?DATABASE；?? Which?statement?is?true?about?executing?this?command？（）A、?It?will?display?a?list?of?files?that?need?incremental?backup.B、?It?will?display?a?list?of?files?that?need?backup?after?five?days.C、?It?will?display?a?list?of?files?that?were?backed?up?in?the?last?five?days.D、?It?will?display?a?list?of?files?that?have?not?been?backed?up?in?the?last?five?days.E、?It?will?apply?the?current?retention?policy?to?determine?the?files?that?need?to?be?backed?up.58.Which?statement?is?true?about?a?whole?consistent?database?backup?on?a?database?running?in?ARCHIVELOGmode（） 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?up59.觸發(fā)器事件和語句是SQL語句、數(shù)據(jù)庫事件、用戶事件，導(dǎo)致觸發(fā)器觸發(fā)。觸發(fā)器時(shí)機(jī)可以是（）。A、對(duì)特別表（視圖）的INSERT、UPDATE、DELETE語句B、對(duì)特定模式對(duì)象的CREATE、ALTER和DROP語句C、數(shù)據(jù)庫啟動(dòng)、實(shí)例關(guān)閉D、特定的錯(cuò)誤消息和任何錯(cuò)誤消息60.下列哪一個(gè)命令用來顯示RMAN通道的配置信息？（）A、LISTB、DISPLAYC、SHOWD、都可以61.在Oracle中，下述（）命令會(huì)使掛起的事務(wù)完成。A、COMMITB、DELETEC、UPDATED、SELECTE、INSERT62.Which?statement?is?true?regarding?the?COALESCE?function?（）A、It?can?have?a?maximum?of?five?expressions?in?a?list?B、It?returns?the?highest?NOT?NULL?value?in?the?list?for?all?rows?C、It?requires?that?all?expressions?in?the?list?must?be?of?the?same?data?type?D、It?requires?that?at?least?one?of?the?expressions?in?the?list?must?have?a?NOT?NULL?value63.Youhavealteredanon-uniqueindextobeinvisibletodetermineifqueriesexecutewithinanacceptableresponsetimewithoutusingthisindex. Whichtwoarepossibleiftableupdatesareperformedwhichaffecttheinvisibleindexcolumns?（）A、Theindexremainsinvisible.B、TheindexisnotupdatedbytheDMLstatementsontheindexedtable.C、TheindexautomaticallybecomesvisibleinordertohaveitupdatedbyDMLonthetable.