单选题You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90 Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）ASystem monitor （SMON）BProcess monitor （PMON）CMemory manager process （MMAN）DManageability Monitor process （MMON）
单选题
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90 Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）
A
System monitor （SMON）
B
Process monitor （PMON）
C
Memory manager process （MMAN）
D
Manageability Monitor process （MMON）
参考解析
解析：
可管理性监视器进程(MMON)，可执行各种与可管理性相关的后台任务，
例如：
• 每当给定的度量超过其阈值时发出预警
• 通过衍生附加进程（MMON 从属进程）获取快照
• 捕获近期已做修改的SQL 对象的统计值
例如：
• 每当给定的度量超过其阈值时发出预警
• 通过衍生附加进程（MMON 从属进程）获取快照
• 捕获近期已做修改的SQL 对象的统计值
相关考题：
Thewarninglevelthresholdvalueforatablespace,EXECUTEDBMS_SERVER_ALERT.SET_THRESHOLD（dbms_server_alert.tablespace_pct_full，dbms_server_alert.operator_ge，80，dbms_server_alert.operator_ge，90，1，1，NULL，dbms_server_alert.object_type_tablespace，’DATA’）；Whatwillbetheresultofthecommand？（）
You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace
While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）A、 It would result in an error because the warning threshold cannot be more than the critical threshold.B、 The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.C、 The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.D、 Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A、 The EVENT parameter was not setB、 The SQL_TRACE parameter is set to FALSEC、 The Enterprise Manager Grid Control is not usedD、 The STATISTICS_LEVEL parameter is set to BASICE、 The TIMED_STATISTICS parameter is set to FALSE
In which scenario will you perform a cancel-based recovery？（）A、 when a tablespace is dropped and you have only RMAN-based backup of the databaseB、 when a table is dropped and stored in the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when a tablespace is dropped and you have only a user-managed full backup of the database
The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50 % and critical threshold to be 53% in Database Control. Which statement is true？（）A、 The new setting would be applied but no alerts would be raised immediately.B、 The new setting would be applied and an alert would be raised immediately.C、 The new setting would be ignored because the tablespace space usage is more than the specified threshold value.D、 The new setting would cause an error because the tablespace space usage is more than the specified threshold value.
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A、The EVENT parameter was not set.B、The SQL_TRACE parameter is set to FALSEC、The Enterprise Manager Grid Control is not used.D、The STATISTICS_LEVEL parameter is set to BASICE、The TIMED_STATISTICS parameter is set to FALSE
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command： SQL SELECT reason，metric_value FROM dba_outstanding_alerts； REASON METRIC_VALUE ------------------------------------------------------------ ------------ Tablespace [TEST] is [28 percent]full 28.125 What could be the reason for the elimination of the other rows in the output（）A、An Automatic Workload Repository snapshot has been taken recently.B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）A、It would result in an error because the warning threshold cannot be more than the critical threshold.B、The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.C、The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.D、Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）A、 No warning level or critical level alert will be generated.B、 A warning level alert will never be generated， but a critical level alert will be generated when 97 percent space of the DATA1 tablespace is used.C、 A critical level alert will never be generated， but a warning level alert will be generated when 85 percent space of the DATA1 tablespace is used.D、 A warning level alert will be generated at 85 percent space usage of the DATA1 tablespace， and a critical level alert is generated at 97 percent space usage of the DATA1 tablespace.
An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）A、TEST_TBS is a small file tablespace B、TEST_TBS is a bigfile tablespace (BFT)C、TEST_TBS is the default temporary tablespaceD、TEST_TBS is a dictionary-managed tablespaceE、Threshold values for the TEST_TBS tablespace are not explicitly specified
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）A、 Disable SQL tracing for the APPS tablespace.B、 Disable logging attributes for the APPS tablespace.C、 Modify the tablespace to be a dictionary-managed tablespace.D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
单选题In which scenario will you perform a cancel-based recovery？（）A when a tablespace is dropped and you have only RMAN-based backup of the databaseB when a table is dropped and stored in the Recycle BinC when you are required to recover an existing table to its previous stateD when a tablespace is dropped and you have only a user-managed full backup of the database
单选题An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）ATEST_TBS is a small file tablespace BTEST_TBS is a bigfile tablespace (BFT)CTEST_TBS is the default temporary tablespaceDTEST_TBS is a dictionary-managed tablespaceEThreshold values for the TEST_TBS tablespace are not explicitly specified
单选题You want the size of the tablespace to increase when it is full. Which option would you use？（）Ause automatic extent allocationBdisable threshold for the tablespaceCuse freelists to manage the free spaceDuse automatic segment space managementEcreate the tablespace as a bigfile tablespaceFuse the RESIZE clause while creating the tablespaceGenable AUTOEXTEND for at least one of the data files in the tablespace
单选题While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）A It would result in an error because the warning threshold cannot be more than the critical threshold.B The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.C The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.D Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）AThe EVENT parameter was not set.BThe SQL_TRACE parameter is set to FALSECThe Enterprise Manager Grid Control is not used.DThe STATISTICS_LEVEL parameter is set to BASICEThe TIMED_STATISTICS parameter is set to FALSE
单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A The EVENT parameter was not setB The SQL_TRACE parameter is set to FALSEC The Enterprise Manager Grid Control is not usedD The STATISTICS_LEVEL parameter is set to BASICE The TIMED_STATISTICS parameter is set to FALSE
单选题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.
单选题The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50% and critical threshold to be 53% in Database Control. Which statement is true？（）AThe new setting would be applied but no alerts would be raised immediately.BThe new setting would be applied and an alert would be raised immediately.CThe new setting would be ignored because the tablespace space usage is more than the specified threshold value.DThe new setting would cause an error because the tablespace space usage is more than the specified threshold value.
单选题While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）AIt would result in an error because the warning threshold cannot be more than the critical threshold.BThe warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.CThe critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.DBoth threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）ADBMS_STATS BDBMS_ALERT CDBMS_SPACE DDBMS_MONITOR EDBMS_SERVER_ALERTFDBMS_SPACE_ADMIN
单选题View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command： SQL SELECT reason，metric_value FROM dba_outstanding_alerts； REASON METRIC_VALUE ------------------------------------------------------------ ------------ Tablespace [TEST] is [28 percent]full 28.125 What could be the reason for the elimination of the other rows in the output（）AAn Automatic Workload Repository snapshot has been taken recently.BThe non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.CThe threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.DThe threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
单选题You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）ASystem monitor （SMON）BProcess monitor （PMON）CMemory manager process （MMAN）DManageability Monitor process （MMON）
单选题Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）Adisable SQL tracing for theAPPS tablespaceBdisable logging attribute for the APPS tablespaceCmodify the tablespace to be a dictionarymanaged tablespaceDincrease the critical threshold value for the tablespace space usage metrics for the APPS tablespaceEincrease the warning threshold value for the tablespace space usage metrics for the APPS tablespace
单选题Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）A Disable SQL tracing for the APPS tablespace.B Disable logging attributes for the APPS tablespace.C Modify the tablespace to be a dictionary-managed tablespace.D Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.E Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
单选题The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command： SQL EXECUTE DBMS_SERVER_ALERT.SET_THRESHOLD （dbms_server_alert.tablespace_pct_full， dbms_server_alert.operator_ge，80， dbms_server_alert.operator_ge，90， 1，1，NULL， dbms_server_alert.object_type_tablespace，’DATA’）； What will be the result of the command？（）A The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.B The total numbers of alerts that you receive every day will be reduced.C The total number of alerts that you receive every day will be increased.D No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.