Review

Review

The following questions are intended to reinforce key concepts and information presented in this chapter. If you are unable to answer a question, return to the appropriate lesson and review, then try the question again. Answers to the questions can be found in Appendix A.



  1. What are the major components of a data provider, and what function does each fulfill?

  2. Briefly contrast connected and disconnected data access in ADO.NET.

  3. What are the four major parts of a SQL SELECT statement? Briefly describe each one.

  4. In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are SQL statements executed?

  5. What are the three possible settings for the CommandType property of a SqlCommand object or an OleDbCommand object, and what does each mean?

  6. How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database using ADO.NET?

  7. Briefly discuss the advantages and disadvantages of using typed DataSet objects.

  8. How can you manage data currency on a form with several bound controls?

  9. Describe how to use a DataView to filter or sort data.

  10. Briefly describe an XmlDataDocument and how it relates to a DataSet.

  11. What is meant by a SQL injection attack? How can you prevent one from occurring in your application?

  12. How can you read XML data into a Dataset? How would you write data in a Dataset to an XML file? How would you retrieve a string representation of the XML contained within a Dataset? Describe each in general terms.



MCAD(s)MCSD Self-Paced Training Kit(c) Developing Windows-Based Applications With Microsoft Visual Basic. Net a[.  .. ]0-316
MCAD(s)MCSD Self-Paced Training Kit(c) Developing Windows-Based Applications With Microsoft Visual Basic. Net a[. .. ]0-316
ISBN: 735619263
EAN: N/A
Year: 2003
Pages: 110

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net