View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.)

Examine this SQL statement:
SELECT department_id "DEPT_ID", department_name, 'b' FROM
departments
WHERE departments_id=90
UNION
SELECT department_id, department_name DEPT_NAME, 'a' FROM
departments
WHERE department_id=10
Which two ORDER BY clauses can be used to sort the output?

Examine this query:
SELECT INTERVAL '100' MONTH DURATION FROM DUAL;
What will be the output?

View and Exhibit and examine the structure and data in the INVOICE table. (Choose two.) Which two statements are true regarding data type conversion in query expressions?

Which three statements are correct regarding indexes? (Choose three.)

Examine this SQL statement:

Which two are true?