1. Compare and explain the difference between the two statements.

Statement 1:

CREATE PROCEDURE add_student_procedure

AS

INSERT INTO StudentTest VALUES ('2','Peter', 'Samuel', 'Male')

Statement 2:

CREATE PROCEDURE insert_student_procedure

AS

EXECUTE add_student_procedure

2. Compare and explain the difference between the two statements.

Statement 1:

CREATE PROCEDURE Insert_data

AS

INSERT INTO StudentTest VALUES ('500', 'John', 'Dhlamini', 'Male')

EXECUTE Insert_data

Statement 2:

BEGIN

INSERT INTO StudentTest VALUES ('500', 'John', 'Gallert', 'Male')

END