【062新题】OCP 12c 062出现大量新题-15

choose one

In your Oracle 12c database, you plan to execute the command:

SQL> CREATE TABLESPACE tbsl DATAFILE '/u02/oracle/data/tbs0l.dbf' SIZE 50M;

The u02 file system has 1 GB of free space available.

What is the outcome?

A) It raises an error because extent management is not specified.

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

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

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

Answer：B

(解析：从10g开始，创建的表空间默认就是本地管理ASSM的表空间。来自3组：1015267481)