Exam 14: Working with Databases

When you place an @ in front of a string,the string becomes a(n)____.

Included as part of the ____________ namespaces are a number of classes that can be used to retrieve,manipulate,and update data in databases.

Select * from memberTable retrieves all records from the memberTable table that do not have any blank fields.

You can use the ____________ to edit or write new SQL statements for each of the SelectCommand,InsertCommand,UpdateCommand,and DeleteCommand's CommandTexts.

Data is stored in tabular format for a relational database.Each row in the table represents a(n)____.

The ADO namespace includes a number of classes that allow you to interact with databases.

The SELECT statement can also be used to retrieve results from multiple tables by joining them using a common field.

In relational databases,data is stored ____.

You use the data adapter object to populate the data reader object.

Typing or inserting an actual SQL query or command as input (as opposed to a requested value,such as a user login name),gaining access to the tables,and then stealing or destroying data is an example of a(n)____.

A copy of an Access database can be stored locally;however,you can not store a local copy of a SQL Server database table.

A Data Source Configuration Wizard is available in Visual Studio to automatically generate the connection string,create dataset and table adapter objects,and bring the data into an application.

A ____ is used to perform a forward-only (sequential)access of the data in the data source while a ____ is used to populate a dataset and updates the database.

The connection string includes ____.

The Data Source Configuration Wizard simplifies connecting your application to a data source by guiding you through the process,automatically generating the connection string,creating dataset and table adapter objects,and bringing the data into your application.

You identify which records and fields you want to retrieve from the database using the SQL ____________ statement.

The OleDbCommand class is used to hold the SQL statements used to access an Oracle database.

The ADO.NET architecture encapsulates the details of differing database structures such as Oracle,as opposed to Access,in the form of ____.

The ____________ provides a visual representation of the dataset and table adapter.It can be used to create and modify data and table adapters and their queries.

For simple read-only access to the database,ADO.NET includes a(n)____________ class that can be used to read rows of data from a database.