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.
Answer: DE
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e40402/statviews_5062.htm#REFRN23627
sys@TEST1107> SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
------------------------------ --------------- --------------- ----------
TEMP 30408704 30408704 29360128
DBA_TEMP_FREE_SPACE displays temporary space usage information at tablespace level.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the tablespace |
TABLESPACE_SIZE |
NUMBER |
Total size of the tablespace, in bytes | |
ALLOCATED_SPACE |
NUMBER |
Total allocated space, in bytes, including space that is currently allocated and used and space that is currently allocated and available for reuse | |
FREE_SPACE |
NUMBER |
Total free space available, in bytes, including space that is currently allocated and available for reuse and space that is currently unallocated |