First, the script sets the appropriate values of the variables that allow create a general log, to
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Practicing Statistics Guided Investigations For The Second Course
ISBN: 9780321586018
1st Edition
Authors: Shonda Kuiper, Jeff Sklar
Posted Date: