What use is OCP? they did it again!

From the last issue (November/December 2002) of Oracle Magazine, page 134:

" Select two characteristics of locally managed tablespaces:

1. extents are managed by the data dictionary.
2. a bitmap in the datafile keeps track of the free or used status of blocks (sic!) in the datafile.
3. Each segment stored in the tablespace can have a different storage clause.
4. no coalescing is required.
5. UNDO is not generated when allocation or deallocation of extents occurs.

For locally managed tablespaces, the correct answers are B (sic!), D and E. "

Each bit in the 64K bitmap corresponds to one extent in the file, and not, as stated, a single block.

Mario from Rome Received on Wed Nov 20 2002 - 11:29:39 CST