Examine this list of queries:
1. SELECT ROUND (TRUNC (15, 193, 1)) ''Results'' FROM DUAL;
2. SELECT ROUND (15, 193, 1)) ''Results'' FROM DUAL;
3. SELECT (TRUNC (15, 193, 1)) ''Results'' FROM DUAL;
4. SELECT ROUND (ROUND (15. 193, 1)) ''Results'' FROM DUAL;
Which two statements are true?

Which statement is true regarding the default behaviour of the ORDER by clause?

Examine the structure of the SALES table. (Choose two.)
Examine this statement:
SQL > CREATE TABLE sales1 (prod_id, cust_id, quantity_sold, price)
AS
SELECT product_id, customer_id, quantity_sold, price
FROM sales
WHERE 1 = 2;
Which two statements are true about the SALES1 table?

View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables.

You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.
Which SQL statement would you execute to accomplish the task?

Which two are true about dropping columns from a table? (Choose two.)