MB6-821 Real Exam Prep DEMO

Question 20: The following code creates an ODBC connection to an external database. Which block of code is valid
and can be inserted into the /*insert answer here*/ line?
If (odbcConnection)
{
sql ="SELECT * FROM MYTABLE WHERE FIELD =" + criteria + " ORDER BY FIELD1,FIELD2 ASC"
perm = new SqlStatementExecutePermission(sql);
perm.assert();
statement = odbcConnection.createStatement();
resultSet = statement.executeQuery(sql);
/*insert answer here*/
}
A.while (resultSet.next()){print resultSet.get(4);print
resultSet.get(3);}resultSet.close();statement.close();pause;
B.while (resultSet.next()){print resultSet.get(1);print resultSet.get(3);}pause;
C.while (resultSet.next()){print resultSet.getString(2);print resultSet.getString(1);}resultSet.close();pause;
D.while (resultSet.next()){print resultSet.getString(1);print resultSet.getString(3);}pause;
Correct Answer: d