Which of the following statements best describe the advantages of using the WITH clause? (Select two.)

Which of the following statements are true in relation to subqueries? (Select three.)

Which of the following statements are true in relation to single row functions? (Select two.)

Analyze the structure of the ORDERS table in the sample below: 

In order to select ORDER_ID and ORDER_DATE for all those orders that were placed after the last order placed by CUSTOMER_ID 101, 

which query will produce the desired result?

Which from the following statements are true about subqueries? (Select two.)

Which from the following statements are true about the execution of the correlated subqueries? (Select two.)

Which from the following statements are true about table joins available in the Oracle Database server? (Select two.)

Examine the data in the PROJ_TASK_DETAILS table in the sample below. 

The PROJ_TASK_DETAILS table is storing information about project tasks and the relation between projects. 

The BASED_ON column is indicating dependencies between tasks. There are tasks which perform with no dependency on other tasks’ completion. 

You have to generate a report which list all task IDs, along the task ID of any other task upon which it depends and the name of the employee in charge of that other task. 

Which from the following queries would produce the desired result? (Select the best option.)