1Z0-042 第42题 local managedictionary manage

Oracle OCA 1Z0-042 第42题质疑

SQL> SELECT * FROM database_properties;

PROPERTY_NAME                 PROPERTY_VALUE
-------------------------------------------------------------------------
DICT.BASE   2
DEFAULT_TEMP_TABLESPACE  TEMP
DEFAULT_PERMANENT_TABLESPACE  USERS
DEFAULT_TBS_TYPE  SMALLFILE
NLS_LANGUAGE  AMERICAN
NLS_TERRITORY  AMERICA
NLS_CURRENCY  S
NLS_TBS_DEFAULT  AMERICA
NLS_NUMERIC_CHARACTERS  
NLS_CHARACTERSET WE8ISO8850P1
NLS_CALENDAR GREGORIAN

You work as a dataase administrator for Certkiller.com. You have two database, SALES and HR; create ion the same machine using Oracle database 10g. For the SALES database, the initialization parameter COMPTIBLE is set to 9.2.0 and for the HR database, COMPATIBLE is set to 10.0.0. The sales_tbs tablespace is create in the SALES database as follows:
CREATE TABLESPACE sales_tbs DATAFILE '/Certkiller/Certkiller data/sales_tbs.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL;
The hr_tbs tablespace created in the HR database is as follows:
CREATE TABLESPACE hr_tbs DATAFILE '/Certkiller/Certkiller data/hr_tbs.dbf' SIZE 50M
Which two statements are correct in this scenario?

A. Hr_tbs is a big file tablespace.
B. A big file tablespace cannot be created in the SALES database
C. All tablespace in HR database will be locally managed by default
D. Sales_tbs and hr_tbs tablespaces can share the same data file.
E. All the tablespaces in the SALES database will be dictionary managed by default.

答案是BE

我记得默认的管理方式应该是local manage而不是dictionary manage
所以觉得答案应该是BC而不是BE,难道是我记错了?
还有个问题是,这里的题目强调了2个数据库间版本的不同,有什么意义吗?

 

正确应该是BC