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-managed
files 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 backupsB – 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 C
REF: Oracle(r) Database Administration Guide, 8-3 and 11-1
I used to be suggested this blog by means of my cousin. I’m not certain whether or not this publish is written by means of him as no one else know such detailed approximately my trouble. You’re wonderful! Thanks!|
you are in point of fact a excellent webmaster. The site loading pace is incredible. It seems that you are doing any distinctive trick. In addition, The contents are masterpiece. you’ve performed a fantastic process in this matter!|
If you would like to take much from this paragraph then you have to apply these techniques to your won webpage.|