1. The _____________________ of a numeric data type indicates the total number of digits that can be stored in the data type.

2. When you code a subquery in a FROM clause, you must assign a/an ______________________ to it.

3. When you code a subquery in a FROM clause, it returns a result set that can be referred to as an _____________________________ view.

4. A table ___________________ can be used when you want to assign a temporary name to a table.

5. A SELECT statement that includes aggregate functions is often called a/an _____________________________ query.

6. Unless you assign a/an _____________________________, the column name in the result set is the same as the column name in the base table.

7. To convert DATE values to formatted dates, you can use the ______________________ function.

8. With version 12c and above, you can use the ____________ clause to designate a starting row for a result set.

9. All of the aggregate functions ignore null values, except for the ______________________________ function.

10. To model a database on a real-world system, you typically represent each real-world entity as a/an ____________________________.

11. Typically, most database designers consider a database structure normalized if its in the ________________________ normal form.

12. To sort the records that are retrieved by a SELECT statement in descending sequence by invoice_total, you code _____________________ after ORDER BY invoice_total.

13. A view is a/an ______________________________ statement thats stored as an object in the database.

14. If two tables have a one-to-many relationship, you need to add a _______________________ column to the table on the many side.

15. The ____________________ data types can store large, unstructured data such as text, images, sound, and video.

16. Write the code for converting a numeric string value in a column named invoice_number to the NUMBER data type: _________________________________________________________

17 A subquery can be coded in a WHERE, FROM, SELECT, or ______________ clause.

18 Write an aggregate expression for the number of unique values in the vendor_id column: _________________________.