The PROD_ID column is the foreign key in the SALES table.Which references the PRODUCTS table.
Similarly,the CUST_ID and TIME_ID columns are Also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_sales(prod_id, I cust_id, order_date DEFAULT SYSDATE)
AS SELECT I prod_id,cust_id,time_id FROM sales.
Which statement is true regarding the above command?

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?
SUBTRACT

Examine the data in the ORD_ITEMS table:

Evaluate this query:

Which statement is true regarding the result?

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

Which two WHERE clause conditions demonstrate the correct usage of conversion functions? (Choose two.)

Which two are true about a SQL statement using SET operators such as UNION?