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? (Choose two.)

The correct answer is B. You cannot add a new column to the table with LONG as the data type C. An EMP_IMAGE column cannot be included in the ORDER BY clause. LONG Character data in the database character set, up to 2GB. All the functionality of LONG (and more) is provided by CLOB; LONGs should not be used in a modern database, and if your database has any columns of this type they should be converted to CLOB. There can only be one…

Using DDL Statements to Create and Manage Tables

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? (Choose two.)

Options

AAn EMP_IMAGE column can be included in the GROUP BY clause
BYou cannot add a new column to the table with LONG as the data type
CAn EMP_IMAGE column cannot be included in the ORDER BY clause
DYou can alter the table to include the NOT NULL constraint on the EMP_IMAGE column

How the community answered

(62 responses)

A
15% (9)
B
77% (48)
D
8% (5)

Explanation

LONG Character data in the database character set, up to 2GB. All the functionality of LONG (and more) is provided by CLOB; LONGs should not be used in a modern database, and if your database has any columns of this type they should be converted to CLOB. There can only be one LONG column in a table. A LONG column is not copied when a table is created using a subquery. A LONG column cannot be included in a GROUP BY or an ORDER BY clause. Only one LONG column can be used per table. No constraints can be defined on a LONG column. You might want to use a CLOB column rather than a LONG column.

Topics

#LONG data type#GROUP BY restriction#ORDER BY restriction#LOB columns

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice