Question 28: Which of the statements below are true?

 
Observe the following scenario:
 

create table pktest1(id int);
create table pktest2 like pktest1;
insert into pktest1 values (1),(1),(2),(2),(3),(3),(1);
insert into pktest2 select * from pktest1;

alter table pktest1 add primary key(id);
alter ignore table pktest2 add primary key(id);

 
Which of the statements below are true?
 
(Find all correct answers)
 

a) The ALTER on pktest1 will fail.
b) The ALTER on pktest2 will fail.
c) The ALTER on pktest2 will remove duplicates.
d) The ALTER on pktest1 will remove duplicates.

 
[ Tables and Indexes (15%) - Altering Tables ]