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

题目内容(请给出正确答案)

单选题

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

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

参考答案和解析

正确答案： A

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题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？（）AThe index tablespace contains bitmap indexes.BThe index tablespace contains more than one data file.CThe index tablespace supports only complete recovery.DThe index tablespace is not a dictionary-managed tablespace.EThere is a dependency relationship between a table and its indexes.

点击查看答案
第2题

单选题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 setBThe SQL_TRACE parameter is set to FALSECThe Enterprise Manager Grid Control is not usedDThe STATISTICS_LEVEL parameter is set to BASICEThe TIMED_STATISTICS parameter is set to FALSE

点击查看答案
第3题

单选题You issued the following command： ALTER TABLE SCOTT.EMP SHRINK SPACE； The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties： DATA1 is a read/write tablespace. DATA1 is not autoextensible to an unlimited size. DATA1 is online. Segment space management for the DATA1 tablespace is manual. You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error： ORA-10635： Invalid segment or tablespace type What could be the reason for the failure of the command？（）AThe tablespace， DATA1， is not read-only.BThe tablespace， DATA1， is not autoextensible.CThe tablespace， DATA1， is not offline.DThe segment space management for the tablespace， DATA1， is manual.

点击查看答案
第4题

单选题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 tablespaceB disable logging attribute for the APPS tablespaceC modify the tablespace to be a dictionarymanaged tablespaceD increase the critical threshold value for the tablespace space usage metrics for the APPS tablespaceE increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

点击查看答案
第5题

单选题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 add data files to the tablespace B identify the segments that you should shrink C modify the storage parameters for the tablespace D automatically shrink the segments with unused space E check the alerts generated for the tablespace that is running low on space

点击查看答案
第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 tablespaceD TEST_TBS is a dictionary-managed tablespaceE Threshold values for the TEST_TBS tablespace are not explicitly specified

点击查看答案
第7题

单选题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？（）AThe command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.BThe total numbers of alerts that you receive every day will be reduced.CThe total number of alerts that you receive every day will be increased.DNo more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.

点击查看答案

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

第2题

第3题

第4题

第5题

第6题

第7题

相关内容