View the Exhibit and examine the structure of the PRODUCT_INFORMATION table. (Choose the best answer.)

PRODUCT_ID column is the primary key.
You create an index using this command:
SQL > CREATE INDEX upper_name_idx
ON product_information(UPPER(product_name));
No other indexes exist on the PRODUCT_INFORMATION table.
Which query would use the UPPER_NAME_IDX index?

You must create a table EMPLOYEES in which the values in the columns
EMPLOYEES_ID and LOGIN_ID must be unique and not null. (Choose two.)
Which two SQL statements would create the required table?

Examine this statement which returns the name of each employee and their manager:

You want to extend the query to include managers with no employees. What must you add before join to do this?

View the exhibit and examine the description of the PRODUCT_INFORMATIONtable.

Which SQL statement would retrieve from the table the number of products having LIST_PRICEas NULL?
SELECT COUNT (DISTINCT list_price)

Which three statements are true about multiple row subqueries? (Choose three.)