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

第2题：

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

第3题：

第4题：

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.

第5题：

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.

第6题：

第7题：

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.

第8题：

第9题：

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

第10题：

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.