Table EMPLOYEEScontains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

Examine the structure of the two tables.

Which two queries execute successfully? (Choose two.)

View the Exhibit and examine the structure of the BOOKStable.

The BOOKS table contains details of 100 books.
Examine the commands executed and their outcome:

Which statement is true?

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

Which statement is true regarding the USINGclause in table joins? (Choose two.)