Examine the description of the EMP_DETAILS table given below: Exhibit: Which two
statements are true regarding SQL statements that can be executed on the EMP_DETAIL
table? (Choose two.)
A.
You cannot add a new column to the table with LONG as the data type
B.
An EMP_IMAGE column cannot be included in the ORDER BY clause
C.
You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column
D.
An EMP_IMAGE column can be included in the GROUP BY clause
C is also true i try it
C should also be true
http://www.aiotestking.com/oracle/which-two-statements-are-true-regarding-sql-statements-that-can-be-executed-on-the-emp_detail-table-2/
C it is also true
SQL> select * from pr_long order by my_long;
select * from pr_long order by my_long
*
ERRORE alla riga 1:
ORA-00997: Uso non consentito del tipo dati LONG
SQL> select my_long , count(*) from pr_long group by my_long;
select my_long , count(*) from pr_long group by my_long
*
ERRORE alla riga 1:
ORA-00997: Uso non consentito del tipo dati LONG