SAMS Teach Yourself ASP.NET in 24 Hours

Workshop

Quiz

1:	Imagine that you had a database table named Albums that contained the following columns: AlbumID, Name, Artist, and DatePurchased. Write a SQL query to retrieve the Name of the albums, ordered alphabetically.
2:	Write a SQL query to retrieve, in this order, the artist, the name, and the date every album was purchased, ordered alphabetically by the artist.
3:	Write a SQL query that retrieves the names of all of the albums by the artist Nirvana, ordered by the dates the albums were purchased, starting with the most recently purchased.
4:	True or False: The following two SQL queries would return the exact same data: SELECT AlbumID, Name, Artist, DatePurchased FROM Albums and SELECT * FROM Albums
5:	Describe the steps you would take to ...