1z0-071 Exam Question 166

Which three are true about system and object privileges? (Choose three.)
  • 1z0-071 Exam Question 167

    View the Exhibit and examine the structure of ORDERS and CUSTOMERStables.

    There is only one customer with the cust_last_namecolumn having value Roberts. Which INSERT statement should be used to add a row into the ORDERStable for the customer whose CUST_LAST_NAMEis Robertsand CREDIT_LIMITis 600?
  • 1z0-071 Exam Question 168

    View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.

    The PROD_ID column is the foreign key in the SALES table referencing the PRODUCTS table.
    The CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
    Examine this command:
    CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
    AS
    SELECT prod_id, cust_id, time_id
    FROM sales;
    Which statement is true?
  • 1z0-071 Exam Question 169

    Evaluate the following SQL statement:
    SQL> select cust_id, cust_last_name "Last name"
    FROM customers
    WHERE country_id = 10
    UNION
    SELECT cust_id CUST_NO, cust_last_name
    FROM customers
    WHERE country_id = 30
    Identify three ORDERBYclauses either one of which can complete the query.
  • 1z0-071 Exam Question 170

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

    Evaluate the following SQL statement:

    Which statement is true regarding the outcome of the above query?