Oracle 1z1-071 : Oracle Database SQL

Examine the description of the SALES1 table:

SALES2is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1table which are not present in the SALES2 table.
Which set operator generates the required output?

• A. INTERSECT
• B. MINUS
• C. UNION ALL
• D. SUBTRACT
• E. UNION

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

You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.
Which query would produce the desired result?

• A. SELECT order_id
  FROM order_items
  WHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items GROUP BY order_id)
• B. SELECT order_id
  FROM order_items
  WHERE(unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items) GROUP BY order_id;
• C. SELECT order_id
  FROM order_items
  WHERE(unit_price*quantity) = MAX(unit_price*quantity)
  GROUP BY order_id;
• D. SELECT order_id
  FROM order_items
  GROUP BY order_id
  HAVING SUM(unit_price*quantity) = (SELECT MAX(SUM(unit_price*quantity)) FROM order_items GROUP BY order_id);

View the Exhibit and examine the structure of CUSTOMERStable.

Evaluate the following query:

Which statement is true regarding the above query?

• A. It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.
• B. It produces an error because the condition on the CUST_FIRST_NAME column is not valid.
• C. It executes successfully.
• D. It produces an error because the condition on the CUST_CITY column is not valid.

Which two statements are true about the DUAL table? (Choose two.)

• A. It can be used to display only constants or pseudo columns.
• B. It can display multiple rows and columns.
• C. It can display multiple rows but only a single column.
• D. It can be accessed only by the SYS user.
• E. It can be accessed by any user who has the SELECT privilege in any schema.
• F. It consists of a single row and single column of VARCHAR2 data type.

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. (Choose the best answer.)

You executed this UPDATE statement:

Which statement is true regarding the execution?

• A. It would execute and restrict modifications to the columns specified in the SELECT statement.
• B. It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.
• C. It would not execute because two tables cannot be referenced in a single UPDATE statement.
• D. It would not execute because a SELECT statement cannot be used in place of a table name.