Oracle
1Z0-062 · Question #260
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 t
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #260. The question stem and answer options stay visible for context.
Managing Database Storage Structures
Question
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?
Options
- AIt creates a locally managed tablespace with manual segment space management enabled.
- BIt raises an error because extent management is not specified.
- CIt creates a locally managed tablespace with automatic segment space management enabled.
- DIt creates a dictionary-managed tablespace with manual segment space management enabled.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#CREATE TABLESPACE#locally managed tablespace#automatic segment space management#default behavior