nerdexam
Oracle

1Z0-047 · Question #29

Given below is a list of functions and the tasks performed by using these functions, in random order. Function Usage…

The correct answer is D. 1-c,2-a,3-e,4-b,5-d. See the full explanation below for the reasoning.

Question

Given below is a list of functions and the tasks performed by using these functions, in random order. Function Usage --------------- ------------------------------------------------------------------------------------------------------------------------ 1) LPAD a) Used to truncate a column, expression, or value to n decimal places 2) TRUNC b) Used to remove heading or trailing or both characters from the character string 3) DECODE c) Pads the character value right-justified to a total width of n character positions 4) TRIM d) Used to return the numeric value for position of a named character from the character string 5) INSTR e) Used to translate an expression after comparing it with each search value Which option correctly matches the function names with their usage?

Options

  • A1-c,2-b,3-e,4-a,5-d
  • B1-e,2-b,3-c,4-a,5-d
  • C1-e,2-a,3-c,4-d,5-b
  • D1-c,2-a,3-e,4-b,5-d

How the community answered

(44 responses)
  • A
    5% (2)
  • B
    2% (1)
  • C
    9% (4)
  • D
    84% (37)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice