Which statement is true regarding the INTERSECT operator?

The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command:
GRANT ALL
ON orders, order_items
TO PUBLIC;
What must be done to fix the statement?

Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.)

View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.
ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option.
Which DELETE statement would execute successfully?

Examine the structure of the DEPARTMENTS table.

You execute the following command:

Which two statements are true?