Oracle Global Human Resources Cloud Implementation Specialist — Question 13

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.)

Answer options

• A. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));
• B. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));
• C. TABLE fin.Sales, FILTER (@RANGE (1, 2));
• D. FILTER (@RANGE (2, 2, AccountID));
• E. FILTER (@RANGE 2, 2, ID);

Correct answer: A, B, C

Explanation

The correct options A, B, and C are valid because they correctly reference the Acct table and use the @RANGE function with valid parameters. Option D is incorrect as it lacks a MAP or TABLE statement for the Acct table, and option E is invalid due to incorrect syntax in the @RANGE function.