Question 163:
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?
Answer options:
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.