Grade Details – All Questions
Question 1. Question : (TCO 6) Web applications can implement transactions by using methods that _____.

Student Answer: initiate a transaction

commit the transaction

revert the transaction back to the original state of the database
All of the above

Instructor Explanation: Lecture

Points Received: 3 of 3
Comments:

Question 2. Question : (TCO 6) _____ saves the changes in the database.

Student Answer: Begin Transaction

Commit Transaction

Rollback Transaction

Instantiate Transaction

Instructor Explanation: Lecture

Points Received: 3 of 3
Comments:

Question 3. Question : (TCO 6) If a validation control indicates invalid data, the _____ property of the validator is set to False.

Student Answer: TrueValid

SetValid

IsValid

Visible

Instructor Explanation: Chapter 7, p. 233

Points Received: 3 of 3
Comments:

Question 4. Question : (TCO 6) What does the following SQL statement add to the Times table?
Insert Into Times (TimesDueDays)
Values (90)

Student Answer: 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

Instructor Explanation: Chapter 12, p. 385

Points Received: 3 of 3
Comments:

Question 5. Question : (TCO 6) Which of the following templates are you most likely to use with a DetailsView control?

Student Answer: Item

EditItem

InsertItem

All of the above

Instructor Explanation: Chapter 15, p. 497

Points Received: 3 of 3
Comments:

Question 6. Question : (TCO 6) Which of the following can a Select statement not do?

Student Answer: Modify selected data.

Retrieve data.

Combine data from two tables.

Create calculated fields.

Instructor Explanation: Chapter 12, p. 383

Points Received: 3 of 3
Comments:

Question 7. Question : (TCO 6) What is the Edit button replaced by when you click the Edit button for a row in a GridView control?

Student Answer: Update and Cancel buttons

Delete button

The Edit button is not replaced.

Validation button

Instructor Explanation: Chapter 14, p. 458

Points Received: 3 of 3
Comments:

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 < 0 Student Answer: 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 Instructor Explanation: Chapter 12, p. 381 Points Received: 3 of 3 Comments: Question 9. Question : (TCO 6) When you use the .NET data provider objects to retrieve data from a database, you can store the data in an object called a _____. Student Answer: business class database dataset connection Instructor Explanation: Chapter 12, p. 391 Points Received: 3 of 3 Comments: Question 10. Question : (TCO 6) Which of the following templates are you most likely to use with a DetailsView control? Student Answer: Item EditItem InsertItem All of the above Instructor Explanation: Chapter 15, p. 497 Points Received: 3 of 3 Comments: