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

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

C

The Enterprise Manager Grid Control is not used.

D

The STATISTICS_LEVEL parameter is set to BASIC

E

The TIMED_STATISTICS parameter is set to FALSE

相似考题

1.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

2.While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.

3.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.

4.Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）A.B.C.D.E.

参考答案和解析
正确答案： C
解析： 暂无解析
更多“You have specified the warning and critical threshold values”相关问题

  • 第1题：

    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 FALSE
    • C、 The Enterprise Manager Grid Control is not used
    • D、 The STATISTICS_LEVEL parameter is set to BASIC
    • E、 The TIMED_STATISTICS parameter is set to FALSE

    正确答案:D

  • 第2题：

    While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

    • A、 A primary key must have been created.
    • B、 A mapping table must have been created.
    • C、 An overflow tablespace must have been specified.
    • D、 The PCTTHRESHOLD option must have been specified.

    正确答案:B

  • 第3题：

    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.

    正确答案:D

  • 第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 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.

    正确答案:E

  • 第5题：

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

    D

    TEST_TBS is a dictionary-managed tablespace

    E

    Threshold values for the TEST_TBS tablespace are not explicitly specified


    正确答案： B
    解析： 暂无解析

  • 第6题：

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


    正确答案： C
    解析： 暂无解析

  • 第7题：

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

    C

     The Enterprise Manager Grid Control is not used

    D

     The STATISTICS_LEVEL parameter is set to BASIC

    E

     The TIMED_STATISTICS parameter is set to FALSE


    正确答案： C
    解析： 暂无解析

  • 第8题：

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


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
    A

    A primary key must have been created.

    B

    A mapping table must have been created.

    C

    An overflow tablespace must have been specified.

    D

    The PCTTHRESHOLD option must have been specified.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
    A

     A primary key must have been created.

    B

     A mapping table must have been created.

    C

     An overflow tablespace must have been specified.

    D

     The PCTTHRESHOLD option must have been specified.


    正确答案： D
    解析： 暂无解析

  • 第11题：

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


    正确答案： A
    解析： 暂无解析

  • 第12题：

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


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:A

  • 第14题：

    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.

    正确答案:A

  • 第15题：

    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 tablespace
    • D、TEST_TBS is a dictionary-managed tablespace
    • E、Threshold values for the TEST_TBS tablespace are not explicitly specified

    正确答案:D

  • 第16题：

    多选题
    You decided to increase the value for the SHARED_SERVERS parameter by using the following command：  SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？；  Which three values can be specified for the SCOPE clause？（）
    A

    ALL

    B

    PFILE

    C

    BOTH

    D

    NONE

    E

    SPFILE

    F

    MEMORY

    G

    INSTANCE

    H

    DATABASE


    正确答案： C,E,F
    解析： 暂无解析

  • 第17题：

    单选题
    While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts？（）
    A

    General

    B

     High Availability

    C

     Space Usage

    D

     Diagnostic Summary


    正确答案： C
    解析： 暂无解析

  • 第18题：

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

    C

    The Enterprise Manager Grid Control is not used.

    D

    The STATISTICS_LEVEL parameter is set to BASIC

    E

    The TIMED_STATISTICS parameter is set to FALSE


    正确答案： C
    解析： 暂无解析

  • 第19题：

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


    正确答案： B
    解析： 可管理性监视器进程(MMON)，可执行各种与可管理性相关的后台任务，
    例如： 
    • 每当给定的度量超过其阈值时发出预警 
    • 通过衍生附加进程（MMON 从属进程）获取快照 
    • 捕获近期已做修改的SQL 对象的统计值

  • 第20题：

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


    正确答案： C
    解析： 暂无解析

  • 第21题：

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

    F

    DBMS_SPACE_ADMIN


    正确答案： C
    解析： 暂无解析

  • 第22题：

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


    正确答案： B
    解析： 暂无解析

  • 第23题：

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

    B

    disable logging attribute 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 metrics for the APPS tablespace


    正确答案： D
    解析： 暂无解析

  • 第24题：

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


    正确答案： A
    解析： 暂无解析

相关内容