You are working on a database created with the Oracle Database 10g software in which the initialization parameter COMPATIBLE is set to 10.0.0. The hr_tbs tablespace in the database is created as follows:
CREATE TABLESPACE hr_tbs DATAFILE ‘/oracle/oradata/hr_tbs.dbf’ SIZE 50M;
View the Exhibit to see the properties of the database.
Which statement is correct in this scenario?
A.
All the tablespaces in the database must be of the smallfile tablespace type.
B.
hr_tbs is a bigfile tablespace.
C.
The tablespace type bigfile or smallfile must be mentioned in the command.
D.
hr_tbs is a dictionary-managed tablespace.
E.
All the tablespaces in the database will be locally managed by default.