Which two statements are true?

Table ORDER_ITEMS contains columns ORDER_TO, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:

Statement 2:

Which two statements are true? (Choose two.)
A. Statement 2 may return multiple rows of output.
B. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
C. Statement 2 returns only one row of output.
D. Both the statements give the same output.
E. Statement 1 returns only one row of output.

Download Printable PDF. VALID exam to help you PASS.