OCP-1Z0-053-V12.02-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.

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