Oracle
1Z0-062 · Question #260
1Z0-062 Question #260: Real Exam Question with Answer & Explanation
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
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.
Explanation
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11359
Community Discussion
No community discussion yet for this question.