FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 14: Working with Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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

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

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

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

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

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.

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

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.

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

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

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.

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) ____.

The connection string includes ____.

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

In relational databases,data is stored ____.

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.

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.

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