Question 251
Which two are true about granting object privileges on tables, views, and sequences?
Question 252
Examine these SQL statements which execute successfully:

Which two statements are true after execution?

Which two statements are true after execution?
Question 253
You create a table named 123. Which statement runs successfully?
Question 254
Evaluate the following ALTER TABLEstatement:
ALTER TABLE orders
SET UNUSED (order_date);
Which statement is true?
ALTER TABLE orders
SET UNUSED (order_date);
Which statement is true?
Question 255
View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables.

You are asked to retrieve the ORDER_ID, product_ID, and total price (UNIT_PRICE multiplied by QUANTITY), where the total price is greater than 50,000.
You executed the following SQL statement:
SELECT prder_id, product_id, unit_price*quantity "Total Price"
FROM order_items
WHERE unit_price*quantity > 50000
NATURAL JOIN orders;
Which statement is true regarding the execution of the statement?

You are asked to retrieve the ORDER_ID, product_ID, and total price (UNIT_PRICE multiplied by QUANTITY), where the total price is greater than 50,000.
You executed the following SQL statement:
SELECT prder_id, product_id, unit_price*quantity "Total Price"
FROM order_items
WHERE unit_price*quantity > 50000
NATURAL JOIN orders;
Which statement is true regarding the execution of the statement?
