You have set Tablespace Full Metrics Threshold values for th

第1题：

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.

第2题：

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 database
• B、 when a table is dropped and stored in the Recycle Bin
• C、 when you are required to recover an existing table to its previous state
• D、 when a tablespace is dropped and you have only a user-managed full backup of the database

第3题：

第4题：

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.

第5题：

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 FALSE
• C、The Enterprise Manager Grid Control is not used.
• D、The STATISTICS_LEVEL parameter is set to BASIC
• E、The TIMED_STATISTICS parameter is set to FALSE

第6题：

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 FALSE
• C、 The Enterprise Manager Grid Control is not used
• D、 The STATISTICS_LEVEL parameter is set to BASIC
• E、 The TIMED_STATISTICS parameter is set to FALSE

第7题：

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.

第8题：

You want the size of the tablespace to increase when it is full. Which option would you use？（）

• A、use automatic extent allocation
• B、disable threshold for the tablespace
• C、use freelists to manage the free space
• D、use automatic segment space management
• E、create the tablespace as a bigfile tablespace
• F、use the RESIZE clause while creating the tablespace
• G、enable AUTOEXTEND for at least one of the data files in the tablespace

第9题：

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.

第10题：

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.