Which three are valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column? (Select three.)
A.
MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));
B.
MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));
(Column is an optional parameter in the Range function
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/column_conversion_functions022.htm#GWURF809
)
Then how B will be correct?
nowhere in the question, anything is said about a column "ID".
So if B is correct means SYNTAX correctness is considered, so by this C holds correct.
Seems C is wrong, because of tablename and column ID. Should be D instead
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
wiprooracle
6 months, 3 weeks agoarcan3
1 year, 11 months agoarcan3
1 year, 11 months agoDXan
2 years, 8 months agoDXan
2 years, 8 months agokandid
2 years, 9 months ago