Oracle Exam 1Z0-071 Topic 14 Question 81 Discussion

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

Question #: 81
Topic #: 14

Examine these statements:

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

INSERT INTO alter-test VALUES ('123', 123);

Which is true about modifying the columns in Alter_TEST?

Which is true about modifying the columns in ALTER_TEST?

Ac1 can be changed to varchar2 (5) and c2 can be changed to number (13, 2) .

Bc1 can be changed to number (10) and c2 can he changed to vahchar2 (10) .

Cc2 can be changed to varchar2 (10) but el cannot be changed to number (10).

Dc2 can be changed to number (5) but ci cannot be changed to varchar2 (5) .

Ec2 can be changed to number (10) but c2 cannot be changed to varchab2 (10) .

Show Suggested Answer

Suggested Answer: A

by Kimbery at Oct 23, 2023, 03:38 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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