Explain why a transaction may have many cursors

Reference no: EM131259259

1. Explain the term cursor.

2. Explain why a transaction may have many cursors. Also, how is it possible that a transaction may have more than one cursor on a given table?

3. What is the advantage of using different types of cursors?

4. Explain forward-only cursors. Give an example of their use.

Reference no: EM131259259

Questions Cloud

Explain the importance of situating a society cultural : Describe what sort of emotion is generated by listening to the works of your selected composer; in other words, what do you want your uncle to "feel" as he hears the music, and why is this composer so perfect for this composition?

Define the terms rollback and rollforward : Explain how a database could be recovered via reprocessing. Why is this generally not feasible?

Advantages and disadvantages of dbms-provided security : Explain the necessity of defining processing rights and responsibilities. How are such responsibilities enforced?

Write objective function that describes total weekly profit : Let x = the number of part A produced in a week and y = the number of part B produced in a week. Write the objective function that describes the total weekly profit.

Explain why a transaction may have many cursors : Explain why a transaction may have many cursors. Also, how is it possible that a transaction may have more than one cursor on a given table?

Provide a political analysis and comparison : Provide a political analysis and comparison of the following: Athens and Rome. Please detail the political development of the selected systems, the historical context, the similarities, and differences.

High involvement or low involvement purchase : Budweiser is well known for the use of humor in its ad campaigns for Bud Light beer. Based on the use of humor in advertising for beer, does Budweiser believe that beer is a high involvement or low involvement purchase for most consumers? Explain ..

Data and information : Analyze the types of internal records used to support health care marketing applications and make at least one recommendation for an additional source of data and/or information that would prove useful. Explain your rationale.

With respect to http what does stateless mean : Show a snippet of PHP code for disconnecting from the database. Explain the meaning of the code.

User Account

All Pages