IBM
C2090-305 · Question #11
A customer table contains a country code column representing the customer's country. There is a corresponding lookup table that captures which country code represents each country (100=Germany…
The correct answer is A. countryname = 'France' AND phone matches_regexp '99.99.99.99.99'. See the full explanation below for the reasoning.
Question
A customer table contains a country code column representing the customer's country. There is a corresponding lookup table that captures which country code represents each country (100=Germany, 101=France. 102=ltaly, and so on). Which rule logic would address a requirement to find all French customers that have a phone number made up often digits?
Options
- Acountryname = 'France' AND phone matches_regexp '99.99.99.99.99'
- Blookup(countryname) = 'France' AND phone matches_regexp '99.99.99.99.99'
- CIF lookup(countryname) = 'France' THEN phone matches_format '99.99.99.99.99'
- DIF lookup(country. countrycodes. countrynames) = 'France' THEN phone matches_format
How the community answered
(24 responses)- A71% (17)
- B4% (1)
- C8% (2)
- D17% (4)
Community Discussion
No community discussion yet for this question.