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

Question

Quizplus · Accepted Answer

SQL cursors are used to access the results of SQL statements in a program. They allow the program to sequentially iterate through the rows of data returned by the SQL query. Standard programming tools and custom written programming tools are not designed to handle table-oriented SQL results, and SQL triggers are used to execute automatic actions in response to certain database events, not to access SQL query results.

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