Evaluate the following ALTER TABLEstatement:
ALTER TABLE orders
SET UNUSED (order_date);
Which statement is true?

Which two actions can you perform with object privileges?

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?

View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the PRIMARY KEY in the ORDERS table.

Evaluate the following CREATE TABLE command:
CREATE TABLE new_orders(ord_id, ord_date DEFAULT SYSDATE, cus_id)
AS
SELECT order_id.order_date,customer_id
FROM orders;
Which statement is true regarding the above command?

Examine this SQL statement:

Which two are true?