PrepAway - Latest Free Exam Questions & Answers

Tag: Exam 000-551

Exam 000-551: IBM Optim Implementation for Distributed
Systems (2009)

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?


Page 9 of 12« First...7891011...Last »