nerdexam
IBM

A2090-614 · Question #32

When will the existing data for a new partition be visible to applications querying a range- partitioned table?

The correct answer is D. After the ALTER TABLE ... ATTACH and SET INTEGRITY statements are executed. See the full explanation below for the reasoning.

Question

When will the existing data for a new partition be visible to applications querying a range- partitioned table?

Options

  • AAfter the ALTER TABLE ... ADD statement is executed.
  • BAfter the ALTER TABLE ... ATTACH statement is executed.
  • CAfter the ALTER TABLE ... ADD and SET INTEGRITY statements are executed.
  • DAfter the ALTER TABLE ... ATTACH and SET INTEGRITY statements are executed.

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    9% (3)
  • C
    6% (2)
  • D
    81% (26)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full A2090-614 Practice