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
哪两种说法正确地解释输出结果?
已分配空间显示当前分配和使用的空间和可重复使用的空间。
自由空间表示当前分配空间和可重复使用的空间,并且是当前未分配的空间。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2123177/
,如需转载,请注明出处,否则将追究法律责任。