Question 1

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

Question 2

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 3

What is the purpose of the DiscardFile?

Options :

A : To log failed operations Replicat couldn't process

B : To backup configuration changes

C : To store Replicat cache

D : To discard unused trail files

Answer: A

Question 4

Which valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column?

Options :

A : FILTER (@RANGE (2, 2, AccountID));

B : FILTER (@RANGE 2, 2, ID);

C : TABLE fin.Sales, FILTER (@RANGE (1, 2));

D : MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));

E : MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));

Answer: E

Question 5

What command options specify Extract and Replicat batch mode for initial load?

Options :

A : ADD REPLICAT WITH SPECIALRUN

B : ADD EXTRACT WITH SOURCEISTABLE

C : ADD REPLICAT WITH PASSTHRU

D : ADD EXTRACT WITH TRANLOGOPTIONS

Answer: A,B

Free 1Z0-947 Mock Exam – Practice Online Confidently