Oracle Exam 1Z0-909 Topic 11 Question 44 Discussion

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

Question #: 44
Topic #: 11

[All 1Z0-909 Questions]

Examine these lines of Python code:

You must add a line of code to complete the code to return data to the variable d. Which line will do this?

Ad = cursor.execute(query)

Bd = cursor.execute(query, (hire_start, hire_end) )

Cd = cursor.fetch(query % (hire_start, hire_end))

Dd = cursor.fetch(query, (hire_start, hire_end))

Ed = cursor . f etchall (query)

Fd = cursor.fetchall(query, (hire_start, hire_end))

Show Suggested Answer

Suggested Answer: D

by Shasta at Aug 03, 2024, 02:22 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Marget

3 months ago

I think the answer is E because fetchall returns all rows of a query result.

upvoted 0 times

...

Isadora

3 months ago

I'm not sure, but I think it might be A.

upvoted 0 times

...

Jody

3 months ago

I disagree, I believe the correct answer is D.

upvoted 0 times

...

Jennifer

3 months ago

I think the answer is B.

upvoted 0 times

...

Novella

3 months ago

Hmm, this is a trick question. The correct answer is actually Option F - Cursor.fetchall() with the parameters passed in. Gotta love those database shenanigans!

upvoted 0 times

...

Johnna

3 months ago

Wait, why are we even talking about cursors and databases? This is Python, not SQL! I'd just use a simple list comprehension. Option E is way too complicated.

upvoted 0 times