单选题Which setting enables the baselines by default in Oracle Database 11g？（）Asetting the STATISTICS_LEVEL parameter to TYPICALBadding filters to the Automatic Database Diagnostic Monitor （ADDM）Cenabling Automated Maintenance Task using Oracle Enterprise Ma

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

相似考题

1.During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?（）A. The installation terminates with an error.B. The installation proceeds with the default value without warnings and errors.C. The installation proceeds with the default value but it would not be an OFA-compliant database.D. The installation proceeds with the default value but a message would be generated in the alert log file.

2.Which Oracle Database component is audited by default if the unified Auditing option is enabled?()A. Oracle Data PumpB. Oracle Recovery Manager (RMAN)C. Oracle Label SecurityD. Oracle Database VaultE. Oracle Real Application Security

3.Which statement correctly describes network security settings in Cisco Network Assistant for the Catalyst Express 500 Switch？（）A、The LOW setting enables broadcast storm control， but has no effect on the number of devices that can connect to a switch portB、The LOW setting enables broadcast storm control and limits the number of devices that can connect to a switch port.C、The LOW setting disables broadcast storm control but limits the number of devices that can connect to a switch portD、The default network setting is "HIGH"

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

更多“Which setting enables the baselines by default in Oracle Dat”相关问题

  • 第1题：

    On switch R1 you issue the "udld enable" global command.  What does this command accomplish？ （）

    • A、 Enables all fiber-optic LAN ports for Unidirectional LINK Detection （UDLD）
    • B、 Enables all copper media LAN ports Unidirectional Link Detection （UDLD）
    • C、 Overrides the default UDLS setting for all ports
    • D、 Globally enables all ports on the device for Unidirectional Link Detection （UDLS）
    • E、 None of the other alternatives apply

    正确答案:A

  • 第2题：

    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

  • 第3题：

    An administrator is testing setting the IP address on a Linux server from command line. Which of the following commands is used to set the default gateway for the server？（）

    • A、route
    • B、traceroute
    • C、ipconfig
    • D、nmap

    正确答案:A

  • 第4题：

    Which of the following options enables a user to get authenticated though a single password instead of using multiple passwords？（）

    • A、Wallet Manager
    • B、Radius
    • C、Oracle Internet Directory
    • D、None of the above

    正确答案:A

  • 第5题：

    A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）

    • A、The value for MINEXTENTS setting 
    • B、The value for PCTINCREASE setting 
    • C、The value for MAXEXTENTS setting 
    • D、By default, Oracle allocates six extents to all database objects

    正确答案:A

  • 第6题：

    When setting up the Flashback Data Archive， which of these key parameters are required？（）

    • A、 Tablespace name
    • B、 Storage quota
    • C、 Retention
    • D、 Table name
    • E、 Create a default archive

    正确答案:A,C

  • 第7题：

    单选题
    On switch R1 you issue the "udld enable" global command.  What does this command accomplish？ （）
    A

     Enables all fiber-optic LAN ports for Unidirectional LINK Detection （UDLD）

    B

     Enables all copper media LAN ports Unidirectional Link Detection （UDLD）

    C

     Overrides the default UDLS setting for all ports

    D

     Globally enables all ports on the device for Unidirectional Link Detection （UDLS）

    E

     None of the other alternatives apply


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

  • 第8题：

    单选题
    You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）
    A

    DB_CREATE_FILE_DEST 

    B

    DB_CREATE_ONLINE_LOG_1 

    C

    DB_CREATE_ONLINE_LOG_2

    D

    The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed


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

  • 第9题：

    单选题
    A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）
    A

    The value for MINEXTENTS setting 

    B

    The value for PCTINCREASE setting 

    C

    The value for MAXEXTENTS setting 

    D

    By default, Oracle allocates six extents to all database objects


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

  • 第10题：

    单选题
    Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（）   The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t set
    A

     then the default is set to $ORACLE_BASE  The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，

    B

     then it is set to $ORACLE_HOME

    C

     DIAGNOSTIC_DEST is always equal to $ORACLE_HOME

    D

     DIAGNOSTIC_DEST is always equal to $ORACLE_BASE


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

  • 第11题：

    单选题
    Which statement correctly describes network security settings in Cisco Network Assistant for the Catalyst Express 500 Switch？（）
    A

    The LOW setting enables broadcast storm control， but has no effect on the number of devices that can connect to a switch port

    B

    The LOW setting enables broadcast storm control and limits the number of devices that can connect to a switch port.

    C

    The LOW setting disables broadcast storm control but limits the number of devices that can connect to a switch port

    D

    The default network setting is HIGH


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

  • 第12题：

    多选题
    Which three are the valid statements in relation to SQL plan baselines?（）
    A

    The plans can be manually loaded to the SQL plan baseline.

    B

    The plans in the SQL plan baseline are verified and accepted plans.

    C

    The plans generated for every SQL statement are stored in the SQL plan baseline by default.

    D

    The plan baselines are stored temporarily in the memory as long as the database instance is running.

    E

      For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.


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

  • 第13题：

    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

  • 第14题：

    Which three are the valid statements in relation to SQL plan baselines?（）

    • A、The plans can be manually loaded to the SQL plan baseline.
    • B、The plans in the SQL plan baseline are verified and accepted plans.
    • C、The plans generated for every SQL statement are stored in the SQL plan baseline by default.
    • D、The plan baselines are stored temporarily in the memory as long as the database instance is running.
    • E、  For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

    正确答案:A,B,E

  • 第15题：

    On a newly installed AIX V4 machine, which of the following default values applies to the ipforwarding network option?（）

    • A、 The ipforwarding is off by default. 
    • B、 The ipforwarding is set on by default. 
    • C、 The value is dynamically determined at boot time by DHCP. 
    • D、 The value is equal to the setting of the directed_broadcast runtime attribute.

    正确答案:A

  • 第16题：

    Identify four uses of the Oracle Scheduler.（）

    • A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
    • B、 enables Oracle database to do patches according to a DBA-defined schedule
    • C、 enables you to schedule the execution of jobs based on time
    • D、 enables you to execute jobs in a clustered environment
    • E、 enables you to periodically execute operating systemscript files located on the same server as the database
    • F、 enables you to create a job that makes use of saved programs and schedules
    • G、 enables you to automate the management of the jobs that are created using the DBMS_JOB package

    正确答案:C,D,E,F

  • 第17题：

    In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）  

    • A、 Setting a nonzero value for SGA_TARGET
    • B、 Configuring Automatic Shared Memory Management
    • C、 Configuring Automatic Memory Management
    • D、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
    • E、 None of the above

    正确答案:B

  • 第18题：

    You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）

    • A、DB_CREATE_FILE_DEST 
    • B、DB_CREATE_ONLINE_LOG_1 
    • C、DB_CREATE_ONLINE_LOG_2
    • D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

    正确答案:A

  • 第19题：

    单选题
    In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）
    A

     Setting a nonzero value for SGA_TARGET

    B

     Configuring Automatic Shared Memory Management

    C

     Configuring Automatic Memory Management

    D

     Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

    E

     None of the above


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

  • 第20题：

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

  • 第21题：

    多选题
    When setting up the Flashback Data Archive， which of these key parameters are required？（）
    A

    Tablespace name

    B

    Storage quota

    C

    Retention

    D

    Table name

    E

    Create a default archive


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

  • 第22题：

    单选题
    Note the following points describing various utilities in Oracle Database 11g：  1：It enables the high-speed transfer of data from one database to another.  2：It provides a complete solution for the backup， restoration， and recovery needs of the entire database.  3：It enables the loading of data from an external file into an Oracle database.  4：It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）
    A

    1

    B

    2

    C

    3

    D

    4

    E

    1，2，and 4

    F

    1，2，3，and 4


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

  • 第23题：

    单选题
    During the installation of Oracle Database 11g，you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.  How would this environment variable setting affect the installation？（）
    A

     The installation terminates with an error.

    B

     The installation proceeds with the default value without warnings and errors.

    C

     The installation proceeds with the default value but it would not be an OFA-compliant database.

    D

     The installation proceeds with the default value but a message would be generated in the alert log file.


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

相关内容