1D0-442 CIW Enterprise Specialist Practice Exam

Demo Question 1.

Consider the following statement: PrepStmt = dbConnn.prepareStatement ("INSERT INTO MyTable (ID, FSTNAME, LSTNAME. VALUE (?, ?, ?)"); The prepStmt member is of type PreparedStatement. The dcbConn member is of type Connection and represents a connection to a database. The ID column is an int data type. The FSTNAME and LSTNAME columns are VARCHAR data types. The value for the? Placeholders in the SQL statement are held by member variables named id, fstName and lstName respectively. Which of the following statements would properly execute the statement given in this question?

A. prepStmt. SetInteger (1, id); prepStmt. SetString (2, fstName); prepStmt. SetSTring (3, lstName); dbConn.executeUpdate (prepStmt);
B. prepStmt. SetInteger (0, id); prepStmt. SetString (2, fstName); prepStmt. SetSTring (3, lstName); prepStmt. ExecuteUpdate ();
C. prepStmt. SetInteger (0, id); prepStmt. SetString (2, fstName); prepStmt. SetSTring (3, lstName); dbConn. ExecuteUpdate (prepStmt);
D. prepStmt. SetInteger (1, id); prepStmt. SetString (2, fstName); prepStmt. SetSTring (3, lstName); prepStmt. ExecutUpdate ();


Display Answer

Answer:

Explanation: