Sams Teach Yourself Transact-SQL in 21 Days, Second Edition

Day 3

Quiz

1:	What function enables you to provide a value for nulls?
A1:	The function you would use to determine whether a column is NULL and then replace it with a value is the ISNULL() function.
2:	What is the result of this query? Use Pubs Select 'My name is '+ au_fname From authors Where au_id = '172-32-1176'
A2:	The first name of the author with this au_id would be appended to the string, "My name is ". The output would be My name is Johnson
3:	What column name is displayed by this query? Use Pubs Select au_fname as 'First Name' From authors
A3:	Answer: The column name that would be displayed is First Name
4:	What would be the result of the following query? Use Pubs Select 'My price is '+ price From titlesWhere title like '%Computer%'
A4:	This ...