（含图）
Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers.
Customers with no credit limit should have “Not Available” displayed.
Which SQL statement would produce the required result?

A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

CREATE TABLE
Test_employees (id NUMBER(3),
Name VARCHAR2(20),
Salary NUMBER(7));
Table created.
SQL> CREATE SYNONYM emp FOR test_employees;
Synonym create.
Now examine this command:
Expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp
Which is true?

（含图）
How many rows are retrieved by the last query?

（含图）
You want to extend the query to include employees with no manager.
What must you add before JOIN to do this?

（含图）
In which order are the rows displayed?

（含图）
If LOCALTIMESTAMP was selected at the same time, what would it return?

（含图）
Examine these queries:
1. SELECT prod_name, prod_list

FROM products

WHERE prod_list = ANY (10, 20) AND category_id = 1;

2. SELECT prod_name, prod_list

FROM products

WHERE prod_list IN (10, 20) AND category_id = 1;

3. SELECT prod_name, prod_list

FROM products

WHERE prod_list = ALL (10, 20) AND category_id = 1;
Which queries generate the same output?