Related Questions

Which of the following is used to set transaction isolation level? b) –isolation=LEVEL c) –force= d) –truncateTable=
Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
The strictest transaction isolation level provided by SQL Server is called:
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?
A,B,C,D,E,G and I are seven friends who study in three different standards namely 5th, 6th and 7th such that not less than two friends study in the same standard. Each friend also has a different favorite subject namely History, Civics, English, Bangla, Science , Maths , and Economics but not necessarily in the same order. A likes Maths and studies in the 5th standard with only one other friend who likes Bangla. I studies with tow other friends . Both the friends who study with I like languages (Here languages include only Science , English and Bangla ) . D studies in the 6th standard with only one person and does not like Civics . E studies with only one friend . The one who likes history does not study in 5th or 6th standard . E does not like languages. C does not like English , Science or Civics. Which combination represents E's favorite subject and the standard in which he studies?
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?
The state of the data accessed by an aborted transaction must be restored to what it was just before the transaction started executing. This restoration is known as ________ of transaction.
A witness may refresh his memory by referring to any writing made by:
1. Him at the time of the transaction.
2. Him soon afterwards that the court considers the transaction fresh in his memory.
3. Any person
4. Any other person present at the time of transaction.
Select the correct answer:
____________ rolls back a user-specified transaction to the beginning of the transaction.
Which is the most restrictive isolation level in transaction?