Which statement is true?

Examine the command:
SQL> CREATE TABLESPACE test1
DATAFILE ‘/u01/app/oracle/oradata/orc1/test01.dbf’ SIZE 5M
AUTOEXTEND ON UNIFORM;
Which statement is true?

Examine the command:
SQL> CREATE TABLESPACE test1
DATAFILE ‘/u01/app/oracle/oradata/orc1/test01.dbf’ SIZE 5M
AUTOEXTEND ON UNIFORM;
Which statement is true?

A.
The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.

B.
The tablespace, TEST1, can contain a maximum of one data file.

C.
Allocated and free extents are tracked using bitmaps.

D.
Segment free space is tracked in the data dictionary.



Leave a Reply 0

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