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?
A.
WHERE lower(country_address) = “france”
B.
WHERE lower(country_address) = ‘france’
C.
WHERE lower(country_address) IS ‘france’
D.
WHERE lower(country_address) = ‘%france%’
E.
WHERE lower(country_address) LIKE %france%
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
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 2-12
B