1z0-071 Exam Question 166

Examine these SQL statements which execute successfully:

Which two statements are true after execution?
  • 1z0-071 Exam Question 167

    Which three actions can you perform only with system privileges? (Choose three.)
  • 1z0-071 Exam Question 168

    View the Exhibit and examine the structure of the CUSTOMERS table.

    Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers.
    Customers with no credit limit should have "Not Available" displayed.
    Which SQL statement would produce the required result?
  • 1z0-071 Exam Question 169

    View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables.

    Evaluate the following MERGE statement:
    MERGE INTO orders_master o USING monthly_orders m ON (o.order_id = m.order_id) WHEN MATCHED THEN UPDATE SET o.order_total = m.order_total DELETE WHERE (m.order_total IS NULL) WHEN NOT MATCHED THEN
    INSERT VALUES (m.order_id, m.order_total);
    What would be the outcome of the above statement?
  • 1z0-071 Exam Question 170

    Which two tasks can be performed by using Oracle SQL statements?