单选题

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario（　）

AThe minimum memory size for the database buffer cache is set to 100 mb.

BThe maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100mb

CThe minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.

DThe maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb

正确答案

答案解析

略

相似试题

Which two are regarding automatic space management segments？（）
多选题查看答案
What is true regarding a transaction executed in Automatic Undo Management mode？（）
单选题查看答案
You execute the following command to start an Automatic Storage Management （ASM） instance： SQL>STARTUP； In which of the following modes will the ASM instance start？（）
单选题查看答案
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement is true about the analysis of the Automatic Database Diagnostic Monitor （ADDM）？（）
单选题查看答案
You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log？（）
单选题查看答案
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？（）
多选题查看答案
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）
单选题查看答案
You issued the following statement in your SQL*Plus session： SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）
单选题查看答案
Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）
单选题查看答案
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证

正确答案

答案解析