单选题Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）A It returns space usage of only BasicFile LOB chunks.B It returns space usage of only SecureFile LOB chunks.C It returns both BasicFile an

题目
单选题
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）
A

It returns space usage of only BasicFile LOB chunks.

B

It returns space usage of only SecureFile LOB chunks.

C

It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

D

It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

相似考题

1.Evaluate the following command and its output:Which two statements correctly interpret the output?()A. FREE_SPACE indicates only the space that is currently unallocated.B. ALLOCATED_SPACE indicates only the space currently allocated and in use.C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

2.Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?()A. It returns space usage of only BasicFile LOB chunks.B. It returns space usage of only SecureFile LOB chunks.C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

3.Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE‘;What is the impact of this setting on the usage of SecureFiles?()A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOBB. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOBC. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOBD. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile

4.Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?()A. only encryption and compression settings for all SecureFile LOBsB. only encryption and deduplication settings for only SecureFile CLOBsC. deduplication, encryption, and compression settings for all SecureFile LOBsD. deduplication, encryption, and compression settings only for SecureFile CLOBs

更多“单选题Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）A It returns space usage of only BasicFile LOB chunks.B It returns space usage of only SecureFile LOB chunks.C It returns both BasicFile an”相关问题

  • 第1题：

    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

    正确答案:E

  • 第2题：

    Which statements are true regarding SecureFile LOBs？（） 

    • A、 The amount of undo retained is user controlled.
    • B、 SecureFile LOBs can be used only for nonpartitioned tables.
    • C、 Fragmentation is minimized by using variable-sized chunks dynamically.
    • D、 SecureFile encryption allows for random reads and writes of the encrypted data.
    • E、 It automatically detects duplicate LOB data and conserves space by storing only one copy.

    正确答案:C,D

  • 第3题：

    Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）

    • A、 It returns space usage of only BasicFile LOB chunks.
    • B、 It returns space usage of only SecureFile LOB chunks.
    • C、 It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
    • D、 It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

    正确答案:B

  • 第4题：

    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

  • 第5题：

    Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure？（）  

    • A、 only encryption and compression settings for all SecureFile LOBs
    • B、 only encryption and deduplication settings for only SecureFile CLOBs
    • C、 deduplication，encryption，and compression settings for all SecureFile LOBs
    • D、 deduplication，encryption，and compression settings only for SecureFile CLOBs

    正确答案:C

  • 第6题：

    单选题
    Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）
    A

    It returns space usage of only BasicFile LOB chunks.

    B

    It returns space usage of only SecureFile LOB chunks.

    C

    It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

    D

    It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.


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

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）
    A

     The LOB values are automatically compressed.

    B

     The LOB values are cached by default in the buffer cache.

    C

     The LOB values are automatically stored in encrypted mode.

    D

     All LOB data that is identical in two or more rows in a LOB column share the same data blocks.


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

  • 第9题：

    多选题
    Which statements are true regarding SecureFile LOBs?（）
    A

    The amount of undo retained is user controlled.

    B

    SecureFile LOBs can be used only for nonpartitioned tables.

    C

    Fragmentation is minimized by using variable-sized chunks dynamically.

    D

    SecureFile encryption allows for random reads and writes of the encrypted data.

    E

    It automatically detects duplicate LOB data and conserves space by storing only one copy.


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

  • 第10题：

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


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

  • 第11题：

    单选题
    Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）
    A

     It returns space usage of only BasicFile LOB chunks.

    B

     It returns space usage of only SecureFile LOB chunks.

    C

     It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

    D

     It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.


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

  • 第12题：

    单选题
    Evaluate the following command：   SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’；   What is the impact of this setting on the usage of SecureFiles？（）
    A

     It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB

    B

     It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB

    C

     It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB

    D

     It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile


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

  • 第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题：

    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

  • 第15题：

    Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）  

    • A、 The LOB values are automatically compressed.
    • B、 The LOB values are cached by default in the buffer cache.
    • C、 The LOB values are automatically stored in encrypted mode.
    • D、 All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

    正确答案:D

  • 第16题：

    Evaluate the following command：   SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’；   What is the impact of this setting on the usage of SecureFiles？（）

    • A、 It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB
    • B、 It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB
    • C、 It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
    • D、 It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile

    正确答案:A

  • 第17题：

    多选题
    Evaluate the following command and its output: Which two statements correctly interpret the output?（）
    A

    FREE_SPACE indicates only the space that is currently unallocated.

    B

    ALLOCATED_SPACE indicates only the space currently allocated and in use.

    C

    FREE_SPACE indicates only the space that is currently allocated and available for reuse.

    D

    ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.

    E

    FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.


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

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

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


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

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure？（）
    A

     only encryption and compression settings for all SecureFile LOBs

    B

     only encryption and deduplication settings for only SecureFile CLOBs

    C

     deduplication，encryption，and compression settings for all SecureFile LOBs

    D

     deduplication，encryption，and compression settings only for SecureFile CLOBs


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

  • 第22题：

    单选题
    Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'; What is the impact of this setting on the usage of SecureFiles?（）
    A

    It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB

    B

    It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB

    C

    It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB

    D

    It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile


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

  • 第23题：

    多选题
    Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）
    A

    FREE_SPACE indicates only the space that is currently unallocated.

    B

    ALLOCATED_SPACE indicates only the space currently allocated and in use.

    C

    FREE_SPACE indicates only the space that is currently allocated and available for reuse.

    D

    ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.

    E

    FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.


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

  • 第24题：

    单选题
    Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?（）
    A

    only encryption and compression settings for all SecureFile LOBs

    B

    only encryption and deduplication settings for only SecureFile CLOBs

    C

    deduplication, encryption, and compression settings for all SecureFile LOBs

    D

    deduplication, encryption, and compression settings only for SecureFile CLOBs


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

相关内容