what does a COMMIT statement do to a CURSOR :

A Open the Cursor
B Fetch the Cursor
C Close the Cursor
D None of these

Correct Answer: None of these

The COMMIT statement releases all row and table locks, and erases any savepoints you marked since the last commit or rollback. Until your changes are committed: You can see the changes when you query the tables you modified, but other users cannot see the changes.
Bissoy MCQ
#তথ্য প্রযুক্তি #সি প্রোগ্রামিং C-Programming #Combined Bank (সমন্বিত ব্যাংক) #Bangladesh Krishi #Investment Corporation of Bangladesh | 30.11.2018 #Rajshahi krishi unnayn #Rupali #Sonali

Related Questions

Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
A Forward only
B Static
C Keyset
D Dynamic
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
A forward only
B static
C keyset
D dynamic
Some commit suicide because they are unable to tolerate ......... changes in their lives though some are born with a ........ to commit suicide.
A unfavourable /sentiment
B adverse /resolution
C catastrophic / tendency
D miserable/ forecast
Which element must reference a resource that can provide an image for the cursor graphic?
A hover
B i
C cursor
D fill
Which of the following property determines how the cursor displays when passed over the affected element?
A mouse
B cursor
C click
D focus
Which of the following refers to a cursor type where changes of any type and from any source are visible?
A Forward only
B Static
C Keyset
D Dynamic
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
A READ_ONLY
B SCROLL_LOCK
C OPTIMISTIC
D READCOMMITTED
Which of the following keys is used to move the cursor to the end of the paragraph.
A }
B {
C |
D $
E None of the above
Which command will be used with vi editor to insert text to left of cursor?
A s
B S
C a
D i
E None of the above
Which command will be used with vi editor to replace text from cursor to right?
A r
B R
C s
D S
E None of the above

Next steps