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

第1题：

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

第2题：

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 tablespace.
• D、 TEST_TBS is a dictionary-managed tablespace.

第3题：

第4题：

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.

第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题：

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？（）

• A、disable SQL tracing for theAPPS tablespace
• B、disable logging attribute 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 metrics for the APPS tablespace

第7题：

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。

• A、identify the segments that you should shrink
• B、modify the storage parameters for the tablespace
• C、automatically shrink the segments with unused space
• D、check the alerts generated for the tablespace that is running low on space

第8题：

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）

• A、Take the USERS tablespace offline and re-create the lost data file.
• B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
• C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
• D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

第9题：

You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason？（）

• A、None of the SYSAUX occupants can be relocated.
• B、The USERS tablespace is a bigfile tablespace （BFT）.
• C、The united Job Scheduler occupant cannot be relocated.
• D、The SYSAUX occupants can be relocated to the SYSTEM tablespace only.

第10题：

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）

• A、Take the USERS tablespace offline and re-create the lost data file.
• B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
• C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
• D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.