Which two statements correctly interpret the output?

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

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.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *