Oracle
1Z0-071 · Question #427
Examine the data in the EMP table: You execute this query: Why does an error occur?
The correct answer is C. An alias name must not be used in an ORDER BY clause. See the full explanation below for the reasoning.
Question
Examine the data in the EMP table:
You execute this query:
Why does an error occur?
Exhibit
Options
- AAn alias name must not contain space characters.
- BAn alias name must always be specified in quotes.
- CAn alias name must not be used in an ORDER BY clause.
- DAn alias name must not be used in a GROUP BY clause.
How the community answered
(55 responses)- A5% (3)
- B11% (6)
- C82% (45)
- D2% (1)
Community Discussion
No community discussion yet for this question.