Become a GOLD Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. Rollback tran
b. Begin tran
c. Rollback tran <save point name>
d. committed
Reveal Answer
Options:
a. Read uncommitted
b. Repeatable read
c. Serializable
d. Read committed
Reveal Answer
Options:
a. The user in session-2 is locked until all the select statements are executed in session-1
b. The user in session-2 does not have to wait until all the select statements in session-2
c. User in session-2 goes into continuous wait even after the user in session-2 releases the lock
d. Rollback cannot be used in explicit transactions
Reveal Answer
Options:
a. Master databases
b. Model databases
c. Tempdb database
d. Msdb database
Reveal Answer
Options:
a. Read committed
b. Read uncommited
c. Serializable
d. Snapshot
Reveal Answer
Options:
a. Snapshot
b. Repeatable read
c. Serializable
d. None
Reveal Answer
Options:
a. Both the update statements get executed successfully
b. First update statement is executed successfully and is committed,but the second update statement fails.
c. Both update statements get executed successfully but are rolled back
d. First update statement is executed successfully and the second update statement fails, but both statements are rolled back
Reveal Answer
Bestdotnet google plus