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

In an Oracle 10g database， the in-memory statistics are gath

题目
单选题
In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）
A

 Recovery catalog

B

 Oracle Enterprise Manager Repository

C

 Automatic Workload Repository （AWR）

D

 Oracle 10g Enterprise Manager Grid Control

E

 Automatic Database Diagnostic Monitor （ADDM）

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

第1题：

Which setting enables the baselines by default in Oracle Database 11g?()

A. setting the STATISTICS_LEVEL parameter to TYPICAL

B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)

C. enabling Automated Maintenance Task using Oracle Enterprise Manager

D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE


参考答案：A

第2题：

You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

  • A、Application Server Control
  • B、Oracle Management Service
  • C、Oracle Enterprise Manager Repository
  • D、Oracle Enterprise Manager Database Control

正确答案:C,D

第3题：

As shown in the diagram, in－memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?()

A. CKPT

B. SMON

C. MMON

D. DBWR


参考答案：C

第4题：

In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（） 

  • A、recovery catalog
  • B、Oracle Enterprise Manager Repository
  • C、Automatic Workload Repository （AWR）
  • D、Oracle 10g Enterprise Manager Grid Control
  • E、Automatic Database Diagnostic Monitor （ADDM）

正确答案:C

第5题：

You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）

  • A、SQL*Plus
  • B、iSQL*Plus
  • C、Management Server
  • D、Management Repository
  • E、Oracle Enterprise Manager 10g Database Control

正确答案:E

第6题：

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

  • A、 MMAN
  • B、 PMON
  • C、 MMON
  • D、 MMNL

正确答案:A

第7题：

You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

  • A、The Oracle kernel will be placed in this location.
  • B、The Oracle software will be placed in this location.
  • C、The server parameter file （SPFILE） will be placed in this location.
  • D、The database files will be placed in this location， if not specified explicitly.
  • E、The location will be considered for the base of Oracle Managed Files （OMF）.
  • F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.

正确答案:F

第8题：

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）

A. They execute and create a virtual catalog for pre-Oracle 11g clients.

B. They produce an error because PROD1 and PROD2 databases belong to the older version.

C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

D. They produce an error because you need to connect to the target database to execute this packaged procedure.


参考答案：A

第9题：

You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）

  • A、 LGWR
  • B、 DBWR
  • C、 MMON
  • D、 RVWR

正确答案:D

第10题：

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）

  • A、The ASM compatibility attribute controls the format of the disk group metadata.
  • B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
  • C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
  • D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
  • E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

正确答案:A,B,D

更多相关问题
相关内容