AIncorrect Answer

Although API calls are not discussed in this module, the functionality of the API calls themselves ARE discussed. In this case, executing an SQL statement is a reasonable action which an embedded SQL system should support.

close

BIncorrect Answer

Although API calls are not discussed in this module, the functionality of the API calls themselves ARE discussed. In this case, connecting to the database is a reasonable action which an embedded SQL system should support.

close

CIncorrect Answer

Although API calls are not discussed in this module, the functionality of the API calls themselves ARE discussed. In this case, binding a variable to a column is a reasonable action which an embedded SQL system should support. It is then possible using other API calls to "single-step" through all the rows in the table bound to until the entire table has been accessed.

close

DCorrect Answer

Although API calls are not discussed in this module, the functionality of the API calls themselves ARE discussed. In this case, binding a variable to a row is NOT reasonable action which an embedded SQL system should support. Normally we bind to a column, and then the API calls are used to "single-step" through all the rows in the table bound to until the entire table has been accessed. Binding to a row is difficult, as we do not know in advance how many rows are in the table...

close

EIncorrect Answer

Although API calls are not discussed in this module, the functionality of the API calls themselves ARE discussed. In this case, counting rows is a reasonable action which an embedded SQL system should support.

close

A B C D E TELL ME NEXT INDEX
 
 

Most of the following are API calls defined in a particular database curson system. Select the least plausible call.

  1. SQLExecute: Executes a statement
  2. SQLConnect: Connects to a specific driver by data source name, User ID, and password
  3. SQLBindCol: Binds an application variable to a column
  4. SQLBindRow: Binds an application variable to a row
  5. SQLRowCount: Returns the number of rows affected by the insert update or delete request.