网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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？（）
A
The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.
B
The total numbers of alerts that you receive every day will be reduced.
C
The total number of alerts that you receive every day will be increased.
D
No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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？（）A The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.B The total numbers of alerts that you receive every day will be reduced.C The total number of alerts that you receive every day will be increased.D No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.” 相关考题
考题
You observed the following output for a user session:What do you infer from the preceding output?()
A. Resumable set for session with sid 18B. The user session has entered into a deadlockC. The database instance is enabled to use asynchronous commitD. The threshold warning limit is exceeded for the tablespace that is used by the user session
考题
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
考题
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.
考题
Which statement will NOT create a tablespace？（）A、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc（datafile）’；B、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1’；C、 CREATE TABLESPACE DATA1 DATAFILE ’+data1（tempfile）’；D、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’；
考题
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.
考题
You have created a locally managed tablespace by issuing the following command： CREATE TABLESPACE data1 DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE UNLIMITED； For the DATA1 tablespace， you have set the warning level alert limit to 70 percent. In which situation will a warning level alert be generated？（） A、 when 700 KB is usedB、 when 700 KB is left as free spaceC、 when 7MB is usedD、 when 7MB is left as free spaceE、 no alert will be generated because an autoextensible datafile is included in the tablespace
考题
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 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.
考题
You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）A、 all the datafiles in the databaseB、 the datafiles associated with the SYSTEM tablespaceC、 the datafiles associated with the DATA1 tablespaceD、 all the datafiles in the database except those associated with 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 have created a locally managed tablespace by issuing the following command： CREATE TABLESPACE data1 DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE UNLIMITED； For the DATA1 tablespace， you have set the warning level alert limit to 70 percent. In which situation will a warning level alert be generated？（）A
when 700 KB is usedB
when 700 KB is left as free spaceC
when 7MB is usedD
when 7MB is left as free spaceE
no alert will be generated because an autoextensible datafile is included in the tablespace
考题
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement： ALTER TABLESPACE data1 BEGIN BACKUP； While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database，the database will not be opened.
考题
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database, the database will not be opened.
考题
单选题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 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
考题
单选题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
考题
单选题You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90 Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）A
System monitor （SMON）B
Process monitor （PMON）C
Memory manager process （MMAN）D
Manageability Monitor process （MMON）
考题
单选题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.
考题
单选题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 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？（）A
The tablespace， DATA1， is not read-only.B
The tablespace， DATA1， is not autoextensible.C
The tablespace， DATA1， is not offline.D
The segment space management for the tablespace， DATA1， is manual.
考题
单选题Which statement will NOT create a tablespace？（）A
CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc（datafile）’；B
CREATE TABLESPACE DATA1 DATAFILE ’+grp1’；C
CREATE TABLESPACE DATA1 DATAFILE ’+data1（tempfile）’；D
CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’；
考题
单选题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.
考题
单选题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 set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）A
System monitor （SMON）B
Process monitor （PMON）C
Memory manager process （MMAN）D
Manageability Monitor process （MMON）
考题
单选题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
考题
单选题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.
考题
单选题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？（）A
The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.B
The total numbers of alerts that you receive every day will be reduced.C
The total number of alerts that you receive every day will be increased.D
No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.
热门标签
最新试卷
