quiz8


 * ADO.NET’s disconnected data architecture
 * allows the database connection to be closed after each operation
 * 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
 * A join that returns records from related tables only if their related fields match is called
 * an inner join
 * 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
 * The most common type of relationship between tables in a relational database is a _____________________ relationship
 * one to many relationship
 * 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 is the primary function of a data adapter?
 * To manage the flow of data between a client program and a database
 * Which of the following can a Select statement not do?
 * Modify selected data
 * The result set retrieved by the following Select statement contains records 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
 * 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