Oracle11g SQL Fundamentals I:1ZO-051

Which expressions do not return NULL values? (Choose all that apply.)

A. select ((10 + 20) * 50) + null from dual;

B. select 'this is a '||null||'test with nulls' from dual;

C. select null/0 from dual;

D. select null||'test'||null as “Test” from dual;

A and C return null values because any arithmetic expression that involves a null will return a null.

click here to Post your comments and suggestions regarding this page.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License