Oracle Exam 1Z0-819 Topic 9 Question 63 Discussion

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

Question #: 63
Topic #: 9

[All 1Z0-819 Questions]

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 Pamella at May 27, 2023, 03:39 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

18 days ago

I think B is the correct answer. Enquoting the user value helps prevent SQL injection, which is important for security.

upvoted 0 times

...

26 days ago

I'm not sure, but I think A might be better because it sends exactly the value of user provided.

upvoted 0 times

...

28 days ago

I agree with Gladys, B is definitely the safer option.

upvoted 0 times

...

1 months ago

I think B is the correct replacement because it prevents SQL injection.

upvoted 0 times

...