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)- A4% (2)
- B76% (37)
- C14% (7)
- D6% (3)
Community Discussion
No community discussion yet for this question.