examine the following sql statement create tablespace userdata datafile u01 oradata..., Oracle 10g, Databases

Test
- Model Test
Index

Question:Examine the following SQL statement:

CREATE TABLESPACE user_data
DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M
LOCALLY MANAGED UNIFORM SIZE 1M
AUTOMATIC SEGMENT SPACE MANAGEMENT;

Which part of the tablespace will be of a uniform size (of 1 MB)?

A Extent 
B Segment 
C Oracle block 
D Operating system block

/46

+ AnswerB

+ Explanationnot sure

+ Report

Descriptive on Oracle 10g Ebook

Total Preview: 695

Question:Examine the following SQL statement: CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size (of 1 MB)?

A Extent

B Segment

C Oracle block

D Operating system block

B