Which two statements are true about sequences created in a single instance database? (Choose two.)

1. A. When the MAXVALUE limit for the sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement.
2. B. DELETE <sequencename> would remove a sequence from the database.
3. C. The numbers generated by a sequence can be used only for one table.
4. D. CURRVAL is used to refer to the last sequence number that has been generated.
5. E. When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted.

Correct Answer: AD
References:
http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_2012.htm#SQLRF00817
https://docs.oracle.com/cd/A84870_01/doc/server.816/a76989/ch26.htm

Which three statements are true regarding subqueries? (Choose three.)

1. A. The ORDER BY Clause can be used in a subquery.
2. B. A subquery can be used in the FROM clause of a SELECT statement.
3. C. If a subquery returns NULL, the main query may still return rows.
4. D. A subquery can be placed in a WHERE clause, a GROUP BY clause, or a HAVING clause.
5. E. Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery.

Correct Answer: ABC

Evaluate the following SQL statement:
SQL> select cust_id, cust_last_name "Last name" FROM customers
WHERE country_id = 10 UNION
SELECT cust_id CUST_NO, cust_last_name FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses either one of which can complete the query.

1. A. ORDER BY "Last name"
2. B. ORDER BY 2, cust_id
3. C. ORDER BY CUST_NO
4. D. ORDER BY 2, 1
5. E. ORDER BY "CUST_NO"

Correct Answer: ABD
Using the ORDER BY Clause in Set Operations
-The ORDER BY clause can appear only once at the end of the compound query.
-Component queries cannot have individual ORDER BY clauses.
-The ORDER BY clause recognizes only the columns of the first SELECT query.
-By default, the first column of the first SELECT query is used to sort the output in an ascending order.

Evaluate the following query:
SQL> SELECT TRUNC (ROUND (156.00, -1),-1) FROM DUAL;
What would be the outcome?

1. A. 150
2. B. 200
3. C. 160
4. D. 16
5. E. 100

Correct Answer: C
References:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions135.htm https://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_functions_2127.htm

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

Evaluate the following SQL statement:

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

1. A. It produces an error because subqueries cannot be used with the CASE expression.
2. B. It shows COST_REMARK for all the promos in the promo category ‘TV’.
3. C. It shows COST_REMARK for all the promos in the table.
4. D. It produces an error because the subquery gives an error.

Correct Answer: C