Which two statements are correct regarding the mytbs tablespace?

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 TABLESPACE mytbs 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 TABLESPACE mytbs DATAFILE ‘/u1/data/mytbs.dbf’ SIZE 100M;
Which two statements are correct regarding the mytbs tablespace? (Choose two.)

A.
It is asmallfile tablespace.

B.
It is a locally managedtablespace.

C.
It is a dictionary-managedtablespace.

D.
It is a defaultbigfile tablespace.

E.
It is abigfile tablespace (BFT).



Leave a Reply 0

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