单选题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 catalogB Oracle Enterprise Manag

题目
单选题
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 Oracle Database component is audited by default if the unified Auditing option is enabled?()

A. Oracle Data Pump

B. Oracle Recovery Manager (RMAN)

C. Oracle Label Security

D. Oracle Database Vault

E. Oracle Real Application Security


参考答案:B

第2题:

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()

  • A、 Flashback logs are not archived.
  • B、 Flashback logs are maintained in redo log files.
  • C、 Flashback logs are maintained in the Flash Recovery Area.
  • D、 Flashback logs are used to maintain Flashback Database related errors.
  • E、 Flashback logs need to be cleared manually after you disable Flashback Database.

正确答案:A,C

第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题:

SQ L*Loader is a utility that can perform which two tasks?()

  • A、Load data from a disk, tape, or named pipes.
  • B、Load data into an Oracle database using DML statements.
  • C、Extract, reorganize, and insert data within an Oracle database.
  • D、Load data from external files into tables in an Oracle database.
  • E、Load data into an Oracle database using operating system commands.
  • F、Load data directly from a non-Oracle database to an Oracle database.

正确答案:A,D

第6题:

Which Oracle Database component is audited by default if the unified Auditing option is enabled?()

  • A、Oracle Data Pump
  • B、Oracle Recovery Manager (RMAN)
  • C、Oracle Label Security
  • D、Oracle Database Vault
  • E、Oracle Real Application Security

正确答案:B

第7题:

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

第8题:

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

第9题:

You work as a database administrator for Supportcenter.cn. 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

第10题:

While planning to manage more than one database in your system, you perform the following activities:  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you?()

  • A、Oracle Managed Files
  • B、Oracle Grid Architecture
  • C、Optimal Flexible Architecture
  • D、Oracle database architecture

正确答案:C

更多相关问题