Evaluate the following SQL statement: SELECT product_name || `it`s not available for order` FROM product_information - WHERE product_status = `obsolete`; You received the following error while executing the above query: ERROR - ORA-01756: quoted string not properly terminated What would you do to execute the query successfully? 

Answer options:

A. Remove the single quotation marks enclosing the character literal string in the SELECT clause
B. Use the escape character to negate the single quotation mark within the literal character string in the SELECT clause
C. Enclose the character literal string in the SELECT clause within double quotation marks
D. 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

D

References: http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm