Oracle Exam 1Z0-819 Topic 3 Question 81 Discussion

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

Question #: 81
Topic #: 3

[All 1Z0-819 Questions]

Given these declarations:

and these two code fragments:

Fragment 1:

Fragment 2:

Which code fragment is preferred and why?

AFragment 1 because it is shorter.

BFragment 2 because it prevents SQL injection.

CFragment 2 because it explicitly specifies the SQL types of the column values.

DFragment 1 because it is more performant.

Show Suggested Answer

Suggested Answer: B

by Jennifer at May 20, 2024, 09:26 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-819 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Marshall

11 months ago

Definitely Fragment 2. I mean, come on, who wants their app to get hacked? Not this guy. SQL injection is no joke, my friend.

upvoted 0 times

...

Nickole

11 months ago

Ooh, this is a tough one! I'm torn between the two. Maybe I'll just flip a coin. Or wait, I know - eenie, meenie, miny, moe!

upvoted 0 times

...

Nadine

11 months ago

Hmm, I'm not sure. Fragment 1 might be a bit more performant, but is that really worth the risk of SQL injection? I think I'll have to go with Fragment 2 on this one.

upvoted 0 times

Annice

10 months ago

Definitely, safety first. Fragment 2 it is.

upvoted 0 times

...

Brittani

10 months ago

I agree, preventing SQL injection is crucial. Fragment 2 is the way to go.

upvoted 0 times

...

Susana

10 months ago

Fragment 1 might be faster, but Fragment 2 is safer.

upvoted 0 times

...

Ettie

11 months ago

I'm with Gaynell on this one. Fragment 2 is the clear winner. Who cares if it's a bit longer? Security should always come first.

upvoted 0 times

...

Gaynell

11 months ago

I think Fragment 2 is the way to go. Preventing SQL injection is crucial for security, and explicitly specifying the SQL types is just good practice.

upvoted 0 times

Ronald

10 months ago

Fragment 2 because it explicitly specifies the SQL types of the column values.

upvoted 0 times

...

Charolette

10 months ago

Fragment 2 because it prevents SQL injection.

upvoted 0 times

...

Matt

10 months ago

Fragment 2 because it explicitly specifies the SQL types of the column values.

upvoted 0 times

...

Stephaine

10 months ago

Fragment 2 because it prevents SQL injection.

upvoted 0 times

...

Karl

10 months ago

It's always better to be safe than sorry when it comes to SQL injection.

upvoted 0 times

...

Douglass

11 months ago

Fragment 2 is definitely more secure.

upvoted 0 times

...

Frankie

11 months ago

I agree, preventing SQL injection is a top priority.

upvoted 0 times

...