Oracle Database Foundations

4.5. Review Questions

1. Rewrite the following expression using the CONCAT function.

   last_name || ', ' || first_name

2. What are two ways that you can indicate a comment in a SQL command?

3. The SQL engine converts the IN operator to a series of ________.

4. Rewrite the following WHERE clause to be case insensitive.

   where job_title like '%Manager%';

5. What is the only group function that counts NULL values in its calculation without using NVL or other special processing?

6. The query results from using aggregate functions with a GROUP BY clause can be filtered or restricted by using what clause?

7. Identify the two special characters used with the LIKE operator and describe what they do.

8. Name two aggregate functions that work only on numeric columns or expressions and ...