The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson. Which query produces output for CUST_LAST_NAME…

Question

Options

• ASELECT REPLACE (TRIM(TRAILING son' FROM cust_last_name), An', `O') FROM customers;
• BSELECT INITCAP (REPLACE(TRIM(son' FROM cust_last_name), An', `O')) FROM customers;
• CSELECT REPLACE (SUBSTR(cust_last_name, -3), An', O') FROM customers;
• DSELECT REPLACE (REPLACE(cust_last_name, son', '), An', O') FROM customers;

• A
  6% (3)
• B
  4% (2)
• C
  15% (7)
• D
  75% (36)

No community discussion yet for this question.