Which task can be performed by using a single Data Manipulation Language (DML) statement?

Which three are true about granting object privileges on tables, views, and sequences?

Evaluate the following SQL statement:
SELECT product_name || 'it's not available for order'
FROM product_information
WHERE product_status = 'obsolete';
You received the following error while executing the above query:
ERROR
ORA-01756: quoted string not properly terminated
What would you do to execute the query successfully?

View the Exhibit and examine the structure of the PORDUCT_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?

View the Exhibit and examine the structure of the SALES table.

The following query is written to retrieve all those product IDs from the SALEStable that have more than
55000 sold and have been ordered more than 10 items.

Which statement is true regarding this SQL statement?