单项选择题
You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）
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
