About Question enthuware.ocpjp.ii.v11.2.3372 :

[Sergiy Romankov]

stmt.enquoteIdentifier(mode, false) doesn`t make code safe, second parameter should be true

[admin]

Why do you think so?
true and false values produce the same result for non-simple sql identifiers.
You might want to checkout the JavaDoc description.

[philippe]

Why is enquoteIdentifier used instead of enquoteLiteral? What you want to do here is pass a literal.

[admin]

Yes, it should be enquoteLiteral. Fixed.
thank you for your feedback!

[philippe]

You're welcome. Is it possible to also push the change in the 1z0-816 question bank?

[admin]

Yes, done.

[philippe]

When I check the version for the 1z0-816 question bank, I still see version 1.30. Does the new version still have to be pushed?

[admin]

If multiple minor corrections reported during a small time frame, they are all applied together and then the version number is updated. This is done to ensure that users are not annoyed by too many update notifications in a short span.

If a critical error is fixed (such as a wrong answer to a question), we apply the fix, update the version number and release the new question bank file immediately.

In this case, the version number has also been updated to 31 and the notification will also be updated soon.

[OliviaJohnson]

How does the plus sign(+) syntax work? Oracle docs on Statement/PreparedStatement/java.sql/Wrapper does not have any plus sign(+).

[admin]

Not sure I understand your question. Which + sign and in what place are you talking about?

[OliviaJohnson]

Hi, I was talking about this

Code: Select all

+mode+

[admin]

Oh, that is just string concatenation. mode is a parameter. So,
String qr = "SET SESSION sql_mode = '"+mode+"';";
will actually produce this string:
SET SESSION sql_mode = MODEVALUE;

Where, MODEVALUE is the whatever was passed as the mode parameter.