OCP-1Z0-052-V8.02-23题

23. Note 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

Answer: A  

 

如图：Oracle存储模型，逻辑结构在左，物理结构在右。

逻辑结构由大到小

database-->tablespace-->segment-->extent-->oracle data block

 

1、数据库是由多个表空间组成。

sys@TEST0910> desc dba_tablespaces

 

此数据库共有7个表空间。

SQL> select tablespace_name,status,contents,segment_space_management from dba_tablespaces;

 

TABLESPACE_NAME S