Question about Mock Exam 3 OCP Book - Online Material

[John Longer]

Hi

Mock Exam 3

There are currently 100 rows in a table species before inserting...

Code executes update for row 3, where 3 is primary key.
I believe it shall throw SQLIntegrityConstraintViolationException because of duplicate key value.
If we have 100 rows already, we may add 101st row only, isn't it?

[Jeanne Boyarsky]

John,
The question doesn't say the keys were inserted in order. You can't assume things ;).

More importantly, the exam doesn't expect you to know SQL. Which means it is testing you about other things in the question.

[John Longer]

I see, but at the same time you can't assume that keys (in this case it is primary key) are not in order (although most likely they are).
Question is ambiguous.

[Jeanne Boyarsky]

Maybe. However, if an exam question is ambiguous on the real exam, you can't make any assumptions there either.

Again, I'd like to point out that key uniqueness is not on the exam. We cover it because a reader who doesn't know JDBC will run into it when practicing.

[John Longer]

I understand your point.
Thank you.