Author Question: For subqueries, which of the following statements is correct? A) Inner queries execute last and ... (Read 45 times)

erika · **on:** Jul 7, 2018

For subqueries, which of the following statements is correct?

A) Inner queries execute last and outer queries execute first
B) Inner queries execute independently of outer queries
C) Inner queries execute at the same time as outer queries
D) Inner queries execute first and outer queries execute last

Question 2

In Oracle, the statement used to display employee and client names together with all of the job
dates, sorted from earliest to latest, would be which one of the following?

A) Select employee.name, client.name, job.date From employee, client, job Order by job.date
B) Select employee.name, client.name, job.date From employee, client, job Where client.email
= employee.ssn And employee.ssn = job.jobid Order by job.date
C) Select employee.name, client.name, job.date From Where client.email = job.email And
employee.ssn = job.ssn Order by job.date
D) Select employee.name, client.name, job.date From employee Inner Join (client Inner Join
job On client.email = job.jobid) On employee.ssn = job.jobid Order by job.date