Oracle Exam 1Z0-819 Topic 3 Question 40 Discussion

Actual exam question for Oracle's 1Z0-819 exam

Question #: 40
Topic #: 3

Consider this method declaration:

A) ''SET SESSION AUTHORIZATION '' + user

B) ''SET SESSION AUTHORIZATION '' + stmt.enquoteIdentifier(user)

Is A or B the correct replacement for and why?

AA, because it sends exactly the value of user provided by the calling code.

BB, because enquoting values provided by the calling code prevents SQL injection.

CA and B are functionally equivalent.

DA, because it is unnecessary to enclose identifiers in quotes.

EB, because all values provided by the calling code should be enquoted.

Show Suggested Answer

Suggested Answer: A

by Weldon at May 26, 2022, 05:41 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!