2024年Oracle認證筆試歷年真題薈萃含答案

2024年Oracle認證筆試歷年真題薈萃含答案（圖片大小可自由調(diào)整）第1卷一.參考題庫(共30題)1.YouneedtomodifytheSTUDENTStabletoaddaprimarykeyontheSTUDENT_IDcolumn.Thetableiscurrentlyempty.Whichstatementaccomplishesthistask?（）A、ALTERTABLEstudentsADDPRIMARYKEYstudent_id;B、ALTERTABLEstudentsADDCONSTRAINTPRIMARYKEY(student_id);C、ALTERTABLEstudentsADDCONSTRAINTstud_id_pkPRIMARYKEY(student_id);D、ALTERTABLEstudentsMODIFYCONSTRAINTstud_id_pkPRIMARYKEY(student_id);2.Your?database?is?configured?in?NOARCHIVELOG?mode.?All?the?control?files?have?been?lost?due?to?a?hard?disk?failure?but?the?data?files?are?not?lost.?You?have?the?closed?whole?database?backup?available?to?you.? Which?two?statements?are?true?in?this?scenario？（）A、The?instance?aborts.B、The?database?cannot?be?recovered.C、The?database?can?be?recovered?by?restoring?the?control?files?from?the?backup.D、The?database?remains?opened?and?you?have?to?shut?it?down?with?the?ABORT?option.E、The?database?can?be?restored?till?the?point?of?the?last?closed?whole?database?backup.3.WhichareDMLstatements?（）A、COMMITB、MERGEC、UPDATED、DELETEE、CREATEF、DROP4.Whichtwostatementsaretrueaboutajobchain?（）(Choosetwo.)A、Ajobchaincancontainanestedchainofjobs.B、Thejobsinajobchaincannothavemorethanonedependency.C、AjoboftheCHAINtypecanberunusingevent-basedortime-basedschedules.D、ThejobsinajobchaincanbeexecutedonlybyusingtheeventsgeneratedbytheScheduler5.AgeneralpurposeMySQLinstanceisconfiguredwiththefollowingoptions: —log-slow-queries —long-query-time=,0001 —log-slow-admin-queries —general-log —log-bin —binlog-format=STATEMENT —innodb-flush-log-at-trx-commit=1 Whichthreestatementsaretrue（）。A、TheGeneralQueryLogrecordsmoredatathantheBinaryLogB、ThebinaryLogrecordsmoredatathantheGeneralQueryLogC、TheSlowQueryLogrecordsmoredatathantheGeneralQueryLogD、TheGeneralQueryLogrecordsmoredatathantheSlowQueryLogE、TheSlowQueryLogrecordsmoredatathantheBinaryLogF、TheBinaryLogrecordsmoredatathantheSlowQueryLog6.In?your?test?database，?you?have?created?the?ORDERS?table?as?an?index-organized?table?（IOT）.?To?facilitate?faster?querying，?you?have?created?a?mapping?table?and?a?bitmap?index?on?the?ORDER_FILLED?column.?You?observe?that?the?query?performance?degrees?when?users?perform?a?large?volume?of?transactions.?While?investigating?the?reason，?you?find?that?the?mapping?table?segment?is?fragmented，?leading?to?poor?performance.?Which?option?would?you?use?to?defragment?the?mapping?table?without?affecting?the?original?table?data？（）A、?Export?and?import?the?mapping?table.B、?Drop?and?re-create?the?mapping?table.C、?Truncate?the?mapping?table?and?reinsert?the?values.D、?Use?the?ALTER?TABLE?..?REBUILD?command?to?defragment?the?mapping?table.7.Which?three?statements?are?true?regarding?the?data?types?in?Oracle?Database?10g/11g?（）A、Only?one?LONG?column?can?be?used?per?table?B、A?TIMESTAMP?data?type?column?stores?only?time?values?with?fractional?seconds?C、The?BLOB?data?type?column?is?used?to?store?binary?data?in?an?operating?system?file?D、The?minimum?column?width?that?can?be?specified?for?a?VARCHAR2?data?type?column?is?one?E、The?value?for?a?CHAR?data?type?column?is?blank-padded?to?the?maximum?defined?column?width8.ExaminethedescriptionoftheSTUDENTStable: STD_IDNUMBER(4) COURSE_IDVARCHARD2(10) START_DATEDATE END_DATEDATE WhichtwoaggregatefunctionsarevalidontheSTART_DATEcolumn?（）A、SUM(start_date)B、AVG(start_date)C、COUNT(start_date)D、AVG(start_date,end_date)E、MIN(start_date)F、MAXIMUM(start_date)9.Which?three?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?database.10.You?are?maintaining?the?SALES?database?on?Oracle?10g.?You?have?added?a?new?disk?to?a?disk?group.?Automatic?Storage?Management?performs?the?rebalancing?activity.?You?want?to?speed?up?the?rebalancing?activity.?Which?parameter?will?you?specify?to?control?the?speed?of?the?rebalancing?activity？?（）?A、?ASM_POWER_LIMITB、?ASM_DISKSTRINGC、?ASM_DISKGROUPSD、?LARGE_POOL_SIZE11.Why?does?performance?degrade?when?many?UPDATE，?INSERT，?or?DELETE?statements?are?issued?on?a?tablethat?has?an?associated?Bitmap?index（）A、The?DML?operations?re-create?the?Bitmap?index?blocks.B、The?Bitmap?index?is?rebuilt?automatically?after?a?DML?operation.C、The?smallest?amount?of?a?bitmap?that?can?be?locked?is?a?bitmap?segment.D、Additional?time?is?taken?to?remove?NULL?values?from?the?Bitmap?index?after?a?DML?operation.12.Which?two?commands?never?trigger?an?implicit?rebalancing?within?the?disk?group？（）?A、?ALTER?DISKGROUP?misc?MOUNTB、?ALTER?DISKGROUP?misc?DROP?DISK?misc2C、?ALTER?DISKGROUP?misc?CHECK?ALL?NOREPAIRD、?ALTER?DISKGROUP?misc?RESIZE?ALL?SIZE?1023mE、?ALTER?DISKGROUP?dgroupA?ADD?DISK?’/devices/A*’13.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.14.Which?statement?is?true?regarding?subqueries?（）A、The?LIKE?operator?cannot?be?used?with?single-row?subqueries?B、The?NOT?IN?operator?is?equivalent?to?IS?NULL?with?single-row?subqueries?C、=ANY?and?=ALL?operators?have?the?same?functionality?in?multiple-row?subqueries?D、The?NOT?operator?can?be?used?with?IN,?ANY,?and?ALL?operators?in?multiple-row?subqueries?15.在數(shù)據(jù)庫啟動后，用戶權(quán)限、數(shù)據(jù)庫對象的定義等信息，被存放在下列哪個區(qū)域（）A、庫緩沖區(qū)B、數(shù)據(jù)字典緩沖區(qū)C、數(shù)據(jù)緩沖區(qū)D、重做日志緩沖區(qū)16.Whichconstraintcanbedefinedonlyatthecolumnlevel?（）A、UNIQUEB、NOTNULLC、CHECKD、PRIMARYKEYE、FOREIGNKEY17.Which?are?SRW?package?procedure?or?function?could?you?use?to?create?and?then?drop?a?temporary?table?in?the?sales?report?（）A、SRW.BREAK?B、SRW.SET_ALTER?C、SRW.REFERENCE?D、SRW.DO_SQL?E、SRW.RUN_REPORTF、SRW.SET_FIELD18.WhattwoaretheprerequisitesforenablingFlashbackDatabase?（）A、ThedatabasemustbeinARCHIVELOGmodeB、ThedatabasemustbeinMOUNTEXCLUSIVEmodeC、ThedatabasemustbeopenedinRESTRICTEDmodeD、ThedatabaseinstancemustbestartedintheNOMOUNTstateE、Thedatabaseinstancemusthavethekeepbufferpooldefined19.Yourmultitenantcontainerdatabase(CDB)containsthreepluggabledatabase(PDBs).Youfindthatthecontrolfileisdamaged.YouplantouseRMANtorecoverthecontrolfile.TherearenostartuptriggersassociatedwiththePDBs. Whichthreestepsshouldyouperformtorecoverthecontrolfileandmakethedatabasefullyoperational?（）A、Mountthecontainerdatabase(CDB)andrestorethecontrolfilefromthecontrolfileautobackup.B、RecoverandopentheCDBinNORMALmode.C、MounttheCDBandthenrecoverandopenthedatabase,withtheRESETLOGSoption.D、Openallthepluggabledatabases.E、Recovereachpluggabledatabase.F、Startthedatabaseinstanceinthenomountstageandrestorethecontrolfilefromcontrolfileautobackup.20.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.21.Given： What?is?the?result？（）A、?An?exception?is?thrown?at?runtime.B、?int?LongC、?Compilation?fails.D、?Short?Long22.在PL/SQL環(huán)境中，以下說法正確的是（）A、字符串是用單引號加以界定的B、字符串是用雙引號加以界定的C、對于單行注釋可以用雙斜線//開始D、多行注釋是以大括號{}加以界定的E、每條語句以句點。做為結(jié)束符23.ExaminethestructureoftheEMPLOYEEStable: ColumnnameDatatypeRemarks EMPLOYEE_IDNUMBERNOTNULL,PrimaryKey LAST_NAMEVARCNAR2(30) FIRST_NAMEVARCNAR2(30) JOB_IDNUMBER SALNUMBER MGR_IDNUMBERReferencesEMPLOYEE_IDcolumn DEPARTMENT_IDNUMBER YouneedtocreateanindexcalledNAME_IDXonthefirstnameandlastnamefieldsoftheEMPLOYEEStable.WhichSQLstatementwouldyouusetoperformthistask?（）A、CREATEINDEXNAME_IDX(first_name,last_name);B、CREATEINDEXNAME_IDX(first_name,ANDlast_name)C、CREATEINDEXNAME_IDXON(First_name,last_name);D、CREATEINDEXNAME_IDXONemployees(First_name,ANDlast_name);E、CREATEINDEXNAME_IDXONemployees(First_name,last_name);F、CREATEINDEXNAME_IDXFORemployees(First_name,last_name);24.If?you?issue?the?command?shutdown?abort?prior?to?trying?to?put?the?database?in?ARCHIVELOG?mode，?what?will?be?the?result?when?you?issue?the?command?alter?database?archivelog？（）??A、?The?alter?database?archivelog?command?will?failB、?The?alter?database?archivelog?inconsistent?command?must?be?used?to?put?the?database?in?ARCHIVELOG?modeC、?The?alter?database?archivelog?command?will?succeedD、?The?alter?database?archivelog?command?will?ask?if?you?want?to?make?the?database?consistent?firstE、?There?is?no?alter?database?archivelog?command.?The?correct?command?is?alter?database?alterlogging25.AdatabaseisrunninginARCHIVELOGmodeandregularbackupsareperformed.Auserreceivesthefollowingerrormessage: Whichistherecommendedsequenceofoperationsyouneedtoperformforthequerysuccessfully?（）A、Droptheaffectedtablespace,re-createthetablespace,restorethedatafiles,andthetablespace.B、Taketheaffecteddatafileoffline(ifnotalreadyoffline),restorethedamagedimageofthedatafile,andthenbringitonline.C、RestartthedatabaseinMOUNTmode,restorethedamageddatafile,recoverthedatafileandthenopenthedatabasewithresetlogs.D、PutthedatabaseinRESTRICTEDmode,restoreallthedatafilesintheaffecteddatafileandrecoverthetablespace,andthenputthedatabaseinnormaloperationalmode.26.How?are?messages?displayed?when?you?use?the?SRW.MESSAGE?packaged?procedure??（）A、Dialogue?box?that?implicitly?determines?report?execution.?B、Message?line?that?implicitly?determines?report?execution.?C、Message?line?that?suppresses?the?default?oracle?message.?D、Dialogue?box?that?does?not?terminate?report?execution.?E、Dialogue?box?that?suppresses?the?default?oracle?message.27.You?installed?Oracle?Database?11g?afresh.?Which?statements?are?true?regarding?the?default?audit?settings?in?this?database？（）?A、?The?audit?trail?is?stored?in?an?operating?system?file.B、?Auditing?is?disabled?for?all?privileges.C、?The?audit?trail?is?stored?in?the?database.D、?Auditing?is?enabled?for?all?privileges.E、?Auditing?is?enabled?for?certain?privileges?related?to?database?security.28.Which?commands?are?used?for?RMAN?database?recovery？（）A、?restoreB、?repairC、?copyD、?recoverE、?replace29.Which?view?provides?information?on?the?backup?status?of?the?datafiles?in?the?database?（）A、V$BACKUPB、V$BACKUP_STATUS?C、V$BACKUP_DATAFILE?D、V$DATAFILE_BACKUP?E、V$TABLESPCE_BACKUP30.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、E第1卷參考答案一.參考題庫1.參考答案:C2.參考答案:A,E3.參考答案:B,C,D4.參考答案:A,C5.參考答案:A,D,E6.參考答案:B7.參考答案:A,D,E8.參考答案:C,E9.參考答案:A,B,D10.參考答案:A11.參考答案:C12.參考答案:A,C13.參考答案:A,D14.參考答案:D15.參考答案:B16.參考答案:B17.參考答案:D18.參考答案:A,B19.參考答案:C,D,F20.參考答案:A21.參考答案:B22.參考答案:A23.參考答案:E24.參考答案:A25.參考答案:C26.參考答案:D27.參考答案:C,E28.參考答案:A,D29.參考答案:A30.參考答案:C第2卷一.參考題庫(共30題)1.Given?the?script?? create?script?db_backup_datafile_script? {backup?datafile?and?1，?and2?plus?archivelog?delete?input；} Run?{execute?script?db_backup_datafile_script?using?2；}?? What?is?the?result?of?running?this?command？（）?? A、?The?script?will?fail?since?you?instructed?RMAN?to?back?up?only?one?datafile?rather?than?twoB、?The?script?will?successfully?back?up?datafile?3?without?errorC、?The?script?will?fail?since?it?uses?a?substitution?variable?which?is?not?supportedD、?The?execute?script?command?will?prompt?for?the?value?of?and2?since?it’s?not?included?in?the?commandE、?The?script?will?fail?because?you?cannot?use?the?plus?archivelog?command?when?backing?up2.MaryhasaviewcalledEMP_DEPT_LOC_VUthatwascreatedbasedontheEMPLOYEES,DEPARTMENTS,andLOCATIONStables.ShegrantedSELECTprivilegetoScottonthisview. WhichoptionenablesScotttoeliminatetheneedtoqualifytheviewwiththenameMARY.EMP_DEP_LOC_VUeachtimetheviewisreferenced?（）A、ScottcancreateasynonymfortheEMP_DEPT_LOC_VUbususingthecommand:

CREATEPRIVATESYNONYMEDL_VU

FORmary.EMPDEPT_LOC_VU;

thenhecanprefixthecolumnswiththissynonymn.B、ScottcancreateasynonymfortheEMP_DEPT_LOC_VUbyusingthecommand:

CREATESYNONYMEDL_VU

FORmary.EMP_DEPT_LOC_VU;

thenhecanprefixthecolumnswiththissynonym.C、ScottcancreateasynonymfortheEMP_DEPT_LOC_VUbyusingthecommand:

CREATELOCALSYNONYMEDL_VU

FORmary.EMPDEPT_LOC_VU;

thenhecanprefixthecolumnswiththissynonym.D、ScottcancreateasynonymfortheEMP_DEPT_LOC_VUbyusingthecommand:

CREATESYNONYMEDL_VU

ONmary(EMP_DEPT_LOC_VU);

thenhecanprefixthecolumnswiththissynonym.E、Scottcannotcreateasynonymbecausesynonymscanbecreatedonlyfortables.F、ScottcannotcreateanysynonymforMary’sview.MaryshouldcreateaprivateynonymfortheviewandgrantSELECTprivilegeonthatsynonymtoScott.3.比較非歸檔日志模式和歸檔日志模式的區(qū)別。4.You?are?managing?an?Oracle?Database?11g?ASM?instance?with?a?disk?group?dg01?having?three?disks.?One?of?the?disks?in?the?disk?group?becomes?unavailable?because?of?power?failure.?You?issued?the?following?command?to?change?the?DISK_REPAIR_TIME?attribute?from?3.6?hours?to?5?hours：?? ALTER?DISKGROUP?dg01?SET?ATTRIBUTE?’disk_repair_time’?=?’5h’；?? To?which?disks?in?the?disk?group?will?the?new?value?be?applicable？（）A、?all?disks?in?the?disk?groupB、?all?disks?that?are?currently?in?OFFLINE?modeC、?all?disks?that?are?not?currently?in?OFFLINE?modeD、?all?disks?in?the?disk?group?only?if?all?of?them?are?ONLINE5.Which?script?must?you?to?query?to?display?the?code?associated?with?RMAN?stored?scripts？（）A、RC_STORED_SCRIPTB、RC_STORED_SCRIPT_LINEC、RC_SCRIPTSD、RC_STORED_LINE_SCRIPTE、None?of?the?other?alternatives?apply6.You?have?two?database?servers?SEMP?and?SACCT.?The?database?in?the?SEMP?server?maintains?the?employeeinformation?and?the?database?in?the?SACCT?server?maintains?the?accounts?payable?information.?The?employeessubmit?the?expense?reports?to?the?accounts?payable?department.?A?user?of?the?accounts?payable?databasewants?to?extract?the?employee?information?from?the?database?in?the?SEMP?server?for?cross-verification.? Whichschema?object?enables?the?user?to?access?the?information?from?the?remote?database（）A、ClusterB、Database?linkC、Mapping?tableD、Materialized?view7.WhichthreestatementsaretrueaboutadaptiveSQLplanmanagement?（）A、Itautomaticallyperformsverificationorevolvesnon-acceptedplans,inCOMPREHENSIVEmodewhentheyperformbetterthanexistingacceptedplans.B、Theoptimizeralwaysusesthefixedplan,ifthefixedplanexistsintheplanbaseline.C、Itaddsnew,bettorplansautomaticallyasfixedplanstothebaseline.D、Thenon-acceptedplansareautomaticallyacceptedandbecomeusablebytheoptimizeriftheyperformbetterthantheexistingacceptedplans.E、Thenon-acceptedplansinaSQLplanbaselineareautomaticallyevolved,inCOMPREHENSIVEmode,duringthenightlymaintenancewindowandapersistentverificationreportisgenerated.8.You?have?issued?the?following?command：?? ?RMAN>CONFIGURE?RETENTION?POLICY?TO?RECOVERY?WINDOW?OF?100?DAYS；?? What?will?be?the?result?of?using?the?above?command？（）A、?The?backup?metadata?will?be?maintained?in?the?control?file?for?100?days.B、?The?backup?metadata?will?be?maintained?in?the?recovery?catalog?for?100?days.C、?The?backup?metadata?will?be?maintained?in?the?flash?recovery?area?for?100?days.D、?After?100?days，?the?backup?sets?and?image?copies?will?be?deleted?from?the?media.9.You?are?trying?to?determine?how?many?disk?sorts?are?happening?on?the?database?right?now.?Which?of?the?following?dictionary?tables?would?you?use?to?find?that?information?（）A、V$SESSION?B、V$SYSSTAT?C、DBA_SEGMENTS?D、V$SORT_USAGE10.Examine?the?following?values?of?the?initialization?parameters?in?the?database?having?the?SID?ORCL：?? BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump?USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump?CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump?DIAGNOSTIC_DEST=?? The?environment?variables?have?the?following?value：?? ORACLE_BASE=/u01/app/oracle? ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1?? What?is?the?location?of?the?Automatic?Diagnostic?Repository?（ADR）?home？（）A、?/u01/app/oracle/product/11.1.0/db_1B、?/u01/app/oracleC、?$ORACLE_HOME/bdumpD、?$ORACLE_HOME/log11.YouhavethreetemporarytablespacegroupsnamedG1,G2,andG3inyourdatabase.Youarecreatinganewtemporarytablespaceasfollows: CREATETEMPORARYTABLESPACETEMP1TEMPFILE'/u1/data/temp1.dbf'SIZE10M TABLESPACEGROUP''; Whichstatementregardingtheabovecommandiscorrect?（）A、ItwillcreatethetablespaceTEMP1ingroupG1.B、ItwillcreatethetablespaceTEMP1ingroupG3.C、ItwillnotaddthetablespaceTEMP1toanygroup.D、ItwillcreatethetablespaceTEMP1inthedefaultgroup.12.Identify?three?advantages?of?Active?GridLink?for?RAC?over?multidata?source.（）A、isolates?WebLogic?from?RAC?changesB、has?a?simple?configurationC、enables?statement?caching??D、performs?faster?failure?detection?and?failoverE、is?supported?in?WebLogic?Domain?Templates13.ClicktheExhibitbuttonandexaminethedataintheEMPLOYEEStable. Whichthreesubquerieswork?（） A、SELECT*FROMemployeeswheresalary>(SELECTMIN(salary)FROMemployeesGROUPBYdepartment_id);B、SELECT*FROMemployeesWHEREsalary=(SELECTAVG(salary)FROMemployeesGROUPBYdepartment_id);C、SELECTdistinctdepartment_idFROMemployeesWHEREsalary>ANY(SELECTAVG(salary)FROMemployeesGROUPBYdepartment_id);D、SELECTdepartment_idFROMemployeesWHEREsalary>ALL(SELECTAVG(salary)FROMemployeesGROUPBYdepartment_id);E、SELECTlast_nameFROMemployeesWHEREsalary>ANY(SELECTMAX(salary)FROMemployeesGROUPBYdepartment_id);F、SELECTdepartment_idFROMemployeesWHEREsalary>ALL(SELECTAVG(salary)FROMemployeesGROUPBYAVG(SALARY));14.Given: Whichcode,insertedatline14,allowstheSpriteclasstocompile?（）A、Directiond=NORTH;B、Nav.Directiond=NORTH;C、Directiond=Direction.NORTH;D、Nav.Directiond=Nav.Direction.NORTH;15.Given: Whatistheresultwhenthego（）methodisinvoked?（）A、00B、0001C、000120D、00012021E、Compilationfails.F、Anexceptionisthrownatruntime.16.DRAGDROPClicktheTaskbutton. 17.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_DATE18.Considerthequery: Mysql＞SET@run=15; Mysql＞EXPLAINSELECTobjective,stage,COUNT(stage) FROMiteminformation WHERErun=@runANDobjective=’7.1’ GROUPBYobjective,stage ORDERBYstage; Theiteminformationtablehasthefollowingindexes; Mysql＞SHOWINDEXESFROMiteminformation: ThisqueryisrunseveraltimesinanapplicationwithdifferentvaluesintheWHEREclauseinagrowingdataset. Whatistheprimaryimprovementthatcanbemadeforthisscenario?（）A、DonotpassauservariableintheWHEREclausebecauseitlimitstheabilityoftheoptimizertouseindexesB、AddanindexontheobjectivecolumnsothatiscanbeusedinboththeWHEREandGROUPBYoperationsC、Droptherun_2indexbecauseithascausedaconflictinthechoiceofkeyforthisqueryD、Executetherun_2indexbecauseithascausedaconflictinthechoiceofkeyforthisqueryE、Addacompositeindexon(run,objective,stage)toallowthequerytofullyutilizeanindex19.Identify?two?situations?in?which?the?block?header?grows?in?a?data?block.?（）A、when?row?directories?need?more?row?entriesB、when?there?is?row?migration?in?the?data?blockC、when?there?is?an?increase?in?the?PCTFREE?value?for?the?data?blockD、when?more?transaction?slots?are?required?than?are?initially?configured20.You?have?written?a?custom?menu?for?a?Forms?application.?You?saved?the?menu?module?to?the?file?custmenu.mmb.?In?the?Property?Palette?for?the?form,?you?set?the?Menu?Module?property?to?custmenu.?When?you?run?the?form,?the?custom?menu?does?not?appear.?What?can?you?do?to?fix?this?problem?（）A、Generate?the?menu?module?executable.?B、Save?the?menu?module?as?custmenu.mmx.?C、In?the?Property?Sheet?for?the?form,?set?the?Starting?Menu?property?to?custmenu.?D、In?the?Property?Sheet?for?the?form,?set?the?Menu?Module?property?to?custmenu.mmb.21.WhatdoestheDB_FLASHBACK_RETENTION_TARGETparameterconfigure?（）A、Anupperlimitonhowfaryoucanflashbackthedatabase,dependingontheinformationintheredologsB、Anupperlimitonhowfaryoucanflashbackthedatabase,dependingontheinformationintheundotablespaceC、Theamountoftimeforwhichtheflashbackdataistobekeptintheflashrecoveryarea,providedthatthereisenoughspaceD、Theamountoftimeforwhichtheflashbackdataisguaranteedtobekeptintheundotablespace,providedthatthereisenoughspace22.You?performed?the?RMAN?database?backup?having?a?backupset?key?number?231?with?the?KEEP?FOREVER?option.? After?some?days，?you?want?to?change?the?status?of?the?database?backup?and?you?issued?the?following?command：?? RMAN>CHANGE?BACKUPSET?231?NOKEEP；?? What?is?the?implication?of?this?command？（）A、?The?backup?is?deleted.B、?The?backup?is?marked?unavailable.C、?The?backup?overrides?the?backup?retention?policy.D、?the?backup?becomes?eligible?for?deletion?according?to?the?existing?retention?policy.23.You?observe?that?the?senior?database?administrator?always?uses?the?following?command?when?connecting?to?Recovery?Manager?（RMAN），?and?then?starts?executing?commands?to?backup?the?database?files：? $?rman?target?/? What?would?be?the?effect?of?this?command？（）A、RMAN?would?use?the?current?operating?system?location?to?place?the?backup.B、RMAN?would?use?the?control?file?of?the?target?database?to?maintain?the?backup.C、RMAN?would?use?the?recovery?catalog?of?the?target?database?to?maintain?the?backup.D、RMAN?would?use?the?control?file?of?the?target?database?to?maintain?the?backup?metadata.?E、RMAN?would?use?the?recovery?catalog?of?the?target?database?to?maintain?the?backup?metadata.24.During?the?installation?of?Oracle?Database?11g，you?do?not?set?ORACLE_BASE?explicitly.?You?selected?the?option?to?create?a?database?as?part?of?the?installation.? How?would?this?environment?variable?setting?affect?the?installation？（）??A、?The?installation?terminates?with?an?error.B、?The?installation?proceeds?with?the?default?value?without?warnings?and?errors.C、?The?installation?proceeds?with?the?default?value?but?it?would?not?be?an?OFA-compliant?database.D、?The?installation?proceeds?with?the?default?value?but?a?message?would?be?generated?in?the?alert?log?file.25.Evaluate?the?following?SQL?statement?used?to?create?the?PRODUCTS?table：?? CREATE?TABLE?products?（product_id?NUMBER（3）?PRIMARY?KEY，?product_desc?VARCHAR2（25），?qtyNUMBER（8，2），?rate?NUMBER（10，