Quiz

Question 1. 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. _____ starts the transaction process.
Instantiate Transaction
Process Transaction
Begin Transaction
Commit Transaction

Question 3. Validation is done when when you click a button whose _____ property is set to True.
InitialSetting
CommitTransaction
ProcessValidation
CausesValidation

Question 4. 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. Which of the following templates are you most likely to use with a DetailsView control?
Item
EditItem
InsertItem
All of the above

Question 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. 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. 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. 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. Which of the following templates are you most likely to use with a DetailsView control?
Item
EditItem
InsertItem
All of the above.