"Test" writes an SQL statement using the employees and departments tables under the HR user, (MG connection)

Sql> Select *  fromEmployees D, departments twhered.department_id=t.department_id;106rows selected. ExecutionPlan----------------------------------------------------------PlanHash value:1343509718--------------------------------------------------------------------------------------------|Id|Operation|Name|Rows|Bytes|Cost (%CPU)|Time|--------------------------------------------------------------------------------------------|   0 | SELECTSTATEMENT|             |   106 |  9540 |     6( -)| xx:xx: on ||   1 |MERGEJOIN                  |             |   106 |  9540 |     6( -)| xx:xx: on ||   2 |   TABLEACCESS by INDEXROWID|Departments|     - |   567 |     2(0)| xx:xx: on ||   3 |    INDEX  FullSCAN|Dept_id_pk|     - |       |     1(0)| xx:xx: on ||*  4 |SORTJOIN                  |             |   107 |  7383 |     4( -)| xx:xx: on ||   5 |    TABLEACCESS Full         |EMPLOYEES|   107 |  7383 |     3(0)| xx:xx: on |--------------------------------------------------------------------------------------------predicate information (identified byoperation ID):---------------------------------------------------   4 -Access ("D". " department_id "=" T". " department_id ") filter (" D ".") department_id "=" T". " department_id ")Statistics----------------------------------------------------------          8Recursive calls0db block gets -consistent gets0Physical Reads

"Test" writes an SQL statement using the employees and departments tables under the HR user, (MG connection)