网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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?（）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).” 相关考题
考题
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
考题
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 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 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 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.
考题
多选题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.
考题
多选题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.
考题
多选题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?（）AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.BIt fails because no SQL *Loader data file location is specified.CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.DIt fails because no SQL *Loader control file location is specified.
考题
多选题Which two statements are true regarding hot patching? （）AIt requires relinking of the Oracle binary.BIt does not require database instance shutdown.CIt can detect conflicts between two online patches.DIt is available for installing all patches on all platforms.EIt works only in a single database instance environment.
考题
多选题Which three statements are true regarding the functioning of the Autotask Background Process （ABP）？（）AIt creates jobs without considering the priorities associated with them.BIt translates tasks into jobs for execution by the scheduler.CIt determines the list of jobs that must be created for each maintenance window.DIt is spawned by the MMON background process at the start of the maintenance window.EIt maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
考题
多选题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.
考题
多选题To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）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.
热门标签
最新试卷
