View Count: 0
Duration: 70 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 5
Which of the following option is true regarding a cursor? 
Options:
  1. A Cursor reads every row one by one.
  2. They can be used to update a set of rows or a single specific row in a resultset
  3. They can be positioned to specific rows.
  4. Cursors lock row(s) while updating them.
View Answer/Explanation:
a b c d
Explanation:

Question No: 2 of 5
Which of the following statement is correct? 
Options:
  1. A cursor cannot be used once it is deallocated
  2. A cursor can be reopened any number of times after it is closed and before it is de allocated
  3. The cursor is populated when FETCH attribute is used
  4. All the above
View Answer/Explanation:
d
Explanation:

Question No: 3 of 5
A KEY SET driven CURSOR is not sensitive to database changes for which DML
statement? 
Options:
  1. UPDATE
  2. DELETE
  3. INSERT
View Answer/Explanation:
c
Explanation:

Question No: 4 of 5
Is Dynamic Cursor sensitive to database changes 
Options:
  1. Yes
  2. No
View Answer/Explanation:
a
Explanation:

Question No: 5 of 5
Is a Static Cursor sensitive to database changes? 
Options:
  1. Yes
  2. No
View Answer/Explanation:
b
Explanation:

  1