Question 1

In Oracle RDBMS sharding architecture, shardgroups checkpoint their data on a shared disk to ensure data integrity.

Options :

A : FALSE

B : TRUE

Answer: A

Question 2

When should the KeyCols parameter be used?

Options :

A : In addition to the unique index

B : To define a substitute primary key

C : In addition to the primary key

Answer: B

Question 3

You must locate the next good record header in a Logdump file. How should you do this?

Options :

A : Logdump > SCANFORENDTRANS

B : Logdump > SCANFORHEADER

C : Logdump > GHDR ON

D : Logdump > SCANFORGHDR

Answer: B

Question 4

Oracle GoldenGate writes OS-level errors to:

Options :

A : Discard file

B : Process report

C : Event log

D : System log

Answer: D

Question 5

What is a valid net result for an Extract configured with the parameters in this order: GETINSERTS, GETUPDATEBEFORES, IGNOREDELETES, IGNOREUPDATES?

Options :

A : Inserts, updates, and deletes will be captured.

B : Before and after images of updates will be captured.

C : Before and after images of updates will be ignored.

D : Inserts and deletes will be captured.

Answer: C

Higher Test Marks with Free Online 1Z0-947 Exam Practice