About Question enthuware.ocpjp.v7.2.1377 :

[ewebxml]

This is not best practice:

int supplierID = rs.getInt("SUP_ID");
or
int sid = rs.getInt("SID");

One should use rs.getInt("int_type") when the column type in the table is an int.

----- -----

The question was written like this just to let you know that
if you see it on the exam, it will compile and work.

"An int column in a table can be retrieved using getString()"


http://docs.oracle.com/javase/tutorial/ ... eving.html

Please confirm.

[admin]

I am not sure I understand your question. It is true that an int column can be retrieved using getString.

[ewebxml]

Best Practices
http://docs.oracle.com/javase/tutorial/ ... eving.html

would discourage using
getString() to retrieve an int column in a table,

but since it can be done,
it is something that one should be aware of for the exam.

Do you agree or disagree?

[admin]

Yes, agree.

[Javier]

Hi Paul,
Very silly question: is this data rows or columns?
SID INT Primary Key
NAME VARCHAR(50)
GPA INT
columns, isn´t it?
Thank you

[admin]

That depends on what you are printing. Whenever you fire a query, it always returns "rows". Depending on what query you have fired, those rows may contain table data or table meta-data (i.e. column details.).