View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and 'Ausson'. You issue the following query:

SQL> SELECT LOWER(REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM CUSTOMERS WHERE LOWER(cust_last_name) LIKE 'a%n'; What would be the outcome?

Question

View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and 'Ausson'. You issue the following query:

SQL> SELECT LOWER(REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM CUSTOMERS WHERE LOWER(cust_last_name) LIKE 'a%n'; What would be the outcome?

Accepted Answer

B. an error because the TRIM function specified is not valid

Answer

A. 'Oder' and 'Aus'

Answer

C. an error because the LOWER function specified is not valid

Answer

D. an error because the REPLACE function specified is not valid

View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and 'Ausson'. You issue the following query: SQL>…

Question

Options

How the community answered

Community Discussion