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 17
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 17
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 17
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 17
Is Dynamic Cursor sensitive to database changes 
Options:
  1. Yes
  2. No
View Answer/Explanation:
a
Explanation:

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

Question No: 6 of 17
What is the @@cursor_rows value

declarecur_emp_9cursor
static
for
select*fromemployee
opencur_emp_9
print@@cursor_rows
closecur_emp_9
deallocatecur_emp_9 
Options:
  1. The no:of rows in the cursor
  2. -1
  3. The no:0f rows in the actual table 'employee'
  4. -2
View Answer/Explanation:
a
Explanation:

Question No: 7 of 17
BATCH 1:
declarecur_emp13cursor
local
keyset
for
select*fromemployee
opencur_emp13
print@@cursor_rows
closecur_emp13

go
BATCH-2:
opencur_emp13
print@@cursor_rows

Which statement is true for the above batches 
Options:
  1. Batch-1 gives the number of rows in the cursor
  2. Batch-2 opens the cursor successfully as it was not deallocated and gives the number rows in the cursor
  3. In Batch-2 the cursor cannot be opened as the cursor cur_emp13 doesnot exist
  4. In Batch-2 the print @@cursor_rows ouput is 0
View Answer/Explanation:
a c d
Explanation:

Question No: 8 of 17
BATCH-1:
declarecur_emp13cursor
global
keyset
for
select*fromemployee
opencur_emp13
print@@cursor_rows
closecur_emp13

go
BATCH-2:
opencur_emp13
print@@cursor_rows

Which statement is true for the above batches 
Options:
  1. Batch-1 gives the number of rows in the cursor
  2. Batch-2 opens the cursor successfully as it was not deallocated and gives the number rows in the cursor
  3. In Batch-2 the cursor cannot be opened as the cursor cur_emp13 doesnot exist
  4. The cursor cur_emp13 closed in session1 can be opened in another session also, as it is declared as global
View Answer/Explanation:
a b
Explanation:

Question No: 9 of 17
declarecur_employeecursor
dynamicoptimistic
for
selectempname,job,salary,fkdeptnofromemployeewheresalary>20000 forupdateofsalary,fkdeptno 
Options:
  1. After opening the cursor only 'job and 'empname' columns can be updated
  2. After opening the cursor only 'salary' and 'fkdeptno' columns can be updated
  3. After opening the cursor all the columns can be updated
  4. none
View Answer/Explanation:
b
Explanation:

Question No: 10 of 17
Which of the following places lock on other users immediately? 
Options:
  1. OPTIMISTIC
  2. SCROLL_LOCKS
View Answer/Explanation:
b
Explanation:

  1