网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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）.
参考答案
更多 “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）.” 相关考题
考题
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
考题
View the Exhibit to examine the metrics with a threshold.Which statement is true regarding the Number of Transactions (per second) metric?()
A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.B. The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.C. Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.D. The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.
考题
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
考题
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).
考题
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.
考题
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.
考题
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
考题
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.
考题
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.
考题
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script： SQL@utlu111i.sql Which statement about the execution of this script is true？（）A、 It must be executed from the Oracle Database 11g environment.B、 It must be executed only after the SYSAUX tablespace has been created.C、 It must be executed from the environment of the database that is being upgraded.D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
考题
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.
考题
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
考题
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
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）A、Change in the Oracle Database versionB、Change in your network infrastructureC、Change in the hardware configuration of the database serverD、Migration of database storage from non-ASM to ASM storageE、Database and operating system upgrade
考题
多选题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？（））AIts entries are specific to a single database.BIt contains file systems that have been mounted by Direct NFS.CIt is globally available to all Oracle 11g databases on the machine.DIt contains file systems that have been mounted by the kernel NFS system.
考题
单选题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
考题
多选题You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）AThe audit trail is stored in an operating system file.BAuditing is disabled for all privileges.CThe audit trail is stored in the database.DAuditing is enabled for all privileges.EAuditing is enabled for certain privileges related to database security.
考题
多选题Which two statements are true with respect to the maintenance window？（） .AA DBA can enable or disable an individual task in all maintenance windows.BA DBA cannot change the duration of the maintenance window after it is created.CIn case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.DA DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window
考题
多选题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 default with the window size being equal to the AWR retention time.DIt is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
考题
单选题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.
考题
多选题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.)AMultiple change tracking files can be created for a database.BThe change tracking file must be created after the first level 0 backup.CRMAN does not support backup and recovery of the change tracking file.DThe database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
考题
单选题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.
热门标签
最新试卷