First, the script sets the appropriate values of the variables that allow create a general log, to
save a general log in a relational table, and to start recording a general log from now.
(2) Next, the script makes a relational table that contains a general log empty.
(3) Next, the script executes a script file A3Task4.sql. (Do NOT put results of execution of script
A3Task4.sql into a report.)
(4) Next, the script sets the appropriate values of all variables that stop recording a general log
from now.
(5) Next, the script lists the DDL statements (CREATE, ALTER, DROP) processed in a period of
time when a general log was recorded.
(6) Next, the script lists the total number of times each one of DML statements (SELECT, INSERT,
DELETE, UPDATE) processed in a period of time when a general log was recorded. Sort the
results in a descending order of the total number of times a DML statement has been processed.