Ch12

Select VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal From Vendors Inner Join Invoices On Vendors.VendorID = Invoices.VendorID Where InvoiceTotal >= 500 Order By VendorName Desc How many columns will the result set have?

4

What does the following SQL statement add to the Terms table? Insert Into Terms (TermsDueDays) Values (90)

A row with a value of 90 for the TermsDueDays column

To execute a command that performs an insert, update, or delete operation, you use the

ExecuteNonQuery method

To execute a command object and store the results in a dataset, you use the

Fill method of a data adapter

To add a row to a table in a database, you use the SQL _______________ statement.

Insert

Which of the following can a Select statement not do?

Modify selected data

You use a _________________ statement to retrieve data from a SQL database.

Select

What is the primary function of a data adapter?

To manage the flow of data between a client program and a database

To modify the data in one row of a table in a database, you use the SQL _______________ statement.

Update

Select VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal From Vendors Inner Join Invoices On Vendors.VendorID = Invoices.VendorID Where InvoiceTotal >= 500 Order By VendorName Desc What table(s) does the data in the result set come from?

Vendors and Invoices

Before you can use a command object to update the data in a database, you must a. set the Connection property of the command object to the connection object you want to use to connect to the database b. set the CommandText property of the command object to the Update statement or the name of the stored procedure that performs the update c. open a connection to the database d. all of the above

all of the above

ADO.NET's disconnected data architecture

allows the database connection to be closed after each operation

Select VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal From Vendors Inner Join Invoices On Vendors.VendorID = Invoices.VendorID Where InvoiceTotal >= 500 Order By VendorName Desc If VendorName contains string data and InvoiceTotal contains decimal values, how will the result set will be ordered?

alphabetically starting with Z

A join that returns records from related tables only if their related fields match is called

an inner join

The fields in a relational database are called

columns

What object does ADO.NET use to store a SQL statement?

command

If you execute a command that contains a Select statement directly rather than using a data adapter, you can use a ____________________ to get the results.

data reader data reader object

The data returned from a query is stored in a data table within a ___________________.

dataset

When you use the .NET data provider objects to retrieve data from a database, you can store the data in an object called a

dataset

What does a relational database use to relate tables in the database to each other?

foreign keys

An inner join combines data from two or more tables in which the related fields _____________.

match are equal are the same

The most common type of relationship between tables in a relational database is a _____________________ relationship.

one-to-many

If a row in one table is related to one or more rows in another table, the tables are said to have a

one-to-many relationship

What type of concurrency does ADO.NET use by default to check whether a row has changed before an update or delete operation is performed?

optimistic

What does a relational database use to uniquely identify each row in a table?

primary keys

The data that's retrieved by a Select statement is called a

result set

Each record in a relational database is called a

row

You can use a data reader to read

the rows in a result set in a forward direction

The result set retrieved by the following Select statement contains rows that have Select Balance, Number From Accounts Where Balance < 0

two of the columns from the Accounts table from all of the rows where Balance is less than 0

Concurrency occurs when

two or more users retrieve and then try to update data in the same row of a table at the same time