单选题

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？（）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证