有人把产能过剩比喻为“悬在行业头顶上的堰塞湖”，这既表达了对过剩问题的担心，也说明治理过剩已__

A.Tea

B.Coffee

C.CoffeeTea

D.Compilationfails

A.ManagedServer

B.WebServer

C.AdministrationServer

D.NodeServer

A.LargePool

B.RedoLogBuffer

C.DatabaseBufferCache

D.ProgramGlobalArea（PGA）

with SYSDBA privilege.The CDB has several pluggable databases (PDBs) open in the read/write mode.There are ongoing transactions in both the CDB and PDBs.What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）

A. The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.

B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.

D. The statement results in an error because there are open PDBs.

iumsbeloweredfordriverswithagooddrivinghistory.Becausethiscouldpotentiallyaffectalargenumberofrecords,youwanttobasethedatablockonastoredprocedurereturningatableofrecords.Whichstatementsupportsthisapproach?（）

A.Atableofrecordsisefficientintermsofnetworktraffic.

B.Atableofrecordsimprovesdeveloperproductivitybecausethedatabaseadministratordoesnothavetocreateaserversideview.

C.AtableofrecordsisefficientbecausethenumberofrecordsfetcheddependsontheArrayFetchpropertyvalue.

D.YourcodingeffortissimplifiedsinceDMLoperationsarehandlesbysettingformmoduleproperties.

ST_NAMEcolumnoftheCUSTOMERStable：ALTERTABLEcustomersMODIFY（cust_nameVARCHAR2（40））/Whenyouexecutethecommand，itdisplaysthefollowingerrormessage：ERRORatline1：ORA-00054：resourcebusyandacquirewithNOWAITspecifiedWhatcouldbethereasonfortheerrormessage？（）

A.Thedatabaseinstanceisnotavailable.

B.TheALTERTABLEcommanddoesnothaveWAIToption

C.Thetableorarowinthetableiscurrentlylockedbyanotherusersession.

D.Thedatabaseinstanceisbusyprocessingotherusersessionscommands.

E.TheCUSTOMERStablehasnolongrunningqueryactiveatthetimewhenthisrequestismade.

F.TheserverprocessexecutingtheALTERTABLEcommandisbusywithanothercommandexecution

A.CoherenceusesamoreefficientTCMPalgorithmgoingfromtwotofourcacheservers

B.Whengoingfromonetotwocacheservers，objectbackupsarecopiedacrossserverssoworkisdoubled，butgoingfromtwotofourisafixedamountofwork

C.Nearcacheisenabledwithalargerquorumthusperformanceisimproved

D.alloftheabove

ouareusingtheflashrecoveryarea（fastrecoveryareain11gRelease2）tostorebackuprelatedfilesinyourdatabase.AfterregularmonitoringofspaceusageintheMashrecoveryarea.Yourealizethattheflashrecoveryareais（jettingfilledupveryfastanditisrunningoutofspace.Yourdatabaseflashrecoveryareaislowonspecieandyouhavenomoreroomondisk.Proactively，whichtwooptionscouldyouusetomakemorespaceavailableintheflashrecovery（）

A.ChangetheRMANarchivedlogdeletionpolicy.

B.UsetheRMANCROSSCHECKcommandtoreclaimthearchivedlogspace.

C.ChangetheRMANretentionpolicytoretainbackupsforashorterperiodoftime.

D.UseOScommandtomovefilesfromtheflashrecoveryareatosomeotherlocation.

blocks are getting aged out of the default buffer cache.How would you guarantee that the blocks for the table never age out?（）

A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.

B. Increase the database buffer cache size.

C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.

D. Configure Automata Shared Memory Management.

E. Configure Automatic Memory Management

A.SHOW_WINDOW

B.RESIZE_WINDOW

C.DISPLAY_WINDOW

D.MOVE_WINDOW_X_Y

E.WINDOW_VISIBLE_X_Y