nerdexam
Oracle

1Z0-071 · Question #256

You need to display the first names of all customers from the CUSTOMERS table that contain the character e' and have the character a' in the second last position. Which query would give the required…

The correct answer is A. SELECT cust_first_name. See the full explanation below for the reasoning.

Question

You need to display the first names of all customers from the CUSTOMERS table that contain the character e' and have the character a' in the second last position. Which query would give the required output?

Options

  • ASELECT cust_first_name
  • BSELECT cust_first_name
  • CSELECT cust_first_name
  • DSELECT cust_first_name

How the community answered

(20 responses)
  • A
    80% (16)
  • B
    5% (1)
  • C
    5% (1)
  • D
    10% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice