nerdexam
Oracle

1Z0-052 · Question #151

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

The correct answer is A. A bitmap is used to record free extents B. Free extents information is managed within the tablespace. A locally managed tablespace uses a bitmap stored within the tablespace's own data files to track free and used extents, bypassing the data dictionary entirely.

Managing Database Storage Structures

Question

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

Exhibit

1Z0-052 question #151 exhibit

Options

  • AA bitmap is used to record free extents
  • BFree extents information is managed within the tablespace
  • CFree extents information is managed in the SYSAUX tablespace
  • DThe data dictionary tables are updated when extents are allocated or deallocated

How the community answered

(52 responses)
  • A
    90% (47)
  • C
    6% (3)
  • D
    4% (2)

Why each option

A locally managed tablespace uses a bitmap stored within the tablespace's own data files to track free and used extents, bypassing the data dictionary entirely.

AA bitmap is used to record free extentsCorrect

Locally managed tablespaces record free and allocated extents using a bitmap stored in the tablespace's own data file headers, eliminating contention on dictionary tables.

BFree extents information is managed within the tablespaceCorrect

Because the bitmap resides within the tablespace data files themselves, free extent information is self-managed inside the tablespace rather than in any central repository.

CFree extents information is managed in the SYSAUX tablespace

Free extent tracking in a locally managed tablespace resides within the tablespace's own data file headers, not in SYSAUX, which stores auxiliary schema objects such as AWR data and optimizer statistics.

DThe data dictionary tables are updated when extents are allocated or deallocated

Updating data dictionary tables on extent allocation and deallocation is characteristic of dictionary-managed tablespaces; locally managed tablespaces bypass the data dictionary for this purpose entirely.

Concept tested: Locally managed tablespace bitmap extent tracking

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-tablespaces.html

Topics

#locally managed tablespace#bitmap extent management#LMT#free extents

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice