Which statements are true regarding the USERS tablespace?

See the Exhibit:
Which statements are true regarding the USERS tablespace? (Choose all that apply.)
Exhibit:

See the Exhibit:

Which statements are true regarding the USERS tablespace? (Choose all that apply.)

A.
A bitmap is used to record free extents

B.
Free extents information is managed within the tablespace

C.
Free extents information is managed in the SYSAUX tablespace

D.
The data dictionary tables are updated when extents are allocated or deallocated



Leave a Reply 3

Your email address will not be published. Required fields are marked *


diana

diana

Why ‘A’ ?

Daniel Orozco

Daniel Orozco

Because after to version 8i, oracle manage free space like a bitmap.

“Prior to Oracle8i, all tablespaces were created as dictionary-managed. Dictionary-managed tablespaces rely on data dictionary tables to track space utilization. Beginning with Oracle8i, you were able to create locally managed tablespaces, which use bitmaps (instead of data dictionary tables) to track used and free space. These locally managed tablespaces provide better performance and greater ease of management.”
http://docs.oracle.com/cd/B10501_01/server.920/a96521/tspaces.htm#636