OCP 1Z0 053 81

81.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

DBA_TEMP_FREE_SPACE

DBA_TEMP_FREE_SPACE displays temporary space usage information at tablespace level.

ColumnDatatypeNULLDescriptionTABLESPACE_NAMEVARCHAR2(30)NOT NULLName of the tablespaceTABLESPACE_SIZENUMBER Total size of the tablespace, in bytesALLOCATED_SPACENUMBER Total allocated space, in bytes, including space that is currently allocated and used and space that is currently allocated and available for reuseFREE_SPACENUMBER Total free space available, in bytes, including space that is currently allocated and available for reuse and space that is currently unallocated