You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）

单项选择题Inasituationwherenomultiplexingofredologstakesplace,whathappenswhenOraclecannotreaddatafromtheonlineredologgroupforarchiving?（）

A.Nothing happens
B.Oracle will automatically switch redo logs when detected 
C.Oracle eventually won't allow new records to be added to the database 
D.The instance crashes

单项选择题YouareanalyzinghowOracleprocessesuserstatements.SQLandPL SQLparseinformationisstoredinwhichofthefollowingdatabasememoryareas?（）

A.Library cache 
B.Row cache
C.Dictionary cache 
D.Large area 
E.Buffer cache

单项选择题Youaredesigningthephysicaldatabaselayoutonyourhostmachine.WhatistherelationshipbetweentablespacesanddatafilesintheOracledatabase?（）

A.One tablespace has only one datafile
B.Many tablespaces can share one datafile
C.One tablespace can have many datafiles
D.One datafile can contain many tablespaces

单项选择题Duringregulardatabaseoperation,whichbackgroundprocesswilltakesmallerblocksoffreespaceinadictionary-managedtablespaceandmovethingsaroundtomakebiggerpiecesoffreespace?（）

A.DBW0 
B.LGWR 
C.ARCH 
D.SMON 
E.PMON

单项选择题Youareconfiguringyourindextobestoredinatablespace.WhichofthefollowingstorageparametersareNOTappropriateforindexes?（）

A.OPTIMAL 
B.INITIAL 
C.PCTINCREASE 
D.NEXT