多选题Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?（）AIt does not allow you to change the moving window size.BAdaptive threshold functionalities use it by default to compute statistics.CIt is created by

题目
多选题
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?（）
A

It does not allow you to change the moving window size.

B

Adaptive threshold functionalities use it by default to compute statistics.

C

It is created by default with the window size being equal to the AWR retention time.

D

It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

相似考题

1.View the Exhibit that sets the threshold for the Current Open Cursors Count metric.Why is the Significance Level threshold type not available in the threshold setting?()A. because AWR baseline is not enabledB. because Current Open Cursors Count is not a basic metricC. because the STATISTICS_LEVEL parameter is set to BASICD. because the AWR baseline is a system-defined moving window baseline

2.Which statements are true regarding the system－defined moving window baseline in Oracle Database 11g?()A. It does not allow you to change the moving window size.B. Adaptive threshold functionalities use it by default to compute statistics.C. It is created by default with the window size being equal to the AWR retention time.D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

3.You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）A. Set a threshold for the default system-defined moving window baseline.B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).C. Modify the profile for the targeted users for which control needs to be imposed.D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

4.You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A. The collection level for the AWR should be set to BASICB. The moving window size must be less than Undo RetentionC. The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

参考答案和解析
正确答案： A,D
解析： 暂无解析
更多“多选题Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?（）AIt does not allow you to change the moving window size.BAdaptive threshold functionalities use it by default to compute statistics.CIt is created by”相关问题

  • 第1题：

    You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()

    A. Compute the baseline statistics.

    B. Take an immediate AWR snapshot.

    C. Decrease the window size for the baseline.

    D. Decrease the expiration time for the baseline.


    参考答案：A

  • 第2题：

    You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?（）

    • A、Compute the baseline statistics.
    • B、Take an immediate AWR snapshot.
    • C、Decrease the window size for the baseline.
    • D、Decrease the expiration time for the baseline.

    正确答案:A

  • 第3题：

    You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

    • A、 The audit trail is stored in an operating system file.
    • B、 Auditing is disabled for all privileges.
    • C、 The audit trail is stored in the database.
    • D、 Auditing is enabled for all privileges.
    • E、 Auditing is enabled for certain privileges related to database security.

    正确答案:C,E

  • 第4题：

    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

  • 第5题：

    To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? （）(Choose two.)

    • A、Multiple change tracking files can be created for a database.
    • B、The change tracking file must be created after the first level 0 backup.
    • C、RMAN does not support backup and recovery of the change tracking file.
    • D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

    正确答案:C,D

  • 第6题：

    Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g？（）

    • A、 It does not allow you to change the moving window size.
    • B、 Adaptive threshold functionalities use it by default to compute statistics.
    • C、 It is created by default with the window size being equal to the AWR retention time.
    • D、 It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.

    正确答案:B,C

  • 第7题：

    You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）

    • A、Set a threshold for the default system-defined moving window baseline.
    • B、Add directives to the Automatic Database Diagnostic Monitor (ADDM).
    • C、Modify the profile for the targeted users for which control needs to be imposed.
    • D、Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

    正确答案:D

  • 第8题：

    多选题
    You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）
    A

    The audit trail is stored in an operating system file.

    B

    Auditing is disabled for all privileges.

    C

    The audit trail is stored in the database.

    D

    Auditing is enabled for all privileges.

    E

    Auditing is enabled for certain privileges related to database security.


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

  • 第9题：

    多选题
    Which two statements are true regarding hot patching? （）
    A

    It requires relinking of the Oracle binary.

    B

    It does not require database instance shutdown.

    C

    It can detect conflicts between two online patches.

    D

    It is available for installing all patches on all platforms.

    E

    It works only in a single database instance environment.


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

  • 第10题：

    多选题
    Which two statements are true with respect to the maintenance window？（） .
    A

    A DBA can enable or disable an individual task in all maintenance windows.

    B

    A DBA cannot change the duration of the maintenance window after it is created.

    C

    In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.

    D

    A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window


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

  • 第11题：

    单选题
    You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?（）
    A

    Compute the baseline statistics.

    B

    Take an immediate AWR snapshot.

    C

    Decrease the window size for the baseline.

    D

    Decrease the expiration time for the baseline.


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

  • 第12题：

    单选题
    You plan to set up the Automatic Workload Repository （AWR） baseline metric thresholds for a moving window baseline. Which action would you take before performing this task？（）
    A

     Compute the baseline statistics.

    B

     Take an immediate AWR snapshot.

    C

     Decrease the window size for the baseline.

    D

     Decrease the expiration time for the baseline.


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

  • 第13题：

    You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）

    • A、The collection level for the AWR should be set to BASIC
    • B、The moving window size must be less than Undo Retention
    • C、The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
    • D、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

    正确答案:D

  • 第14题：

    To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）

    • A、Multiple change tracking files can be created for a database.
    • B、The change tracking file must be created after the first level 0 backup.
    • C、RMAN does not support backup and recovery of the change tracking file.
    • D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

    正确答案:C,D

  • 第15题：

    Which two statements are true with respect to the maintenance window？（） .

    • A、 A DBA can enable or disable an individual task in all maintenance windows.
    • B、 A DBA cannot change the duration of the maintenance window after it is created.
    • C、 In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.
    • D、 A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window

    正确答案:A,D

  • 第16题：

    You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file？（））  

    • A、 Its entries are specific to a single database.
    • B、 It contains file systems that have been mounted by Direct NFS.
    • C、 It is globally available to all Oracle 11g databases on the machine.
    • D、 It contains file systems that have been mounted by the kernel NFS system.

    正确答案:C,D

  • 第17题：

    You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

    • A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.
    • B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.
    • C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.
    • D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

    正确答案:C

  • 第18题：

    Which two statements are true with respect to the maintenance window? （）

    • A、A DBA can enable or disable an individual task in all maintenance windows.
    • B、A DBA cannot change the duration of the maintenance window after it is created.
    • C、In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
    • D、A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

    正确答案:A,D

  • 第19题：

    多选题
    You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file？（））
    A

    Its entries are specific to a single database.

    B

    It contains file systems that have been mounted by Direct NFS.

    C

    It is globally available to all Oracle 11g databases on the machine.

    D

    It contains file systems that have been mounted by the kernel NFS system.


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

  • 第20题：

    多选题
    On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）
    A

    It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

    B

    It fails because no SQL *Loader data file location is specified.

    C

    It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

    D

    It fails because no SQL *Loader control file location is specified.


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

  • 第21题：

    多选题
    Which three statements are true regarding the functioning of the Autotask Background Process （ABP）？（）
    A

    It creates jobs without considering the priorities associated with them.

    B

    It translates tasks into jobs for execution by the scheduler.

    C

    It determines the list of jobs that must be created for each maintenance window.

    D

    It is spawned by the MMON background process at the start of the maintenance window.

    E

    It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.


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

  • 第22题：

    多选题
    Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?（）
    A

    It does not allow you to change the moving window size.

    B

    Adaptive threshold functionalities use it by default to compute statistics.

    C

    It is created by default with the window size being equal to the AWR retention time.

    D

    It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).


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

  • 第23题：

    多选题
    To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? （）(Choose two.)
    A

    Multiple change tracking files can be created for a database.

    B

    The change tracking file must be created after the first level 0 backup.

    C

    RMAN does not support backup and recovery of the change tracking file.

    D

    The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.


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

  • 第24题：

    多选题
    To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）
    A

    Multiple change tracking files can be created for a database.

    B

    The change tracking file must be created after the first level 0 backup.

    C

    RMAN does not support backup and recovery of the change tracking file.

    D

    The database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.


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

相关内容