In this assignment, you will use the database you created for Lab Part 5 to write a variety of queries to evaluate using The Oracle Optimizer Explain Plan.
Read this entire document before beginning.
As you complete each task below, answer the questions that follow. Write all answers to the questions on this document.
Objectives:
• Learn about query performance analyzer using Oracle EXPLAIN
• Explore EXPLAIN plans on various query types
Business situation
You decided to analyze the queries you wrote in Lab Parts 5 and 6. Select one or more queries from the previous labs or write new queries that meet the requirements listed below and run an example of each query through EXPLAIN PLAN using SQL Developer.
1 query with at least two fields from single table
1 query with at least one field from 2 or more tables
1 subquery
1 correlated subquery
2 other queries you find interesting
1. For each query, provide the SQL, a description of the query, and an explanation of the EXPLAIN PLAN. Use screenshots to include the results of the EXPLAIN PLAN and any other evaluation tools you used.
2. List at least three resources in APA style that you used to complete the tasks in this assignment.
3. List three things that you learned from this assignment
Attachment:- DDL_and_Queries.zip