单项选择题

A.Library cache B.Row cacheC.Dictionary cache D.Large a……

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

单项选择题ouareimplementingcontrolfilemultiplexing.WhichofthefollowingchoicesidentifiesthemethodyoucanuseinordertogeneratethecontrolfilecopiesthatOraclewillmaintain?（）

A.Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
B.Make a copy of the control file with the database shut down
C.Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
D.Make a copy of the control file with the database still running

单项选择题YouareidentifyingdictionaryobjectsintheOracledatabase.Whichofthefollowingisaviewinthedatadictionary?（）

A.V$DATABASE
B.DBA_TABLES
C.SYSAUD$
D.EMP