For subqueries, which of the following statements is correct? ...

[erika]

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

[Athena23]

Answer to Question 1

D

Answer to Question 2

C

[erika]

Thanks for the timely response, appreciate it

[ghepp]

Gracias!