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

单选题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 t

题目
单选题
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（）
A

Run the SQL Access Advisor

B

Run the Memory Advisor for the sga.

C

Run the Memory Advisor for the pga.

D

Run the Memory Advisor for the shared pool.

E

Run the Memory Advisor for the buffer cache

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

第1题：

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.

正确答案:D

第2题：

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？（）

  • A、modify the HASH_AREA_SIZE initialization parameter
  • B、modify the PGA_AGGREGATE_TARGET initialization parameter
  • C、modify the WORK_AREASIZE_POLICY initialization parameter
  • D、increase the value of the SGA_TARGET initialization parameter
  • E、increase the value of the SGA_MAX_SIZE initialization parameter
  • F、increase the value of the SORT_AREA_SIZE initialization parameter

正确答案:B

第3题：

Examine the parameter setting in your database:Which statement is correct about the database?()

A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set

B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set

C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set

D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup


参考答案：D

第4题：

You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

  • A、Mount the database
  • B、Open the database in NORMAL mode
  • C、Open the database in RESTRICTED mode
  • D、Open the database with the RESETLOGS option

正确答案:A

第5题：

Which statement is true about the Manageability Monitor （MMON） background proces（）

  • A、It transfers statistics from memory to disk at regular intervals.
  • B、It coordinates the rebalance activity for disk groups when ASM is used.
  • C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.
  • D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

正确答案:A

第6题：

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

第7题：

You work as a database administrator for Certkiller .com. 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）

正确答案:C

第8题：

You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

A. Mount the database

B. Open the database in NORMAL mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option


参考答案：A

第9题：

You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

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

正确答案:C

第10题：

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（）

  • A、Run the SQL Access Advisor.
  • B、Run the Memory Advisor for the sga
  • C、Run the Memory Advisor for the pga.
  • D、Run the Memory Advisor for the shared pool.
  • E、Run the Memory Advisor for the buffer cache

正确答案:D

更多相关问题
相关内容