Exam 1z0-061 topic 4 question 11 discussion

Actual exam question from Oracle's 1z0-061

Question #: 11
Topic #: 4

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?

A. SELECT dear customer, customer_name, FROM customers;
B. SELECT "Dear Customer", customer_name || ', ' FROM customers;
C. SELECT 'Dear Customer ' || customer_name ', ' FROM customers;
D. SELECT 'Dear Customer ' || customer_name || ', ' FROM customers;
E. SELECT "Dear Customer " || customer_name || ", " FROM customers;
F. SELECT 'Dear Customer ' || customer_name || ', ' || FROM customers;

Show Suggested Answer

Suggested Answer: D 🗳️
Concatenation operator to create a resultant column that is a character expression.
Incorrect answer:

A. no such dear customer column -

B. invalid syntax -

C. invalid syntax -

E. invalid syntax -

F. invalid syntax -
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 1-18

by [deleted] at April 4, 2025, 9:19 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!