Oracle Exam 1Z0-149 Topic 9 Question 48 Discussion

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

Question #: 48
Topic #: 9

[All 1Z0-149 Questions]

Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

AImplicit cursor returns only one record.

BExplicit cursor can return more than one record.

C%Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.

D%Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

E%Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.

F%Isopen is always false in Explicit Cursor.

G%Isopen is always false in Implicit Cursor.

Show Suggested Answer

Suggested Answer: B, C, G

by Linwood at Mar 24, 2025, 09:01 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Alesia

2 months ago

I'm going to go with B, C, and D. Explicit cursors are like the divas of the database world - they have all the fancy attributes. But don't worry, I won't cursor you out if you get this one wrong. *laughs*

upvoted 0 times

Denise

1 months ago

Yeah, explicit cursors can return more than one record and have all those fancy attributes. Good choice!

upvoted 0 times

...

Xochitl

1 months ago

I think you're right! Explicit cursors are definitely the divas with all those attributes.

upvoted 0 times

...

Earnestine

2 months ago

Hmm, let's see... I'm pretty sure B, D, and G are the right answers. Implicit cursors always have %Isopen set to false, right? Although, I must admit, I sometimes get my cursors crossed, if you know what I mean. *winks*

upvoted 0 times

...

Lashawnda

2 months ago

I believe D is also true. %Rowcount is an attribute of Explicit Cursor.

upvoted 0 times

...

Pura

3 months ago

Whoa, this question is a real brain-teaser! I'm going to go with B, D, and E. Surely, the explicit cursor must have %Type, right? That's my two cents, but who knows, maybe I'm just being a wise guy.

upvoted 0 times

...

Lashandra

3 months ago

B, C, and D are the correct statements. Implicit cursor returns only one record, while explicit cursor can return multiple records. The attributes for explicit cursor are %Isopen, %Rowtype, %Notfound, and %Found.

upvoted 0 times