OCP-1Z0-051-Question Analysis-21st question

21. Examine the description of the EMP_DETAILS table given below:
Name NULL TYPE
EMP_ID NOT NULL NUMBER
EMP_NAME not null VARCHAR2 (40)
EMP_IMAGE LONG
Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table? (Choose two .)
A. An EMP_IMAGE column can be added in the group by clause.
B. An EMP_IMAGE column cannot be encoded in the ORDER BY clause.
C. You cannot add a new column to the table with LONG as the data type.

D. You can alter the table to include the not null constraint on the EMP_IMAGE column.

Answer: BC

Fields of the long type have the following features:
1: The Group By and Order By statements cannot contain long fields.
2: when creating a table using a subquery, fields containing the long type are not copied.
3: constraints cannot be defined for long fields.
4: A table can contain only one long field.


A: The EMP_IMAGE field can be included in the Group By clause (incorrect. The EMP_IMAGE type is long)
B: The EMP_IMAGE field cannot be included in the Order By clause (correct)
C: You cannot add a new field whose data type is long to the table (correct, the table already contains long fields)
D: You can update the table and add the not null constraint to the EMP_IMAGE field (incorrect, long fields cannot add any constraints)