Use excel, SQL queries, or any tool you want to use to perform analysis of the dba_audit_trail for your specific users that clearly display the following results:

  • Home / General / Use excel, SQL…

Use excel, SQL queries, or any tool you want to use to perform analysis of the dba_audit_trail for your specific users that clearly display the following results:

  1. (50 points)
    a. How many updates and deletes were performed by each user you created for each
    table. (Hint: A visual display pie chart, bar graph or similar, along with detailed
    descriptions would satisfy this requirement.)
    b. An x,y plot of the times each transaction was completed by each user on the
    Projections2020 table. (Hint: You will have to experiment with this to get a meaningful
    plot.) Be sure to describe and analyze the results.
    c. A sequential list of SQL statements used against the Customers table for each user along
    with the timestamps. Providing these results in a table will satisfy the requirement.