Question 20-1. What makes a relational database different from any other kind of database?
Question 20-2. What’s a primary key?
Question 20-3. What’s a foreign key?
Question 20-4. Imagine a fictitious database for a bookseller. What query would you use to retrieve the contents of the Title
column in the Books
table?
Question 20-5. In the same fictitious database, what query would you use to retrieve the contents of the Author
column where the value in the Publisher
column is “OReilly”?
Question 20-6. Why would you want to use a join?
Question 20-7. What .NET class represents a set of data retrieved from the database?
Question 20-8. What’s the most common way to view the rows in a DataTable
object?
Question 20-9. What’s the purpose of the DataAdapter
class?
Question 20-10. What method of the DataAdapter
class do you use to provide the DataSet
with the retrieved data?