Sales data of a company is stored in two tables, SALES1and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1table, which are not present in the SALES2table.

Which set operator generates the required output?

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

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the description of the EMPLOYEES table.

Evaluate the following SQL statement:
SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) "Review" FROM employees; The query was written to retrieve the FIRST_NAME, EMPLOYEE_ID,and review date for employees. The review date is the firsts Monday after the completion of six months of the hiring. The NLS_TERRITORY parameter is set to AMERICAin the session.
Which statement is true regarding this query?

• A.The query would execute to give the desired output.
• B.The query would not execute because date functions cannot be nested.
• C.The query would execute but the output would give review dates that are Sundays.
• D.The query would not execute because the NEXT_DAYfunction accepts a string as argument.

Comment: *

Name: *

Email: *

Verification: *

The ORDERS table has a primary key constraint on the ORDER_ID column.
The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table.
The constraint is defined with on DELETE CASCADE.
There are rows in the ORDERS table with an ORDER_TOTAL less than 1000.
Which three DELETE statements execute successfully?

• A.DELETE orders WHERE order_total<1000;
• B.DELETE * FROM orders WHERE order_total<1000;
• C.DELETE order_id FROM orders WHERE order_total<1000;
• D.DELETE FROM orders WHERE order_total<1000;
• E.DELETE FROM orders;

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the descriptions of the DEPTand LOCATIONStables.

You want to update the CITYcolumn of the DEPTtable for all the rows with the corresponding value in the CITYcolumn of the LOCATIONStable for each department.
Which SQL statement would you execute to accomplish the task?

• A.UPDATE dept d
  SET city = (SELECT city
  FROM locations l
  WHERE d.location_id = l.location_id);
• B.UPDATE dept d
  SET city = (SELECT city
  FROM locations l)
  WHERE d.location_id = l.location_id;
• C.UPDATE dept d
  SET city = ALL (SELECT city
  FROM locations l
  WHERE d.location_id = l.location_id);
• D.UPDATE dept d
  SET city = ANY (SELECT city
  FROM locations l)

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEEStable:

Examine this query:

Which line produces an error?

• A.Line 5
• B.Line 7
• C.Line 8
• D.Line 3

Comment: *

Name: *

Email: *

Verification: *