Sales data of a company is stored in two tables, SALES1 and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1 table, which are not present in the SALES2 table.
SALES1 table
NameNullType
-----------------------------------------------
SALES_IDNUMBER
STORE_IDNUMBER
ITEMS_IDNUMBER
QUANTITYNUMBER
SALES_DATEDATE
SALES2 table
NameNullType
----------------------------------------------
SALES_IDNUMBER
STORE_IDNUMBER
ITEMS_IDNUMBER
QUANTITYNUMBER
SALES_DATEDATE
Which set operator generates the required output?

View the exhibit and examine the structure and data in the invoice table. (Choose two.)

Which two SQL statements would execute successfully?

You execute this command:
ALTER TABLE employees SET UNUSED(department_id)
Which two are true? (Choose two.)

ユーザーセッションで実行されるSQL文は次のとおりです。

セッションで ROLLBACK TO SAVE POINT コマンドを発行した場合の結果を説明している 2 つのステートメントはどれですか? (2つお選びください。)

Examine the structure of the CUSTOMERS table: (Choose two.)

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?