Oracle Other Oracle Certification 1Z0-051 Exam

46. You need to extract details of those products in the SALES table where the PROD_ID column contains the string ‘_D123’.

Which WHERE clause could be used in the SELECT statement to get the required output?

A.WHERE prod_id LIKE ‘%_D123%’ ESCAPE ‘_’

B.WHERE prod_id LIKE ‘%\_D123%’ ESCAPE ‘\’

C.WHERE prod_id LIKE ‘%_D123%’ ESCAPE ‘%_’

D.WHERE prod_id LIKE ‘%\_D123%’ ESCAPE ‘\_’

Answer: B

 

47. The PART_CODE column in the SPARES table contains the following list of values:

PART_CODE

———-

A%_WQ123

A%BWQ123

AB_WQ123

Evaluate the following query:

SQL> SELECT part_code

FROM spares

WHERE part_code LIKE ‘%\%_WQ12%’ ESCAPE ‘\’;

Which statement is true regarding the outcome of the above query?

A.It produces an error.

B.It displays all values.

C.It displays only the values A%_WQ123 and AB_WQ123.

D.It displays only the values A%_WQ123 and A%BWQ123.

E.It displays only the values A%BWQ123 and AB_WQ123.

Answer: D

Killtest Practice Exams for 1Z0-051 are written to the highest standards of technical accuracy, provided by our certified subject matter experts and published authors for development.

 

 

Tags:

Leave a Reply