Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
INSERT INTO DemoTable VALUES(5,'XYZ','DEMO');
UPDATE DemoTable SET Col3 = 'Test' WHERE TestID = 5;
What is the result of the above code execution?
on 9/27/2013 | Category:
Sql Server Interview questions
| Views: 1638 |
Select from following answers:
The data is rolled back to the transaction starting on line1.
The inserted row does not exist in the table
All of the above.
Even though COMMIT happened in the transaction the prior transaction is ROLLBACKED so the inserted data doesn't exist in the table
Show Correct Answer
Many Interviews |
< Previous :
Which of the following is a best practice to reduc ...
Next > :
Shared locks are not compatible with exclusive loc ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Shared locks are not compatible with exclusive locks. True/False?
What is the result of the below query: SELECT PATINDEX('%NET%' ...
What is the result of the below query: SELECT SUBSTRING('DOTNETFUN ...
By default, which type of index is created for a primary key?
Which of the following is true?
Which of the following are T-SQL ranking functions that can be used fo ...
Which of the following is correct about DELETE and TRUNCATE statements ...
Which of the following is true about Implicit Transactions?
Latest Interview Questions
You have created an assembly that utilizes unmanaged code to access ex ...
You have an application that is used by international clients. All cli ...
Your application uses two threads, named threadOne and threadTwo. You ...
You need to create a method to clear a Queue named q.
You need to write a multicast delegate that accepts a DateTime argumen ...
Differentiate between a page theme and a global theme?
ASP .Net Page class, in which of them would you attach an event handle ...
What is right way to define the routes.MapRoute() method in MVC?