Home » Oracle » 1z0-051 » 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%
Correct Answer: B
Explanation/Reference:
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
Download Printable PDF. VALID exam to help you PASS.
|
|