The CUSTOMERS table has these columns: A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?

The correct answer is B. WHERE lower(country_address) = 'france'. WHERE lower(country_address)='france' Incorrect answer: A invalid use of symbol "" C invalid use of IS keyword D invalid use of % in condition E invalid use of condition

Restricting and Sorting Data

Question

The CUSTOMERS table has these columns:

A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?

Exhibit

Options

AWHERE lower(country_address) = "france"
BWHERE lower(country_address) = 'france'
CWHERE lower(country_address) IS 'france'
DWHERE lower(country_address) = '%france%'
EWHERE lower(country_address) LIKE %france%

How the community answered

(54 responses)

A
6% (3)
B
81% (44)
C
9% (5)
D
2% (1)
E
2% (1)

Explanation

WHERE lower(country_address)='france' Incorrect answer: A invalid use of symbol "" C invalid use of IS keyword D invalid use of % in condition E invalid use of condition

Topics

#LOWER function#string comparison#WHERE clause#single quotes

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice