Which method can you use to change the cell_no value to ‘555-8888’ for John Doe?

Review the definition of the phone_list view. CHEATE OR REPLACE
ALGORITHM=MERGE DEFINER= ‘root’@localhost’ SQL SECURITY DEFINER VIEW
‘phone_list’ AS SELECT e . id as id ‘e . first_name AS ‘first_name’ ‘e . last_name AS
‘last_name’ ‘coalesce ( ph1.phone_no, ‘–‘) AS ‘office_no’ ‘coalesce (ph2 .phone_no, ‘–‘) AS
‘cell_no’ FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND
ph1.type = ‘office’ LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type
= ‘mobile’ The tables employees and employee_phone are InnoDB tables; all columns are
used in this view. The contents of the phone_list view are as follows: Mysql> select * from
phone_list; 1 row in set (0.00 sec) Which method can you use to change the cell_no value
to ‘555-8888’ for John Doe?

A.
INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1,
‘555-8888’,’mobile’);

B.
UPDATE phone_list SET cell_name ‘555-8888’ WHERE first_name= ‘John’ and
last_name= ‘Doe’;

C.
DELETE FROM phone_list WHERE first_name= ‘John’ and last_name= ‘Doe’; INSERT
INTO phone_list (first_name, last_name, office_no, cell_no) VALUES (‘John’ , ‘Doe’ ,
‘x1234’ , ‘555-8888);

D.
UPDATE employee_phone SET phone_no= ‘555-8888’ where emp_id=1;