Which WHERE clause identifies customers that are located in France?

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 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:
Ainvalid use of symbol
Cinvalid use of IS keyword
Dinvalid use of % in condition
Einvalid use of condition
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 2-12



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Bina

Bina

E is the correct answer.

Argha

Argha

Not correct : WHERE lower(country_address) LIKE %france%

it should be => WHERE lower(country_address) LIKE ‘%france%’