Live Help (Start Chat)
View Count: 0
Duration: 26 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 42 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

vry nice teaching

Posted By Chandan Kumar on 02-Sep-2017
Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 10
To roll back to some particular point in a transaction we use 
Options:
  1. Rollback tran
  2. Begin tran
  3. Rollback tran
  4. committed
View Answer/Explanation:
c
Explanation:

Question No: 2 of 10
By default the sql server is in _____________ isolation 
Options:
  1. Read uncommitted
  2. Repeatable read
  3. Serializable
  4. Read committed
View Answer/Explanation:
d
Explanation:

Question No: 3 of 10
In a transaction if we get different values for a select statement which retrieves the same row then that concurrency problem is called 
Options:
  1. Dirty read
  2. Non repeatable read
  3. Phantom read
  4. None
View Answer/Explanation:
b
Explanation:

Question No: 4 of 10
Which concurrency model does snapshot use? 
Options:
  1. Optimistic
  2. Pessimistic
View Answer/Explanation:
a
Explanation:

Question No: 5 of 10
session-1:
settransactionisolationlevelsnapshot 
begintran
select*fromtrandemo
select*fromtrandemo
rollbacktran

session-2:
begintran
updatetrandemosetvalue=200
committran


From the above example, state which statement is true 
Options:
  1. The user in session-2 is locked until all the select statements are executed in session-1
  2. The user in session-2 does not have to wait until all the select statements in session-2
  3. User in session-2 goes into continuous wait even after the user in session-2 releases the lock
  4. Rollback cannot be used in explicit transactions
View Answer/Explanation:
b
Explanation:

Question No: 6 of 10
When the isolation level is SNAPSHOT, the qualified records are in ___________ 
Options:
  1. Master databases
  2. Model databases
  3. Tempdb database
  4. Msdb database
View Answer/Explanation:
c
Explanation:

Question No: 7 of 10
Which has the lowest isolation level 
Options:
  1. Read committed
  2. Read uncommited
  3. Serializable
  4. Snapshot
View Answer/Explanation:
b
Explanation:

Question No: 8 of 10
Once snapshot isolation is enabled, updated row versions for each  
transaction are maintained in tempdb. 
Options:
  1. TRUE
  2. FALSE
View Answer/Explanation:
a
Explanation:

Question No: 9 of 10
Which has the highest isolation level 
Options:
  1. Snapshot
  2. Repeatable read
  3. Serializable
  4. None
View Answer/Explanation:
c
Explanation:

Question No: 10 of 10
A table called salary is created with a single row inserted
createtablesalary
(salintcheck(sal>1000)
)
insertintosalaryvalues(3500)

Begin a Transasction:
begintran
begintry
updateemployeesetsalary=salary+3000 wherepkempno=1
updatesalarysetsal=sal-3000 
commit
endtry
begincatch
rollback
endcatch 
Options:
  1. Both the update statements get executed successfully
  2. First update statement is executed successfully and is committed,but the second update statement fails.
  3. Both update statements get executed successfully but are rolled back
  4. First update statement is executed successfully and the second update statement fails, but both statements are rolled back
View Answer/Explanation:
d
Explanation:

  1