ERPstuff - Oracle EBS Community

You have two database, SALES and HR; created on 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 '/Company/Companydata/sales_tbs.dbf';

The hr_tbs tablespace created in the HR database is as follows:
CREATIVE TABLESPACE hr_tbs DATAFILE '/Company/Companydata/hr_tb s.dbf' SIZE 50M

Which two statements are correct in this scenario?
A. Hr_tbs is a bigfile tablespace.
B. A bigfile tablespace cannot be created in the SALES database
C. All tablespaces 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.

Answer: B, E

for the above question i suspect B,C is the answer. what do u say ?
I think E is not a right option because by default in 9i tablespaces are locally managed. right?

Please do reply ..

<font color="maroon">Apparently B and C are the correct choices. But "C" is also true for SALES db as well that's using LMT as a default.

"E" is not a correct answer, SALES db is by default creating LMT.

Amir
</font id="maroon">