Using Stored Procedures in Database Interaction - Quiz

(Page 4 of 4 )

1. A namespace organizes classes in a hierarchy of classes to prevent naming conflicts.
   
   a. True
   
   b. False
   
2. You open a connection to a database by using
   
   a. ConnectDB
   
   b. DBConnection 
   
   c. DBConnect
   
   d. None of the above
   
3. The best place to open a connection to a database is
   
   a. The On_Click event handle
   
   b. The Page_Load subroutine
   
   c. In the SQL query
   
   d. In the query
   
4. Which SQL statement specifies the information you want returned to your application?
   
   a. Return
   
   b. Where
   
   c. From
   
   d. Select
   
5. Which SQL statement sets the search criteria for rows that contain information you want returned to your application?
   
   a. Return
   
   b. Where
   
   c. From
   
   d. Select
   
6. What statement identifies the database that contains information you want returned to your application?
   
   a. Where
   
   b. From
   
   c. Select
   
   d. None of the above
   
7. A stored procedure is sent from your web page to the DBMS each time you execute a query.
   
   a. True
   
   b. False
   
8. You cannot pass information to a stored procedure.
   
   a. True
   
   b. False
   
9. Your application cannot determine the number of rows that were returned by the DBMS.
   
   a. True
   
   b. False
   
10. A query parameter is assigned values that visitors enter into a form on your web site.
    
    a. True
    
    b. False

Answers

1. a. True
   
2. d. None of the above. You use the Connection object available for your database type. For SQL Server, it is SqlConnect; for Access, OleDbConect; etc.
   
3. b. The Page_Load subroutine
   
4. d. Select
   
5. b. Where
   
6. d. None of the above
   
7. b. False
   
8. b. False
   
9. b. False
   
10. a. True

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

Comments On: Using Stored Procedures in Database Interaction

· This article is an excerpt from the book "ASP.NET 2.0 DeMYSTiFieD," published by...   >>> Post your comment now!

Buy this book...

This article is excerpted from chapter 10 of ASP.NET 2.0 DeMYSTiFieD, written by Jim Keogh (McGraw-Hill/Osborne; ISBN: 0072261412). Check it out today at your favorite bookstore. Buy this book now.