Which two statements are correct regarding the mytbs tablespace? (Choose two)

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)

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *