Which two statement are true regarding table joins available in the Oracle Database server? (Choose two.)

Sales data of a company is stored in two tables, SALES1 and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1 table, which are not present in the SALES2 table.

Which set operator generates the required output?

The following are the steps for a correlated subquery, listed in random order:
* The WHERE clause of the outer query is evaluated.
* The candidate row is fetched from the table specified in the outer query.
* This is repeated for the subsequent rows of the table, till all the rows are processed.
* Rows are returned by the inner query, after being evaluated with the value from the candidate row in the outer query.
Which is the correct sequence in which the Oracle server evaluates a correlated subquery?

Examine the description of the PROMTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used?

View the Exhibit and examine the structure of the PRODUCTS table.

You must display the category with the maximum number of items.
You issue this query:

What is the result?