A student is given the following sequence of SQL commands. Assume the syntax of these commands is correct:

CREATE TABLE plant (

plant_num DECIMAL PRIMARY KEY,

plant_species VARCHAR(255) NOT NULL,

plant_common_name VARCHAR(255) NULL

);

INSERT INTO plant VALUES (1, 'Ficus Benjamina', 'Weeping Fig');

INSERT INTO plant VALUES (2, 'Ficus Benjamina', 'Benjamins Fig');

INSERT INTO plant VALUES (3, 'Chamaedorea Seifritzii', 'Bamboo Palm');

The student is requested to delete all rows in the Plant table that have a plant_species value of "Ficus Benjamina". The student uses the following SQL command:

DELETE FROM plant WHERE plant_num = 1;

Select all statements that correctly describe the student's solution.

	a.	This SQL command does not delete any rows in the Plant table which have a plant_species value of "Ficus Benjamina".
	b.	If the WHERE clause in the SQL statement provided by the student were to be replaced with "WHERE plant_species='Ficus Benjamina'", then that SQL command would delete all of the rows in the Plant table which have a plant_species value of "Ficus Benjamina".
	c.	This SQL command deletes row(s) in the Plant table which have a plant_species value of "Chamaedorea Seifritzii".
	d.	This SQL command deletes all of the rows in the Plant table which have a plant_species value of "Ficus Benjamina".
	e.	This SQL command deletes some but not all of the rows in the Plant table which have a plant_species value of "Ficus Benjamina".

View the PRODUCT table below, and follow the subsequent instructions.

Select all SQL statements that will correctly list all the contents from the PRODUCT table.

a.		LIST * FROM PRODUCT
b.		for (Product pr : product) { System.out.println(pr.*); }
c.		SELECT * FROM PRODUCT
d.		GET FROM PRODUCT
e.		SELECT ALL FROM PRODUCT

Product PK Product id Product_desc Brand Size