Podcast
Questions and Answers
What is the default item if you have a choice between two or more optional items in the SELECT clause syntax?
What is the default item if you have a choice between two or more optional items in the SELECT clause syntax?
- Ellipsis
- Brackets
- Asterisk
- Pipe (correct)
What is the third technique for specifying the columns for a result set?
What is the third technique for specifying the columns for a result set?
- Coding an expression that uses arithmetic operators (correct)
- Coding a list of column names from the base table
- Coding an asterisk in the SELECT clause
- Coding an expression that uses functions
What should you avoid when coding the SELECT clause?
What should you avoid when coding the SELECT clause?
- Coding an expression that uses functions
- Coding an asterisk to retrieve all the columns (correct)
- Coding a list of column names from the base table
- Coding an expression that uses arithmetic operators