单选题In an Oracle 10g database， the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend analysis and capacity planning of the database. Which component stores these statistics？（）A recovery catalogB Oracle Enterprise

题目
单选题
In an Oracle 10g database， the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend 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.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.

2.下面不属于Oracle 10g产品系列的是()。A.Oracle数据库10g标准版B.Oracle数据库10g企业版C.Oracle数据库10g网络版

3. 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、 MMANB、 PMONC、 MMOND、 MMNL

4.Which setting enables the baselines by default in Oracle Database 11g?()A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

更多“In an Oracle 10g database， the in/x7fmemory statistics are g”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（）

    • A、 Advisor Central
    • B、 Global Attributes
    • C、 Resource Monitors
    • D、 Memory Parameters
    • E、 Database Usage Statistics
    • F、 All Initialization Parameters
    • G、 Automatic Workload Repository

    正确答案:A,C

  • 第4题：

    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

  • 第5题：

    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

    • A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
    • B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    正确答案:D

  • 第6题：

    下面不属于Oracle 10g产品系列的是（）。

    • A、Oracle数据库10g标准版
    • B、Oracle数据库10g企业版
    • C、Oracle数据库10g网络版

    正确答案:C

  • 第7题：

    多选题
    In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
    A

    average row size

    B

    last analyzed date

    C

    size of table in bytes

    D

    size of table in database blocks

    E

    number of free blocks in the free list

    F

    number of extents present in the table


    正确答案： A,C
    解析： 暂无解析

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

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


    正确答案： C
    解析： 暂无解析

  • 第10题：

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


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）
    A

     Oracle Enterprise Manager

    B

     The V$LOG view

    C

     The V$LOGFILE view

    D

     The V$FLASHBACK_DATABASE_LOGS view


    正确答案： A
    解析： 暂无解析

  • 第12题：

    多选题
    You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）
    A

    The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.

    B

    RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.

    C

    The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

    D

    ASM compatibility controls which features for the ASM will be enabled.


    正确答案： B,D
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    In an Oracle 10g database， the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend 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）

    正确答案:A

  • 第17题：

    You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users’ passwords？（）  

    • A、 All passwords automatically become case-sensitive.
    • B、 All passwords remain non-case-sensitive till they are changed.
    • C、 All passwords remain non-case-sensitive and cannot be changed.
    • D、 All passwords remain non-case-sensitive until their password attribute in the profile is altered.

    正确答案:B

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

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


    正确答案： C
    解析： 暂无解析

  • 第20题：

    多选题
    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.


    正确答案： B,E
    解析： 暂无解析

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

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


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）
    A

      STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    B

      STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    C

      STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    D

      STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；


    正确答案： A
    解析： 暂无解析

相关内容