Examine the data in the COLORStable:

Examine the data in the BRICKStable:

Which two queries return all the rows from COLORS? (Choose two.)

A session's NLS_DATE_FORMAT is set to DD Mon YYYY.
Which two queries return the value 1 Jan 2019?

Which three statements are true about Structured Query Language (SQL)?

Examine the structure of the BOOKS_ TRANSACTIONS table:

Examine the SQL statement:

Which statement is true about the outcome?

Examine the structure of the EMPLOYEEStable.

There is a parent/child relationship between EMPLOYEE_IDand MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_IDis 123.
Which query provides the correct output?