下列关于存本取息个人定期存款方式的说法，错误的有()。

to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.Which statement is true if the SQL query in exhibit1 is executed again when the valueof OPTIMIZER_MODE is set to FIRST_ROWS?（）

A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.

B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.

C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.

D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.

forthedatabase.Torepairthefailure，youexecutedthefollowingcommandasthefirstRMANcommand：RMAN>REPAIRFAILURE；Whichstatementdescribestheconsequenceofthiscommand（）

A.Thecommandperformstherecoveryandclosesthefailure.

B.ThecommandonlydisplaystheadviceandtheRMANscriptrequiredforrecovery.

C.ThecommandexecutestheRMANscripttorepairthefailureandremovetheentryfromtheAutomaticDiagnosticRepository（ADR）.

D.ThecommandproducesanerrorbecausetheADVISEFAILUREcommandwasnotexecutedbeforethe REPAIRFAILUREcommand

abasehasbeenconfiguredwiththreeredologsgroups，andtherehavebeenfivelogswitches.Youlostonenon-system-criticaldatafilefromyourdatabase.Whichmethodwouldyouusetorecoverthedatafile？（）

A.Restoreallthedatafilesandopenthedatabase

B.Createthedatafileandperformtablespacerecovery

C.Noneedtorestoreanyfile，justrecoverthedatabase

D.Restoreonlythesystemdatafileandrecoverthedatabase

E.Restoreonlylostdatefileandperformtablespacerecovery

lowinginitializationparametervalues：

SGA_TARGET=2G

DB_8K_CACHE_SIZE=128M

YoucreateatablespacenamedHRwiththenon-standardblocksizeof8K.FourdatabaseusersarerunningqueriesonatableintheHRtablespace.Theseuserscomplainthatthequeriesaretakinglongerthanusualtocomplete.Whileinvestigatingthereasonsforthisdelay，youdiscoverthatthedatabaseencountersextensivecachemissesonthedatabasebuffercachewiththeblocksizeof8K.YouissuethefollowingstatementtoincreasethevalueoftheDB_8K_CACHE_SIZEinitializationparameterto256M：

SQL>ALTERSYSTEMSETDB_8K_CACHE_SIZE=256MSCOPE=BOTH；

Whatistheresultofthisstatement？（）

A.Thedatabaseisinmountstate.

B.Oneofthetablespacesisoffline.

C.Oneofthetablespacesisreadonly.

D.ThedatabaseoperatesinARCHIEVELOGmode.

E.ThedatabaseoperatesinNOARCHIEVELOGmode.

YourecentlycreatedadatabaseandconfiguredtheSPFILEwiththefollowingparametersettingstoensurethatOracleautomaticallyadjuststhememoryfortheProgramGlobalArea（PGA）：

SORT_AREA_SIZE=150M

HASH_AREA_SIZE=150M

BITMAP_MERGE_AREA_SIZE=150M

CREATE_BITMAP_AREA_SIZE=150M

WORKAREA_SIZE_POLICY=AUTO

YouhavenotincludedthePGA_AGGREGATE_TARGETinitializationparameterintheSPFILEandtheSystemGlobalArea（SGA）iscurrentlysizedat4G.

WhatisthetotalPGAmemoryallocatedacrossalldatabaseserverprocesses？（）

Examinethefollowingoutput：SQL>SELECTindex_name，statusFROMdba_indexesWHEREstatus=’UNUSABLE’；INDEX_NAMESTATUS-----------------------------------------EINDUNUSABLEWhichtwostatementsabouttheaboveindexaretrue（）

A.Itisignoredbythequeryoptimizer.

B.Itisnotusedwhiletheindexisbeingrebuilt.

C.Theindexcannotberebuilt，andhastobere-created.

D.Theindexisautomaticallyrebuiltwhenusedthenexttime

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in descending order by default.

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

Yourecentlyaddedathird-partyapplicationtoyourdatabaseanddonothaveaccesstotheSQLcodeofthisapplication.Databaseusersarecomplainingofperformance-relatedissues，suchasincreasedtimerequiredtocompleteaquery.Whileinvestigating，youdiscoverfromtheSTATSPACKutilitythatsomeofthememorystructureshavelowhitratios.YouplantoresizesomeofthememorystructuresbyusingtheMemoryAdvisor.ForwhichmemorystructurewillyoufailtoobtainoptimalsettingsbyusingtheMemoryAdvisor？（）

A.Binary backups are usually faster than text backups

B.Binary backups are usually slower than text backups

C.Text backups are human-readable while binary backups are not

D.Binary backups are not portable across different operating systems