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
Define atomicity and aggregation.
What is 3nf in dbms?
What is a concurrency problem in dbms?
What is bcnf in the dbms?
How do you create a blank database?
What is service based database?
What is hot backup (in case of oracle)?
What do you understand by fragmentation?
Discuss transparent DBMS?
What do you mean by deadlock dbms?
Mention the types of join?
Can group by and ordered by used in a single query?
What is trigger in dbms?
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping
Why rdbms is not suitable for big data?