TEST_TBS is a small file tablespace
TEST_TBS is a bigfile tablespace (BFT)
TEST_TBS is the default temporary tablespace
TEST_TBS is a dictionary-managed tablespace
Threshold values for the TEST_TBS tablespace are not explicitly specified
第1题:
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()。
第2题:
You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason?()
第3题:
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?()
第4题:
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?()
第5题:
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?()
第6题:
The EVENT parameter was not set.
The SQL_TRACE parameter is set to FALSE
The Enterprise Manager Grid Control is not used.
The STATISTICS_LEVEL parameter is set to BASIC
The TIMED_STATISTICS parameter is set to FALSE
第7题:
TEST_TBS is a small file tablespace.
TEST_TBS is a bigfile tablespace (BFT).
TEST_TBS is the default temporary tablespace.
TEST_TBS is a dictionary-managed tablespace.
第8题:
Disable SQL tracing for the APPS tablespace.
Disable logging attributes for the APPS tablespace.
Modify the tablespace to be a dictionary-managed tablespace.
Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
第9题:
The index tablespace contains bitmap indexes.
The index tablespace contains more than one data file.
The index tablespace supports only complete recovery.
The index tablespace is not a dictionarymanaged tablespace.
There is a dependency relationship between a table and its indexes.
第10题:
The EVENT parameter was not set
The SQL_TRACE parameter is set to FALSE
The Enterprise Manager Grid Control is not used
The STATISTICS_LEVEL parameter is set to BASIC
The TIMED_STATISTICS parameter is set to FALSE
第11题:
disable SQL tracing for theAPPS tablespace
disable logging attribute for the APPS tablespace
modify the tablespace to be a dictionarymanaged tablespace
increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace
increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace
第12题:
TEST_TBS is a small file tablespace
TEST_TBS is a bigfile tablespace (BFT)
TEST_TBS is the default temporary tablespace
TEST_TBS is a dictionary-managed tablespace
Threshold values for the TEST_TBS tablespace are not explicitly specified
第13题:
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?()
第14题:
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?()
第15题:
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?()
第16题:
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?()
第17题:
identify the segments that you should shrink
modify the storage parameters for the tablespace
automatically shrink the segments with unused space
check the alerts generated for the tablespace that is running low on space
第18题:
TEST_TBS is a small file tablespace.
TEST_TBS is a bigfile tablespace (BFT).
TEST_TBS is the default temporary tablespace.
TEST_TBS is a dictionary-managed tablespace.
第19题:
No warning level or critical level alert will be generated.
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.
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.
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.
第20题:
identify the segments that you should shrink
modify the storage parameters for the tablespace
automatically shrink the segments with unused space
check the alerts generated for the tablespace that is running low on space
第21题:
The index tablespace contains bitmap indexes.
The index tablespace contains more than one data file.
The index tablespace supports only complete recovery.
The index tablespace is not a dictionary-managed tablespace.
There is a dependency relationship between a table and its indexes.
第22题:
The tablespace, DATA1, is not read-only.
The tablespace, DATA1, is not autoextensible.
The tablespace, DATA1, is not offline.
The segment space management for the tablespace, DATA1, is manual.
第23题:
add data files to the tablespace
identify the segments that you should shrink
modify the storage parameters for the tablespace
automatically shrink the segments with unused space
check the alerts generated for the tablespace that is running low on space
第24题:
The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.
The total numbers of alerts that you receive every day will be reduced.
The total number of alerts that you receive every day will be increased.
No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.