What is the outcome?

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?References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11359

Question:

What is the outcome?

Options:

It creates a locally managed tablespace with manual segment space management enabled.

It raises an error because extent management is not specified.

It creates a locally managed tablespace with automatic segment space management enabled.

It creates a dictionary-managed tablespace with manual segment space management enabled.

Correct Answer

The Correct Answer for this Question is

It creates a locally managed tablespace with automatic segment space management enabled.