When table fuinfo is initially loaded with 10 million records, the email addresses were not included. You were recently supplied those email addresses and now you need to update those records. What should you do before updating those records?

Questions 12 - 14 are based on the following table definition:

CREATE TABLE fuinfo

(

fid int(10) unsigned NOT NULL,

name varchar(40) NOT NULL,

email varchar(128) NOT NULL,

UNIQUE KEY email (email),

UNIQUE KEY fid (fid)

) ENGINE=MyISAM DEFAULT CHARSET=utf8

a alter table fuinfo drop index email;

b drop index email on fuinfo;

c Both a and b

d Neither a nor b