Exhibit: 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:hr_tbs is a bigfile tablespace.
B:hr_tbs is a dictionary-managed tablespace.
C:All the tablespaces in the database will be locally managed by default.
D:All the tablespaces in the database must be of the smallfile tablespace type.
E:The tablespace type bigfile or smallfile must be mentioned in the command.
出自:Oracle认证