nerdexam
IBM

C2090-461 · Question #19

A table contains two columns, CUSTNAME and STATE. You have created the following character expression to mask CUSTNAME: SUBSTR(CUSTNAME,1,3) CONCAT 'EE' + SUBSTR(STATE,1) || SUBSTR(CUSTNAME,5,2)…

The correct answer is B. SANEEGER. See the full explanation below for the reasoning.

Question

A table contains two columns, CUSTNAME and STATE. You have created the following character expression to mask CUSTNAME:

SUBSTR(CUSTNAME,1,3) CONCAT 'EE' + SUBSTR(STATE,1) || SUBSTR(CUSTNAME,5,2) Given the values shown below for CUSTNAME and STATE:

CUSTNAME=SANDERS STATE=GA What reflects the value of CUSTNAME after the character expression has been applied?

Options

  • AANDEEARS
  • BSANEEGER
  • CANDEEGER
  • DSANEEAER

How the community answered

(49 responses)
  • A
    4% (2)
  • B
    76% (37)
  • C
    14% (7)
  • D
    6% (3)

Community Discussion

No community discussion yet for this question.

Full C2090-461 Practice