Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
30 Cards in this Set
- Front
- Back
connection pool
|
A collection of open data connections that Web applications presumed were closed
|
|
data-aware control
|
A control that has the DataSource and DataSourceID properties
|
|
data-bound controls
|
A data-aware control that has been bound to a specific data source
|
|
database connections
|
A logical connection used to retrieve data from a database
|
|
DataSource controls
|
A control capable of reading data as well as changing the data at the source
|
|
LinqDataSource control
|
A control used for the communication between ASP.NET Web pages and the database that can be applied without typing a single line of code. You can opt to haves all code written automatically by ASP.NET
|
|
ObjectDataSource control
|
An object used to move any needed data connections along with any needed Input/Output activities of the database, or any other data source, to a location outside the Web page
|
|
SqlDataSource control
|
A control that enables you to connect and interact with any database supported by ADO.NET
|
|
transaction object
|
An object that allows multiple SQL statements to be processed as a group.
|
|
XmlDataSource control
|
A control that is usually used with a file that provides the rules to decipher XML so that it can handle XML documents
|
|
Which control is designed for separating the Web site from the database code?
LinqDataSource ObjectDataSource XmlDataSource SqlDataSource |
ObjectDataSource
|
|
Which control allows you to connect to ADO.NET but is limited to the query language of the connected database?
LinqDataSource ObjectDataSource XmlDataSource SqlDataSource |
SqlDataSource
|
|
Which control is the latest way to connect to a database?
LinqDataSource ObjectDataSource XmlDataSource SqlDataSource |
LinqDataSource
|
|
Which control is used for hierarchical data?
LinqDataSource ObjectDataSource XmlDataSource SqlDataSource |
XmlDataSource
|
|
What is a data-aware control?
A control that is data-bound Any presentation control Any Web-based control that can be connected to a database A control that has the two required data source properties |
A control that has the two required data source properties
|
|
Which data connection object connects to the fewest database?
.NET oleDB ODBC |
.NET
|
|
Which data connection is the oldest?
.NET OleDB ODBC |
ODBC
|
|
Which data connection is the most universal in the types of its data sources?
|
OleDB
|
|
Which statement is NOT true regarding the connection pool?
The .NET, OleDB, ODBC, and Oracle providers all use the connection pool Connection pools keep connections open longer than normal The connection pool control is found in the Data category of the toolbox There are 100 connections in the default connection pool |
The connection pool control is found in the Data category of the toolbox
|
|
What is the purpose of the transaction object?
It allows SQL statements to be run from the Web page It allows SQL statements to write to the database It gives the Web site the ability to handle financial transactions It is used to tie multiple SQL statements together |
It is used to tie multiple SQL statements together
|
|
The ___ control uses a non-proprietary version of SQL
|
LinqDataSource
|
|
The ___ control provides a way for coding an application retrieve data from a variety of sources without being concerned about the details
|
ObjectDataSource
|
|
The ___ control enables you to connect and interact with any database supported by ADO.NET
|
SqlDataSource
|
|
The XmlDataSource pulls data from the ___ of an XML file
|
attributes or attribute values
|
|
The ___ method of the GridView binds data to the control
|
DataBind()
|
|
A data aware control has the ___ and ___ properties to simplify data binding
|
DataSource
DataSourceID |
|
The ___ is a property of the connection object responsible for providing the object with information such as the driver, server, password, etc.
|
ConnectionString
|
|
The C++ structure ___ is necessary to take advantage of the transaction object
|
trycatch
|
|
The ___ transaction method is called when a transaction fails
|
Rollback()
|
|
A ___ is used to reduce the number of times a data connection opens and closes
|
connection pool
|