Because SQL statements are table-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are accessed using ________.
A)standard programming tools
B)custom written programming tools
C)an SQL cursor
D)an SQL trigger
E)an SQL stored procedure

Question

Quizplus · Accepted Answer

SQL cursors are used to traverse the result set of an SQL query in a programmatic way, allowing the program to access the individual rows and columns returned by the query. This allows the program to work with the results in an element-oriented manner, rather than the table-oriented approach used by SQL statements themselves. Standard programming tools may not be able to handle the table-oriented results of SQL statements, while custom written programming tools may be too resource-intensive or difficult to maintain. SQL triggers and stored procedures are not directly related to accessing query results in a programmatic way.

Because SQL Statements Are Table-Oriented,whereas Programs Are Element-Oriented,the Results of SQL