Oracle Exam 1Z0-071 Topic 14 Question 56 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 56
Topic #: 14

Examine these statements:

CREATE TABLE alter_test (c1 VARCHAR2(10), c2 NUMBER(10));

INSERT INTO alter_test VALUES ('123' 123);

COMMIT;

Which is true ahout modifyIng the columns in AITER_TEST?

Ac1 can be changed to NUMBER(10) and c2 can be changed to VARCHAN2 (10).

Bc2 can be changed to NUMBER(5) but c1 cannot be changed to VARCHAN2 (5).

Cc2 can be changed to VARCHAR2(10) but c1 cannot be changed to NUMBER (10).

Dc1 can be changed to NUMBER(10) but c2 cannot be changed to VARCHAN2 (10).

Ec1 can be changed to VARCHAR2(5) and c2 can be changed to NUMBER (12,2).

Show Suggested Answer

Suggested Answer: E

by Hubert at May 06, 2022, 12:53 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!