1. The _____________________ of a numeric data type indicates the total number o
ID: 3849249 • Letter: 1
Question
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 it’s 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 that’s 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:
_________________________.
Explanation / Answer
1. TimeStamp
2. alias/Table alias
3. Inline
4. Alias
5. Summary
6. Alias/Column alias
7. TO_CHAR
8. Fetch
9. for Count
10. Table
11. third
12. Desc
13. Select
14. Foreign Key
15. Unstructured
17. Having
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.