View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables
You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order. Which CREATEVIEW statement would create the views successfully?
A. Option A
B. Option B
C. Option C
D. Option D
|
Download Printable PDF. VALID exam to help you PASS. |
 |
If you use aggregate functions in view, then must use the alias for it. So the answer is C only
A is incorrect because you should mention alias name after group function (count i.line_item_id)
Both A and C would work, only difference is the column header in C is nicer. But that is not mentioned in the question.
You are wrong sir, only C is the answer
ORA-00998: must name this expression with a column alias
00998. 00000 – “must name this expression with a column alias”
http://getyourimage.club/resize-10-may.html