2023 1 Question TCO 6 Web applications can implement transactions by | Assignment Collections

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