Examine the statement:
SQL> CREATE TABLESPACE user_data
2> EXTENT MANAGEMENT LOCAL
3> SEGMENT SPACE MANAGEMENT AUTO;
Which two assumptions must be true for this statement to execute successfully? (choose two)
A.
Oracle Managed Files are used for this instance
B.
The USER_DATA tablespace is managed using FET$/UET$ tables
C.
The database will manage the free space of segments in the tablesapce using a bitmap.
D.
Space within segments in the USER_DATA tablespac is managed with freelists
Explanation:
A – True. No datafile location had been specified, because OMF. Using Oracle-managedfiles simplifies the administration of an Oracle Database. Through initialization parameters, you specify the file system directory to be used for a particular type of file. The database then ensures that a unique file, an Oracle-managed file, is created and deleted when no longer needed. The database internally uses standard file system interfaces to create and delete files as needed for the following database structures:
* Tablespaces
* Redo log files
* Control files
* Archived logs
* Block change tracking files
* Flashback logs
* RMAN backups
B – False. See C
C – True. The clause, MANAGEMENT LOCAL, tells us that tocally managed tablespaces track all extent information in the tablespace itself by using bitmaps, resulting in the following benefits:
* Fast, concurrent space operations. Space allocations and deallocations modify locally managed resources (bitmaps stored in header files).
* Enhanced performance
* Readable standby databases are allowed, because locally managed temporary tablespaces do not generate any undo or redo.
* Space allocation is simplified, because when the AUTOALLOCATE clause is specified, the database automatically selects the appropriate extent size.
* User reliance on the data dictionary is reduced, because the necessary information is stored in file headers and bitmap blocks.
* Coalescing free extents is unnecessary for locally managed tablespaces.
D – False. See CREF.: Oracle(r) Database Administration Guide, 8-3 and 11-1