（单选题）
View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）
AThe database instance is running with manual PGA management.
BThe database instance is running with manual shared memory management.
CThe database instance has the MEMORY_TARGET value set to a nonzero value.
DAll sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed
正确答案
答案解析
略
相似试题
（单选题）
Which view provides information on the backup status of the datafiles in the database?（）
（单选题）
Which view provides information on the backup status of the datafiles in the database？（）
（单选题）
Which statement regarding the contents of the V$PARAMETER view is true？（）
（单选题）
Which dynamic view displays the status of block-change tracking?（）
（单选题）
The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file？（）
（单选题）
To view the results of a manual SQL Tuning Advisor task， which steps should the DBA take？（）
（单选题）
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）
（多选题）
Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）
（单选题）
Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）
（单选题）
Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）
