Oracle 11G OCP 1Z0-053 249

(249)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? (Choose two.)

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.

答案:(D、E)

重复:81

解析:

DBA_TEMP_FREE_SPACE

请使用浏览器的分享功能分享到微信等