E Correct.
create table a_test
(c1 VARCHAR2(10),
c2 NUMBER(10));
insert into a_test values ('123', 123);
select * from a_test;
commit;
alter table a_test modify c1 VARCHAR2(5);
alter table a_test modify c2 NUMBER(12,2);
desc a_test;
if
alter table a_test modify c1 VARCHAR2(2);
ORA-01441: cannot decrease column length because some value is too big
alter table a_test modify c2 NUMBER(15,2); - worked
BUT
alter table a_test modify c2 NUMBER(15); - don't worked
ORA-01440: column to be modified must be empty to decrease precision or scale
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Thameur01
2 months, 3 weeks agoAyman_Khalifa
9 months, 1 week agozzz02
6 months, 4 weeks agoyaya32
1 year, 2 months agoMcromeo
1 year, 4 months agoWingL
1 year, 9 months agoWingL
1 year, 9 months agozouve
1 year, 9 months agoDarnun
2 years agojfc1
2 years, 2 months ago