Which three actions can you perform on an existing table containing data? (Choose three.)

The correct answer is A. Add a new NOT NULL column with a DEFAULT value B. Change the default value of a column F. Increase the width of a numeric column. https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj24513.html

Managing Schema Objects

Question

Options

AAdd a new NOT NULL column with a DEFAULT value
BChange the default value of a column
CChange a DATE column containing data to a NUMBER data type
DAdd a new column as the table's first column
EDefine a default value that is automatically inserted into a column containing nulls
FIncrease the width of a numeric column

How the community answered

(43 responses)

A
72% (31)
C
7% (3)
D
16% (7)
E
5% (2)

Explanation

https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj24513.html

Topics

#ALTER TABLE#column modification#NOT NULL#DEFAULT value

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice