ExamQuestions.com

Register
Login
Oracle Database 12c Installation and Administration Exam Questions

Oracle

Oracle Database 12c Installation and Administration

163 / 190

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.