What does a COMMIT statement do to a CURSOR?

Answer Posted / sandeep

a commit stmt in cursor will free the memory area(handle)
which is being used by the cursor.

Is This Answer Correct ?    57 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define atomicity and aggregation.

560


What is 3nf in dbms?

495


What is a concurrency problem in dbms?

539


What is bcnf in the dbms?

511


How do you create a blank database?

466






What is service based database?

493


What is hot backup (in case of oracle)?

485


What do you understand by fragmentation?

527


Discuss transparent DBMS?

761


What do you mean by deadlock dbms?

548


Mention the types of join?

493


Can group by and ordered by used in a single query?

539


What is trigger in dbms?

522


how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping

1325


Why rdbms is not suitable for big data?

540