In your Oracle 12c database, you plan to execute the command:
SQL> CREATE TABLESPACE tbs1 DATAFILE ‘/u02/oracle/data/tbs01.dbf’ SIZE 50M;
The u02 file system has 1 GB of free space available.
What is the outcome?
A.
It creates a locally managed tablespace with manual segment space management enabled.
B.
It raises an error because extent management is not specified.
C.
It creates a locally managed tablespace with automatic segment space management enabled.
D.
It creates a dictionary-managed tablespace with manual segment space management enabled.
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11359