网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）
A
run a procedure to check the tablespace space usage
B
define the warning threshold for the tablespace at 75% in Database Control
C
create a trigger to be executed when tablespace space usage reaches 75%
D
submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
E
define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
参考答案
参考解析
解析：
暂无解析
更多 “单选题You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）A run a procedure to check the tablespace space usageB define the warning threshold for the tablespace at 75% in Database ControlC create a trigger to be executed when tablespace space usage reaches 75%D submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsE define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command” 相关考题
考题
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 shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low on space
考题
You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace
考题
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.
考题
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 setB、 The SQL_TRACE parameter is set to FALSEC、 The Enterprise Manager Grid Control is not usedD、 The STATISTICS_LEVEL parameter is set to BASICE、 The TIMED_STATISTICS parameter is set to FALSE
考题
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
考题
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.
考题
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 shrinkB、modify the storage parameters for the tablespaceC、automatically shrink the segments with unused spaceD、check the alerts generated for the tablespace that is running low on space
考题
You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）A、run a procedure to check the tablespace space usageB、define the warning threshold for the tablespace at 75% in Database ControlC、create a trigger to be executed when tablespace space usage reaches 75%D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsE、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
考题
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 FALSEC、The Enterprise Manager Grid Control is not used.D、The STATISTICS_LEVEL parameter is set to BASICE、The TIMED_STATISTICS parameter is set to FALSE
考题
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.
考题
You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）A、the alert.log fileB、the DBA_ALERTS viewC、the Database Control Home pageD、the Database Control performance pageE、the Database Control Maintenance page
考题
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.
考题
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？（）A、 Disable SQL tracing for the APPS tablespace.B、 Disable logging attributes 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 metric for the APPS tablespace.
考题
单选题You define an alert to be raised when the USERS tablespace usage has reached 80%of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）A
the alert.log fileB
the DBA_ALERTS viewC
the Database Control Home pageD
the Database Control performance pageE
the Database Control Maintenance page
考题
单选题You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）A
Segment Advisor B
SQL Tuning Advisor C
SQL Access Advisor D
Segment Resource Estimation E
Automatic Database Diagnostic Monitor (ADDM)
考题
单选题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 shrinkB
modify the storage parameters for the tablespaceC
automatically shrink the segments with unused spaceD
check the alerts generated for the tablespace that is running low on space
考题
单选题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 FALSEC
The Enterprise Manager Grid Control is not used.D
The STATISTICS_LEVEL parameter is set to BASICE
The TIMED_STATISTICS parameter is set to FALSE
考题
单选题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.
考题
单选题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.
考题
单选题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？（）A
Disable SQL tracing for the APPS tablespace.B
Disable logging attributes 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 metric for the APPS tablespace.
考题
单选题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.
考题
单选题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.
考题
单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）A
DBMS_STATS B
DBMS_ALERT C
DBMS_SPACE D
DBMS_MONITOR E
DBMS_SERVER_ALERTF
DBMS_SPACE_ADMIN
考题
单选题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 setB
The SQL_TRACE parameter is set to FALSEC
The Enterprise Manager Grid Control is not usedD
The STATISTICS_LEVEL parameter is set to BASICE
The TIMED_STATISTICS parameter is set to FALSE
考题
单选题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
考题
单选题You want the size of the tablespace to increase when it is full. Which option would you use？（）A
use automatic extent allocationB
disable threshold for the tablespaceC
use freelists to manage the free spaceD
use automatic segment space managementE
create the tablespace as a bigfile tablespaceF
use the RESIZE clause while creating the tablespaceG
enable AUTOEXTEND for at least one of the data files in the tablespace
考题
单选题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
热门标签
最新试卷
