If database modifications occur while the transaction is still active, the transaction is said to use the ___________technique.

If database modifications occur while the transaction is still active, the transaction is said to use the ___________technique. Correct Answer Immediate-modification

We say a transaction modifies the database if it performs an update on a disk buffer, or on the disk itself; updates to the private part of main memory do not count as database modifications.
Bissoy MCQ

Related Questions

If the database modifications occur while the transaction is still active, the transaction is said to use the __________ modification technique
It is important to use bioinformatics tools to predict sites for posttranslational modifications based on specific protein sequences. However, prediction of such modifications can often be difficult because the short lengths of the sequence motifs associated with certain modifications.
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information.BULK INSERT finance.dbo.customersFROM 'd:bulkaccts143_10142000.txt'WITH DATAFILETYPE = 'char', FIELDTERMINATOR = 't', ROWTERMINATOR = 'n', TABLOCK You want to ensure that response times do not slow when new account information is added to the database. What should you do?
You develop an enterprise application, called XYZApplication that includes a Windows Form presentation layer, middle-tier components for business logic and data access, and a Microsoft SQL Server database.
You are in the process of creating a middle-tier component that will execute the data access routines in your application. When data is passed to this component, the component will call several SQL Server stored procedures to perform database updates. All of these procedure calls run under the control of a single transaction.
The code for the middle-tier component will implement the following objects:
SqlConnection cn = new SqlConnection();
SqlTransaction tr;
If two users try to update the same data concurrently, inconsistencies such as phantom reads will occur. You must now add code to your component to specify the highest possible level of protection against such inconsistencies.
Which code segment should you use?
In the following passage some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of the four alternatives. In view of last year's H1N1 attack and prevailing ________________ weather conditions, the health department officials _______________ that the virus will turn more active by January end. In-charge, Integrated Disease ________________ Programme (IDSP), Dr Shah, said, "Virus is still active, but not in a major way. In coming months, it is likely to become more active. Last year too, virus had claimed lives in January and February. Therefore, we are _____________ as coming months might _________________ a challenge."
In view of last year's H1N1 attack and prevailing ________________
In the following passage some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of the four alternatives. In view of last year's H1N1 attack and prevailing ________________ weather conditions, the health department officials _______________ that the virus will turn more active by January end. In-charge, Integrated Disease ________________ Programme (IDSP), Dr Shah, said, "Virus is still active, but not in a major way. In coming months, it is likely to become more active. Last year too, virus had claimed lives in January and February. Therefore, we are _____________ as coming months might _________________ a challenge."
the health department officials _______________
In the following passage some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of the four alternatives. In view of last year's H1N1 attack and prevailing ________________ weather conditions, the health department officials _______________ that the virus will turn more active by January end. In-charge, Integrated Disease ________________ Programme (IDSP), Dr Shah, said, "Virus is still active, but not in a major way. In coming months, it is likely to become more active. Last year too, virus had claimed lives in January and February. Therefore, we are _____________ as coming months might _________________ a challenge."
In-charge, Integrated Disease ________________ Programme (IDSP)
In the following passage some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of the four alternatives. In view of last year's H1N1 attack and prevailing ________________ weather conditions, the health department officials _______________ that the virus will turn more active by January end. In-charge, Integrated Disease ________________ Programme (IDSP), Dr Shah, said, "Virus is still active, but not in a major way. In coming months, it is likely to become more active. Last year too, virus had claimed lives in January and February. Therefore, we are _____________ as coming months might _________________ a challenge."
Therefore, we are _____________
In the following passage some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of the four alternatives. In view of last year's H1N1 attack and prevailing ________________ weather conditions, the health department officials _______________ that the virus will turn more active by January end. In-charge, Integrated Disease ________________ Programme (IDSP), Dr Shah, said, "Virus is still active, but not in a major way. In coming months, it is likely to become more active. Last year too, virus had claimed lives in January and February. Therefore, we are _____________ as coming months might _________________ a challenge."
coming months might _________________ a challenge."