Oracle OCP试题原创解析（36）

ITAA-OCM · 发表于 2012-2-22 17:41:01

You are creating a locally managed tablespace to meet the following requirements:

All the extents should be of the same size. The data should be spread across two data files.

A bitmap should be used to record the free space within the allocated extents.

Which three options would you choose? (Choose three.)

A) set PCTFREE and PCTUSED to 50

B) specify extent allocation as Uniform

C) specify extent allocation as Automatic

D) create the tablespace as bigfile tablespace

E) create the tablespace as smallfile tablespace

F) set segment space management to Automatic

G) use the RESIZE clause while creating the tablespace

Answer: B,E,F

All the extents should be of the same size,需要区统一管理，选B

The data should be spread across two data files，只有smallfile类型的表空间才能有多个数据文件，所以选E。

A bitmap should be used to record the free space within the allocated extents，要用位图管理，那么需要段空间自动管理（ASSM），选F

haobo1990321 · 发表于 2012-2-29 12:12:33

skn · 发表于 2012-4-11 15:54:18

skn · 发表于 2012-4-11 16:23:51

skn · 发表于 2012-4-11 16:24:26

skn · 发表于 2012-4-11 16:25:46

KOKO2345 · 发表于 2012-5-4 09:43:45

经验啊... 向楼主学习

KOKO2345 · 发表于 2012-5-11 11:12:32

找到好贴不容易，我顶你了，谢了

账号		自动登录	找回密码
密码			论坛注册

[题库] Oracle OCP试题原创解析（36）