QUESTION NO: 450
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.
Answer: D,E
评估下列命令及其输出:
D.分配的空间表明目前已分配和已使用的空间,并且该空间是可重复使用。
E.自由空间表示当前已分配和可重复使用的空间,该空间目前尚未分配。