Which of the following column data type changes is permitted?
A)DATE to CHAR
B)VARCHAR2 to CHAR
C)CHAR to NUMBER
D)NUMBER to DATE

Question

Quizplus · Accepted Answer

Changing the data type from VARCHAR2 to CHAR is permitted since both are character data types, but CHAR has a fixed length while VARCHAR2 has a variable length. The other options entail changing data types that are not compatible with each other.

Which of the Following Column Data Type Changes Is Permitted