← Back to exam page

1z0-071 – Oracle Datbase 12c SQL

Loading demo links...

Showing 13–15 of 15 questions

Question 13

You need to allow user ANDREW to:

1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table.

2. GRANT that permission to other users.

Which statement will do this?

Select an option, then click Submit answer.

  • ○

    GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION;
  • ○

    GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;
  • ○

    GRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION;
  • ○

    GRANT UPDATE (title, address) ON customers TO andrew;
  • ○

    GRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION;
  • ○

    GRANT UPDATE ON customers.title, customers.address TO andrew;
Question 14

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.

Some sales data is duplicated in both tables.

You want to display the rows from the SALES1 table which are not present in the SALES2 table.

Which set operator generates the required output?

Select an option, then click Submit answer.

  • ○

    SUBTRACT
  • ○

    INTERSECT
  • ○

    UNION ALL
  • ○

    UNION
  • ○

    MINUS
Question 15

View the Exhibit and examine PRODUCTS and ORDER_ITEMS tables.

You executed the following query to display PRODUCT_NAME and the number of times the product has been ordered:

SELECT p.product_name, i.item_cnt

FROM (SELECT product_id, COUNT (*) item_cnt

FROM order_items

GROUP BY product_id) i RIGHT OUTER JOIN products p ON i.product_id = p.product_id;

What would happen when the above statement is executed?

Select an option, then click Submit answer.

  • ○

    The statement would execute successfully to produce the required output.
  • ○

    The statement would not execute because inline views and outer joins cannot be used together.
  • ○

    The statement would not execute because the ITEM_CNT alias cannot be displayed in the outer query.
  • ○

    The statement would not execute because the GROUP BY clause cannot be used in the inline.