Question Details

1. Question : (TCO 6) Web applications can implement transactions by using methods that _____. initiate a transaction commit the transaction revert the transaction back to the original state of the database All of the above Question 2. Question : (TCO 6) _____ starts the transaction process. Instantiate Transaction Process Transaction Begin Transaction Commit Transaction Question 3. Question : (TCO 6) Validation is done when when you click a button whose _____ property is set to True. InitialSetting CommitTransaction ProcessValidation CausesValidation Question 4. Question : What does the following SQL statement add to the Times table? Insert Into Times (TimesDueDays) Values (500) A row with a value of 500 for the TimesDueDays column 500 rows with a column of TimesDueDays All rows where the TimesDueDays column has a value of 500 A TimesDueDays column with a default value of 500 Question 5. Question : (TCO 6) Which of the following templates are you most likely to use with a DetailsView control? Item EditItem InsertItem All of the above Question 6. Question : (TCO 6) A _____ in a database relates a row from one table to one or more rows from another table. one-to-one relationship one-to-many relationship many-to-many relationship mutually exclusive JOIN Question 7. Question : TCO 6) What button is removed when you click the Edit button for a row in a GridView control? The Update and Cancel buttons are removed. All data are removed. The Delete button is removed. No button is removed. Question 8. Question : (TCO 6) The result set retrieved by the following Select statement contains rows that have _____. Select Balance, Number From Accounts Where Balance < 200 all of the columns from all of the rows in the Accounts table two of the columns from all of the rows in the Account table all of the columns from the Accounts table from all of the rows where Balance is less than 200 two of the columns from the Accounts table from all of the rows where Balance is less than 200 Question 9. Question : (TCO 6) Concurrency occurs when _____. an update or delete operation is refused two or more users retrieve and then try to update data in the same row of a table at the same time an update or delete operation is resubmitted to the database a program checks if a row has changed before updating or deleting ite. xml Question 10. Question : (TCO 6) Which of the following templates are you most likely to use with a DetailsView control? Item EditItem InsertItem All of the above