Oracle Database Foundations

A.4. Chapter 4

1. Rewrite the following expression using the CONCAT function.

   last_name || ', ' || first_name

   Answer: The expression is rewritten as:

   concat(concat(last_name, ', '),first_name)

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

   Answer: You can indicate a comment in a SQL command by using /* and */ or by using --.

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

   Answer: The SQL engine converts the IN operator to a series of OR operations.

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

   where job_title like '%Manager%';

   Answer: Use the UPPER function to convert the job title to uppercase:

   where UPPER(job_title) like '%MANAGER%';

5. What is the only group function that counts NULL values in its calculation ...