CIS 407A WEEK 5 TRANSACTION PROCESSING QUIZ A+ ANSWER

1. (TCO 6) Web applications can implement transactions by using methods that _____. (Points : 3) initiate a transaction commit the transaction revert the transaction back to the original state of the database All of the above Question 2. 2. (TCO 6) _____ starts the transaction process. (Points : 3) Instantiate Transaction Process Transaction Begin Transaction Commit Transaction Question 3. 3. (TCO 6) Validation is done when when you click a button whose _____ property is set to True. (Points : 3) InitialSetting CommitTransaction ProcessValidation CausesValidation Question 4. 4. (TCO 6) What does the following SQL statement add to the Times table? Insert Into Times (TimesDueDays) Values (90) (Points : 3) A row with a value of 90 for the TimesDueDays column 90 rows with a column of TimesDueDays All rows where the TimesDueDays column has a value of 90 A TimesDueDays column with a default value of 90 Question 5. 5. (TCO 6) Which of the following statements about the FormView control is not true? (Points : 3) It can only display one item from a data source at a time. It uses a template to render each item. It uses data binding expressions to display bound data. It restricts how you can lay out the data it displays. Question 6. 6. (TCO 6) Which of the following can a Select statement not do? (Points : 3) Modify selected data. Retrieve data. Combine data from two tables. Create calculated fields. Question 7. 7. (TCO 6) What is the Edit button replaced by when you click the Edit button for a row in a GridView control? (Points : 3) Update and Cancel buttons Delete button The Edit button is not replaced. Validation button Question 8. 8. (TCO 6) The result set retrieved by the following Select statement contains rows that have _____. Select Balance, Number From Accounts Where Balance 0 (Points : 3) 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 0 two of the columns from the Accounts table from all of the rows where Balance is less than 0 Question 9. 9. (TCO 6) Concurrency occurs when _____. (Points : 3) 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. 10. (TCO 6) To control the layout of the data in the templates of a FormView control, it’s common to use _____. (Points : 3) databases CSS fields the layout of data in a template cannot be controlled