Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 22 of 50

Marks: +1, -0

SELECT product_name || 'it's not available for order' 
 FROM product_information 
 WHERE product_status = 'obsolete';

Remove the single quotation marks enclosing the character literal string in the SELECT clause
Use the escape character to negate the single quotation mark within the literal character string in the SELECT clause
Enclose the character literal string in the SELECT clause within double quotation marks
Use the Oracle (q) operator and delimiter to allow the use of a single quotation mark within the literal character string in the SELECT clause

Go to Question: