Adapted from: Robert W. Sebasta, Programming the World-Wide Web, 3rd Edition, Addison Wesley, 2006. Supporting: Contact Hour 22.

1. What is the purpose of a third tier in a client/server configuration for Web access to a database?
2. Why are two-tier client/server configurations sometimes inadequate?
3. At the end of this lecture you should be able to answer these questions:
4. Explain how SQL database access can be provided by extending a programming language.
5. What is the disadvantage of embedding SQL in a programming language?
6. What is MySQL?
7. What does the MySQL constraint auto_increment do?
8. What is the problem with quotes in a SQL command obtained from a form element in an XHTML document?
9. What is the purpose of the PHP mysql_select_db function?
10. How can a PHP program determine the number of rows in a query result?
11. What does the PHP function mysql_fetch_array do?
12. Explain the exact form of the value returned by mysql_fetch_array.
13. What is metadata?
14. How is the collection of metadata extracted from a database?
15. How can column labels can be obtained from an object of metadata?

More Review Questions