The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL; CUSTOMER_NAME VARCHAR2(100) NOT NULL; CUSTOMER_ADDRESS VARCHAR2(150); CUSTOMER_PHONE VARCHAR2(20); You need to produce output that states "Dear Customer customer_name, ". The customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table. Which statement produces this output?
Answer options
A
SELECT 'Dear Customer ' || customer_name || ',' FROM customers;
B
SELECT CONCAT('Dear Customer', customer_name) FROM customers;
C
SELECT 'Dear Customer' + customer_name FROM customers;
D
SELECT customer_name FROM customers;
Correct answer: SELECT 'Dear Customer ' || customer_name || ',' FROM customers;
Explanation
Quick AnswerThe correct answer is SELECT 'Dear Customer ' || customer_name || ',' FROM customers; because it directly addresses the core logic of Database Management.
The || operator concatenates strings in Oracle SQL.