IBM Exam Questions

What reflects the value of CUSTNAME after the character expression has been applied?

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?

A.
ANDEEARS

B.
SANEEGER

C.
ANDEEGER

D.
SANEEAER