Oracle Exam 1Z0-447 Topic 9 Question 27 Discussion

Actual exam question for Oracle's 1Z0-447 exam

Question #: 27
Topic #: 9

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

AMAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));

BMAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));

CTABLE fin.Sales, FILTER (@RANGE (1, 2));

DFILTER (@RANGE (2, 2, AccountID));

EFILTER (@RANGE 2, 2, ID);

Show Suggested Answer

Suggested Answer: A, B, C

by Glory at May 08, 2022, 05:25 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!