Which two are true about scalar subquery expressions? (Choose two.)

View the Exhibit and examine PRODUCTS and ORDER_ITEMS tables.

You executed the following query to display PRODUCT_NAME and the number of times the product has been ordered:
SQL>SELECT p.product_name, i.item_cnt
FROM (SELECT product_id, COUNT (*) item_cnt
FROM order_items
GROUP BY product_id) i RIGHT OUTER JOIN products p
ON i.product_id = p.product_id;
What would happen when the above statement is executed?

Which two statements best describe the benefits of using the WITHclause? (Choose two.)

Examine this query:
SELECT 2
FROM DUAL D1
CROSS JOIN DUA d2
CROSSS JOIN DUAL D3
WHERE 2 =3;
What is the result?

The PRODUCT_INFORMATIONtable has a UNIT_PRICEcolumn of data type NUMBER (8, 2).
Evaluate this SQL statement:
SELECT TO_CHAR(unit_price, '$9,999') FROM product_information;
Which two statements are true about the output? (Choose two.)