Exam 1z0-082 topic 1 question 89 discussion

D, E is the correct answer

Incorrect segment management clause It lets you specify whether Oracle Database should track the used and free space in the segments in the tablespace using free lists or bitmaps. This clause is not valid for a temporary tablespace. AUTO :Specify AUTO if you want the database to manage the free space of segments in the tablespace using a bitmap. MANUAL :Specify MANUAL if you want the database to manage the free space of segments in the tablespace using free lists E - Correct https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11360 Create a locally managed tablespace by specifying LOCAL in the EXTENT MANAGEMENT clause of the CREATE TABLESPACE statement. This is the default for new permanent tablespaces, D - Correct https://docs.oracle.com/cd/B28359_01/server.111/b28310/create005.htm#ADMIN11105 The most commonly used block size should be picked as the standard block size. In many cases, this is the only block size that you need to specify. Typically, DB_BLOCK_SIZE is set to either 4K or 8K. If you do not set a value for this parameter, the default data block size is operating system specific.

D, E both are by default lol.

B - Incorrect segment management clause It lets you specify whether Oracle Database should track the used and free space in the segments in the tablespace using free lists or bitmaps. This clause is not valid for a temporary tablespace. AUTO :Specify AUTO if you want the database to manage the free space of segments in the tablespace using a bitmap. MANUAL :Specify MANUAL if you want the database to manage the free space of segments in the tablespace using free lists