Question 166
You must create a table EMPLOYEES in which the values in the columns EMPLOYEES_ID and LOGIN_ID must be unique and not null.
Which two SQL statements would create the required table? (Choose two.) CREATE TABLE employees
Which two SQL statements would create the required table? (Choose two.) CREATE TABLE employees
Question 167
View the Exhibit and examine the details of the PRODUCT_INFORMATION table.
You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement:
SELECT product_name, list_price
FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088; Which statement is true regarding the execution of the query?
You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement:
SELECT product_name, list_price
FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088; Which statement is true regarding the execution of the query?
Question 168
View the Exhibit and examine the structure of the CUSTOMERS table.

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?
Question 169
Examine the structure of the SALES table. (Choose two.)

Examine this statement:

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

Examine this statement:

Which two statements are true about the SALES1 table? (Choose two.)
Question 170
Examine the structure of the BOOKS_TRANSACTIONS table:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?
