You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs:
CREATE TABLESAPCE mythbs DATAFILE ‘/u1/data/mytbs.dbf’ SIZE 100M;
Which two statements are correct regarding the mytbs tablespace? (Choose two)
A.
It is a smallfile tablespace.
B.
It is a bigfile tablespace (BFT).
C.
It is a default bigfile tablespace.
D.
It is a locally managed tablespace.
E.
It is a dictionary-managed tablespace.
Explanation:
Specify either SET DEFAULT BIGFILE TABLESPACE or SET DEFAULT SMALLFILE
TABLESPACE. If you omit this clause, the default is a smallfile tablespace, which is the traditional type of Oracle Database tablespace.
Verify also:
SELECT tablespace_name, extent_management, bigfile
FROM dba_tablespaces
WHERE tablespace_name = ‘MYTHBS’;
TABLESPACE_NAME EXTENT_MANAGEMENT BIGFILE
MYTHBS LOCAL NO