You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold…

The correct answer is D. ALTER TABLE commercials. Incorrect Answers A: There is no CHAR2 datatype in Oracle. Also 200 symbols is not enough to store up to 2000 B: There is no CHAR2 datatype in Oracle. There is no ALTER TABLE table_name CHANGE command in Oracle. C: There is no ALTER TABLE table_name CHANGE command in Oracle. E…

Creating and Managing Schema Objects

Question

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?

Options

AALTER TABLE commercials
BALTER TABLE commercials
CALTER TABLE commercials
DALTER TABLE commercials
EYou cannot increase the size of a column if the table has rows.

How the community answered

(70 responses)

A
4% (3)
B
1% (1)
C
9% (6)
D
84% (59)
E
1% (1)

Explanation

Incorrect Answers A: There is no CHAR2 datatype in Oracle. Also 200 symbols is not enough to store up to 2000 B: There is no CHAR2 datatype in Oracle. There is no ALTER TABLE table_name CHANGE command in Oracle. C: There is no ALTER TABLE table_name CHANGE command in Oracle. E: You can increase the size of a column if the table has rows. It can be done with ALTER TABLE table_name MODIFY column.

Topics

#ALTER TABLE#MODIFY column#VARCHAR2#column size increase

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice