单选题

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.

正确答案

来源:www.examk.com

答案解析

相似试题
  • Evaluate the following statement:   Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?()

    单选题查看答案

  • Evaluate the following statement:   Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?()

    单选题查看答案

  • Evaluate the following SQL statements that are issued in the given order: What would be the status of the foreign key EMP_MGR_FK?()

    单选题查看答案

  • Evaluate the following SQL statements that are issued in the given order:  What would be the status of the foreign key EMP_MGR_FK?()

    单选题查看答案

  • Evaluate the following command:   SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’;   What is the impact of this setting on the usage of SecureFiles?()

    单选题查看答案

  • 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?()

    多选题查看答案

  • 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?()  

    多选题查看答案

  • Evaluate the CREATE TABLE statement:   CREATE TABLE products   (product_id NUMBER (6)  CONSTRAINT prod_id_pk PRIMARY KEY,  product_name VARCHAR2 (15));   Which statement is true regarding the PROD_ID_PK constraint?()

    单选题查看答案

  • Evaluate the SQL statement: What is the result of the statement?()

    单选题查看答案