Mr. Pmp

1. In this week's lab, what was the purpose of the line?:

da.fill(ds)

It indicated the SQL Statement to be executed against the table in the database

It loaded the dataset object with the result set

It indicated the provider, path, and name of the database

It displayed the results to the user

2. In this week's lab, if the expression ds.tables(0).rows(0).count evaluates to zero, what does this mean?

The program has encountered an error that causes your program to crash.

There is a row of data in the dataset

There are no tables in the database

There was no data in the database table that met the requirements of the SQL string

3. In which tier of your application does the following line belong?

The user-services layer, because it is used to validate user input

The data services layer, because it provides access to database objects

The button_click event of your Windows Form

All of the above

4. Which of the following is true about the connectionstring property?

It contains a provider and an SQL statement

It contains a provider, an SQL Statement, and a path to the database

It contains a provider, an SQL Statement, a path, and the name of a database

It contains a provider, a path, and the name of the database

5. In which of the following folders do you place your database in a Visual Basic application?

The bin\debug folder

The Solution Folder

The Project Folder

Objects Folder

6. Which of the following is a valid file extension for a Microsoft Access 2007 database?

.mdb

.vb

.accdb

.sln

7. In the LoginData table used in this week's lab, what is the underlying data type of the "autonumber" setting of the logindataID column?

Double

Long Integer

Text

Boolean

8. This week's lab used an if structure which verified the database actually returned data to the dataset object. Which layer of your application was responsible for...