AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z1-051





Question ID 4876

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?
 

Option A

A.    WHERE prod_id LIKE '%_D123%' ESCAPE '_'
 

Option B

B.    WHERE prod_id LIKE '%\_D123%' ESCAPE '\'
 

Option C

C.    WHERE prod_id LIKE '%_D123%' ESCAPE '%_'
 

Option D

D.    WHERE prod_id LIKE '%\_D123%' ESCAPE '\_'
 

Correct Answer B
Explanation


Question ID 4877

Which three statements are true about multiple-row sub queries? (Choose three.)
 

Option A

A.    They can contain a sub query within a sub query.
 

Option B

B.    They can return multiple columns as well as rows.
 

Option C

C.    They cannot contain a sub query within a sub query.
 

Option D

D.    They can return only one column but multiple rows.
 

Option E

E.    They can contain group functions and GROUP BY and HAVING clauses.
 

Option F

F.    They can contain group functions and the GROUP BY clause, but not the HAVING clause.
 

Correct Answer A,B,E
Explanation

Send email to admin@getfreedumps for new dumps request!!!