||Which function capitalizes the first letter of a character string and makes the rest lowercase?|
||Which functions are also known by the name group functions?|
||Group functions and aggregate functions are the same thing.|
||Will this query work?|
SQL> SELECT COUNT(LASTNAME) FROM CHARACTERS;
||Yes, it will return the total of rows.|
||How about this one?|
SQL> SELECT SUM(LASTNAME) FROM CHARACTERS;
||No, the query won't work because LASTNAME is a character field.|
||Assuming that they are separate columns, which function(s) would splice FIRSTNAME and LASTNAME together?|
||The CONCAT function and the || symbol.|
||What does the answer 6 mean from the following SELECT?|
SQL> SELECT COUNT(*) FROM TEAMSTATS;
||6 is ...|
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.