nerdexam
IBM

C2090-461 · Question #64

When performing a Delete Request against an Oracle Database, you notice that Oracle is not using the Oracle Array Delete capability even though this feature has been enabled. Which two of the…

The correct answer is B. Compare Row Contents is selected in the Delete Request Editor E. The table to be deleted has file attachments. See the full explanation below for the reasoning.

Question

When performing a Delete Request against an Oracle Database, you notice that Oracle is not using the Oracle Array Delete capability even though this feature has been enabled. Which two of the following might be causing this feature to not be used? (Choose two.)

Options

  • ACompare Row Contents is not selected in the Delete Request Editor.
  • BCompare Row Contents is selected in the Delete Request Editor
  • CThe table in the database has a unique primary key, but the table in the file has a non- unique
  • DThe table in the database has a non-unique primary key, but the table in the file has a unique
  • EThe table to be deleted has file attachments.

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    83% (25)
  • C
    3% (1)
  • D
    10% (3)

Community Discussion

No community discussion yet for this question.

Full C2090-461 Practice