nerdexam
Oracle

1Z0-052 · Question #110

The user HR receives the following error while inserting data into the TTK table: ERROR at line 1: ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that…

The correct answer is A. Add a data file to the SMD tablespace. C. Resize the data file associated with the SMD tablespace to make it larger. D. Alter the data file associated with the SMD tablespace to grow automatically. ORA-01653 means a segment cannot extend because the tablespace has no free space; solutions must increase available space in that specific tablespace.

Managing Database Storage Structures

Question

The user HR receives the following error while inserting data into the TTK table:

ERROR at line 1:

ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMD is a small file tablespace. Which three action would allow the user to insert data? (Choose three.)

Options

  • AAdd a data file to the SMD tablespace.
  • BAdd a data file to the temporary tablespace associated with the user HR.
  • CResize the data file associated with the SMD tablespace to make it larger.
  • DAlter the data file associated with the SMD tablespace to grow automatically.
  • EChange the segment space management for the SMD tablespace to automatic.

How the community answered

(34 responses)
  • A
    82% (28)
  • B
    12% (4)
  • E
    6% (2)

Why each option

ORA-01653 means a segment cannot extend because the tablespace has no free space; solutions must increase available space in that specific tablespace.

AAdd a data file to the SMD tablespace.Correct

Adding a new data file directly increases the total capacity of the SMD tablespace, providing the free space needed for the segment extension.

BAdd a data file to the temporary tablespace associated with the user HR.

The temporary tablespace is used for sort and hash join operations, not for storing permanent table segments, so increasing it has no effect on ORA-01653.

CResize the data file associated with the SMD tablespace to make it larger.Correct

Resizing the existing data file to a larger size increases the available space within the SMD tablespace, resolving the extension failure.

DAlter the data file associated with the SMD tablespace to grow automatically.Correct

Setting AUTOEXTEND ON for the data file allows Oracle to automatically grow the file when the tablespace runs out of space, preventing future ORA-01653 errors.

EChange the segment space management for the SMD tablespace to automatic.

Segment space management (MANUAL vs AUTOMATIC) controls how free space within existing extents is tracked using freelists or bitmaps, but does not increase the total capacity of the tablespace.

Concept tested: Resolving tablespace space exhaustion ORA-01653

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

Topics

#ORA-01653#tablespace extension#data file#autoextend

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice