单选题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 T

第1题：

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

第2题：

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

第3题：

第4题：

You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime recovery on the index tablespace. What could be the reason for this？（）

• A、The index tablespace contains bitmap indexes.
• B、The index tablespace contains more than one data file.
• C、The index tablespace supports only complete recovery.
• D、The index tablespace is not a dictionary­managed tablespace.
• E、There is a dependency relationship between a table and its indexes.

第5题：

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.

第6题：

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.

第7题：

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

第8题：

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

第9题：

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.

第10题：

You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

• A、 The index tablespace contains bitmap indexes.
• B、 The index tablespace contains more than one data file.
• C、 The index tablespace supports only complete recovery.
• D、 The index tablespace is not a dictionary-managed tablespace.
• E、 There is a dependency relationship between a table and its indexes.