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…
The correct answer is C. It creates a locally managed tablespace with automatic segment space management enabled. https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11359
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.
How the community answered
(27 responses)- A7% (2)
- B4% (1)
- C89% (24)
Explanation
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11359
Topics
#CREATE TABLESPACE#locally managed tablespace#automatic segment space management#default behavior
Community Discussion
No community discussion yet for this question.