• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/30

Click to flip

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