Examine the description of the CUSTOMERS table: Which two SELECT statements will return these results (Choose two.):

Question

Exhibit

Options

• ASELECT customer_name FROM customers WHERE customer_name = `Ma';
• BSELECT customer_name FROM customers WHERE customer_name LIKE `Ma';
• CSELECT customer_name FROM customers WHERE UPPER (customer_name) LIKE `MA*';
• DSELECT customer_name FROM customers WHERE UPPER (customer_name) LIKE `MA%';
• ESELECT customer_name FROM customers WHERE customer_name LIKE `Ma%';
• FSELECT customer_name FROM customers WHERE customer_name LIKE `%a%';
• GSELECT customer_name FROM customers WHERE customer_name LIKE `Ma*';

• A
  2% (1)
• B
  8% (4)
• C
  71% (35)
• E
  4% (2)
• F
  14% (7)

Explanation

You can use the UPPER function to perform a case-insensitive match, as in this condition: UPPER(last_name) LIKE 'SM%' https://docs.oracle.com/cd/B12037_01/server.101/b10759/conditions016.htm

No community discussion yet for this question.