Your database is running in the automatic Program Global Are

第1题：

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）

• A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
• B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
• C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
• D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

第2题：

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）

• A、by using the SQL access advisor
• B、by using the Automatic Workload Repository report
• C、by running the Automatic Database Diagnostic Monitor （ADDM）
• D、by using the Automatic Workload Repository Compare Period report
• E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

第3题：

第4题：

SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）

• A、The User Global Area （UGA） is not configured.
• B、The sessions were started using the login name SYS.
• C、The sessions are running in the Automatic Shared Memory Management mode.
• D、The sessions are running in the automatic Program Global Area （PGA） memory management mode.

第5题：

You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）

• A、 The database must be in the ARCHIVELOG mode.
• B、 The automatic memory tuning must be enabled.
• C、 The change tracking feature must be enabled.
• D、 The automatic memory tuning must be disabled.

第6题：

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（） 

• A、 The command restores only the missing control file.
• B、 The command restores all the control files.
• C、 The command fails because the database is running.
• D、 This is the correct way to address this problem.
• E、 This is not the correct way to address this problem.

第7题：

You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

• A、Memory Advisors
• B、Segment Advisors
• C、SQL Tuning and Access Advisors
• D、Automated Workload Repository （AWR）
• E、Automatic Database Diagnostic Monitor （ADDM）

第8题：

第9题：

Identify the memory component from which memory may be allocated for: （） 1: Session memory for the shared server  2: Buffers for I/O slaves  3: Oracle Database Recovery Manager (RMAN) backup and restore operations 

• A、Large Pool
• B、Redo Log Buffer
• C、Database Buffer Cache
• D、Program Global Area （PGA）

第10题：

You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（）

• A、 Advisor Central
• B、 Global Attributes
• C、 Resource Monitors
• D、 Memory Parameters
• E、 Database Usage Statistics
• F、 All Initialization Parameters
• G、 Automatic Workload Repository