问题:
ote the following structures in your database server:
1:Extents
2:OS Blocks
3:Tablespace
4:Segments
5:Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest()
A . 2, 5, 1, 4, 3
B . 1, 2, 3, 4, 5
C . 5, 2, 1, 3, 4
D . 2, 1, 5, 4, 3
ote the following structures in your database server:
1:Extents
2:OS Blocks
3:Tablespace
4:Segments
5:Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest()
● 参考解析
Oracle存储模型,逻辑结构在左,物理结构在右。 逻辑结构由大到小database-->tablespace-->segment-->extent-->oracle data block
1、数据库是由多个表空间组成。
2、每个表空间只属于一个数据库,包含一个或多个数据文件,每个数据文件只属于一个表空间,
3、每个段包括一个或多个extents区
4、extent(区),由相邻的数据块的组成。
5、块BLOCK:是数据库中最小的I/O单元,db_block_size