View the Exhibit and examine the structure of the PRODUCT_INFORMATIONand INVENTORIEStables.

You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID,and QUANTITY_ON_HANDfor all the products wherein QUANTITY_ON_HANDis less than five.
Which two SQL statements can accomplish the task? (Choose two.)

Evaluate the following two queries:

Which statement is true regarding the above two queries?

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?

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?

View the Exhibit and examine the description of the tables.

You execute this SQL statement:

Which three statements are true?