What do you understand by cursor? Mention the different types of cursor?
Answer / Neha Bhoyare
A Cursor is a database object that temporarily stores the result-set of a SELECT statement. It allows the data to be accessed row by row, sequentially or randomly. The two main types of cursors are Implicit and Explicit.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is rank in database?
Can we use a Restricted packaged procedure in WHEN_TEXT_ITEM trigger ?
How to stop superserver service on linux using only firebird tools?
What is the definition of database management system?
what is the location of oracle inventory?
What are procedures in database?
PL/SQL supports which datatypes?
What is metadata in dbms?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
What is a system concept?
What do you mean by starvation in dbms?
How to tell firebird to only accept conections from xyz host or network?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)