OCP-1Z0-053-V12.02-81题
来源:互联网 发布:数据库备份服务器 编辑:程序博客网 时间:2024/05/15 06:03
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
displays temporary space usage information at tablespace level.
TABLESPACE_NAME
VARCHAR2(30)
NOT NULL
Name of the tablespaceTABLESPACE_SIZE
NUMBER
Total size of the tablespace, in bytesALLOCATED_SPACE
NUMBER
Total allocated space, in bytes, including space that is currently allocated and used and space that is currently allocated and available for reuseFREE_SPACE
NUMBER
Total free space available, in bytes, including space that is currently allocated and available for reuse and space that is currently unallocated- OCP-1Z0-053-V12.02-81题
- OCP-1Z0-053-V12.02-679题
- OCP-1Z0-053-V12.02-591题
- OCP-1Z0-053-V12.02-590题
- OCP-1Z0-053-V12.02-552题
- OCP-1Z0-053-V12.02-551题
- OCP-1Z0-053-V12.02-549题
- OCP-1Z0-053-V12.02-548题
- OCP-1Z0-053-V12.02-234题
- OCP-1Z0-053-V12.02-584题
- OCP-1Z0-053-V12.02-595题
- OCP-1Z0-053-V12.02-184题
- OCP-1Z0-053-V12.02-59题
- OCP-1Z0-053-V12.02-676题
- OCP-1Z0-053-V12.02-667题
- OCP-1Z0-053-V12.02-660题
- OCP-1Z0-053-V12.02-580题
- OCP-1Z0-053-V12.02-323题
- Vector
- (使用STL自带的排序功能进行排序7.3.7)POJ 2726 Holiday Hotel(结构体排序)
- 嵌入式移植mjpg-streamer成功
- ios开发-cocos2d-x适配iphone5
- C++中Xerces解析xml文档
- OCP-1Z0-053-V12.02-81题
- 《汇编语言》王爽——一个奇怪的程序之EBF6
- 编写第一个Windows Mobile程序
- 输入圆的半径,求出该半径的圆的周长和面积并输出
- HashSet
- Excel列合并
- TreeSet
- 输入n及n个整数(n不超过20),输出这n个数的平均值
- char指针与char数组的区别(非常详细!)