nerdexam
Oracle

1Z0-481 · Question #14

Which statement best describes the record Image that an Extract process stores in the GoldenGate trail by default?

The correct answer is D. An after image for Inserts and updates and a before image for deletes. An after image for inserts and updates and a before image for deletes. According to these guides:1. page 190,GETUPDATEAFTERS/IGNOREUPDATEBEFORES are the DEFAULT values of the parameters which control whether or not the after/before images of updated records are included in the…

Adapters

Question

Which statement best describes the record Image that an Extract process stores in the GoldenGate trail by default?

Options

  • AThe new value for updated fields; the primary key for deleted rows; the after-Image for
  • BAn image of the contents of the record after the insert, update or delete operation
  • CAn after image for inserts and a before image for updates and deletes
  • DAn after image for Inserts and updates and a before image for deletes

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    8% (2)
  • C
    12% (3)
  • D
    77% (20)

Explanation

An after image for inserts and updates and a before image for deletes. According to these guides:1. page 190,GETUPDATEAFTERS/IGNOREUPDATEBEFORES are the DEFAULT values of the parameters which control whether or not the after/before images of updated records are included in the records processed by GoldenGate.2. Oracle GG Fundamentals Student Guide, Version 10.4, page 113, Extract Parameters, Extract Parameter Defaults slide... Only after-image of update

Topics

#GoldenGate trail#record image#after-image#before-image

Community Discussion

No community discussion yet for this question.

Full 1Z0-481 Practice