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?
  • 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?
  • 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?