Oracle
1Z0-071 · Question #372
1Z0-071 Question #372: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #372. The question stem and answer options stay visible for context.
Question
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.)
Options
- AStatement 2 may return multiple rows of output.
- BBoth statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
- CStatement 2 returns only one row of output.
- DBoth the statements give the same output.
- EStatement 1 returns only one row of output.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.