Oracle
1Z0-050 · Question #71
Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE…
The correct answer is D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the. See the full explanation below for the reasoning.
Question
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.)
Options
- AFREE_SPACE indicates only the space that is currently unallocated.
- BALLOCATED_SPACE indicates only the space currently allocated and in use.
- CFREE_SPACE indicates only the space that is currently allocated and available for reuse.
- DALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is
- EFREE_SPACE indicates both the space that is currently allocated and available for reuse, and the
How the community answered
(25 responses)- A4% (1)
- B4% (1)
- C8% (2)
- D84% (21)
Community Discussion
No community discussion yet for this question.