Oracle
1Z0-071 · Question #209
Examine the description of the EMP_DETAILS table given below: Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL TABLE?
The correct answer is A. An EMP_IMAGE column cannot be included in the ORDER BY clause. C. You cannot add a new column to the table with LONG as the data type. See the full explanation below for the reasoning.
Question
Examine the description of the EMP_DETAILS table given below:
Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL TABLE?
Options
- AAn EMP_IMAGE column cannot be included in the ORDER BY clause.
- BYou can alter the table to include the NOT NULL constraint on the EMP_IMAGE column.
- CYou cannot add a new column to the table with LONG as the data type.
- DAn EMP_IMAGE column can be included in the GROUP BY clause.
How the community answered
(41 responses)- A71% (29)
- B20% (8)
- D10% (4)
Community Discussion
No community discussion yet for this question.