Which three statements are true about GLOBAL TEMPORARY TABLES?

Examine the description of the ORDERStable:

Examine the description of the INVOICEStable:

Examine this query:

Which three rows will it return? (Choose three.)

You create a table by using this command:
CREATE TABLE rate_list (rate NUMBER(6,2));
Which two are true about executing statements?

Examine the commands used to create DEPARTMENT_DETAILSand COURSE_DETAILS:

You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses.
Which SQL statement must you use?
SELECT course_id, department_id, FROM department_details d RIGHT OUTER JOIN

Examine the following query:
SQL> SELECT prod_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS ONLY;
What is the output of this query?