Which three statements are true about sequences in a single instance Oracle database? (Choose three.)
Which statements are true? (Choose all that apply.)
View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.
You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORDERS table.
Which two DELETE statements are valid (Choose two.)
View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.
Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.
SELECT employee_id
FROM employees
WHERE job_id = 'SA_MAN'
-------------------------------------
SELECT employee_id
FROM job_history
WHERE job_id='SA_MAN';
Choose two correct SET operators which would cause the query to return the desired result. (Choose two.)
