单项选择题

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

点击查看答案

上一题目录下一题

相关考题

单项选择题

You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

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

单项选择题

During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）

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

单项选择题

You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）

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