多选题

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.

正确答案

来源: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:   SQL> CREATE TABLE design_data (id NUMBER, doc CLOB)  LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);   Which statement is true regarding the above command?()  

    单选题查看答案

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

    单选题查看答案