违法和不良信息举报 联系客服
免费注册 登录

Note the following parameters settings in your database: SGA

题目
单选题
Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）
A

It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically

B

It will be successful only if the memory is available from the auto tuned components

C

It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET

D

It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=0PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）

A. LOG_BUFFER

B. SORT_AREA_SIZE

C. JAVA_POOL_SIZE

D. STREAMS_POOL_SIZE

E. DB_16K_CACHE_SZIE

F. DB_KEEP_CACHE_SIZE


参考答案：A, E, F

第2题：

To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.（）

  • A、The PGA_AGGREGATE_TARGET parameter is set to zero.
  • B、The STATISTICS_LEVEL parameter is setto basic.
  • C、Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
  • D、The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.

正确答案:B

第3题：

You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()

A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB

B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually

C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero

D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively


参考答案：A, D

第4题：

To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）

  • A、 DB_CACHE_SIZE
  • B、 SHARED_POOL_SIZE
  • C、 LARGE_POOL_SIZE
  • D、 JAVA_POOL_SIZE
  • E、 SGA_MAX_SIZE
  • F、 SORT_AREA_SIZE

正确答案:A,B,C,D

第5题：

You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）

  • A、LOGICAL_READS_PER_SESSION 
  • B、CONNECT_TIME 
  • C、COMPOSITE_LIMIT 
  • D、CPU_PER_SESSION 
  • E、PRIVATE_SGA

正确答案:C

第6题：

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）

A. It collects data from SGA and compares it with a preserved snapshot.

B. It collects data from SGA, analyzes it, and provides a report.

C. It collects data from SGA and compares it with the latest snapshot.

D. It collects data from both SGA and PGA, analyzes it, and provides a report


参考答案：B

第7题：

You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

  • A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
  • B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
  • C、 The database instance starts，but Automatic Memory Management is disabled
  • D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

正确答案:B

第8题：

Note the following parameters settings in your database:What would happen?()

A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically

B. It will be successful only if the memory is available from the auto tuned components

C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET

D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE


参考答案：D

第9题：

Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）

  • A、The SGA advisor will be disabled.
  • B、The MTTR advisor will be disabled.
  • C、Automatic checkpoint tuning will be disabled.
  • D、Checkpoint information will not be written to the alert log file.

正确答案:B,C

第10题：

For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

  • A、 Automatic PGA Memory Management
  • B、 Automatic SGA Memory Management
  • C、 Automatic Shared Memory Management
  • D、 Automatic Memory Management
  • E、 Manual SGA Memory Management
  • F、 None of the above

正确答案:D

更多相关问题
相关内容