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

考题 View the Exhibit to examine the metrics with a threshold.Which statement is true regarding the Number of Transactions (per second) metric?() A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.B. The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.C. Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.D. The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.

查看答案

考题 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 production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information？（）A、 Fixed viewsB、 The alert log fileC、 The parameter fileD、 The server parameter fileE、 Dynamic performance views

查看答案

考题 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 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

查看答案

考题 You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A、The advisory memory has been turned off.B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

查看答案

考题 You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）A、The trace fileB、The fixed viewsC、The data dictionary viewsD、The operating system log fieldsE、The dynamic performance views.

查看答案

考题 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

查看答案

考题 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.

查看答案

考题 The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）A、fixed viewsB、the alert log fileC、the parameter fileD、the server parameter fileE、dynamic performance views

查看答案

考题 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 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 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.

查看答案

考题单选题The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information？（）A Fixed viewsB The alert log fileC The parameter fileD The server parameter fileE Dynamic performance views

查看答案

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

查看答案

考题单选题View the Exhibit to examine the metrics with a threshold.Which statement is true regarding the Number of Transactions (per second) metric?（）A Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.B The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.C Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.D The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.

查看答案

考题单选题You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A The advisory memory has been turned off.B The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

查看答案

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

查看答案

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

查看答案

考题单选题The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）A fixed viewsB the alert log fileC the parameter fileD the server parameter fileE dynamic performance views

查看答案

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

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：