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.
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);

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

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

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

Explanation: