Exam 1z0-148 topic 1 question 64 discussion

Actual exam question from Oracle's 1z0-148

Question #: 64
Topic #: 1

[All 1z0-148 Questions]

Examine this function call:
cur_num := DBMS_SQL.TO_CURSOR_NUMBER (cur_val);
Which two statements are true?

A. CUR_VAL must be opened after this line is executed in the PL/SQL block.
B. CUR_VAL must be a weakly typed cursor variable.
C. CUR_VAL can be either a strongly or weakly typed cursor variable.
D. CUR_VAL must be opened before this line is executed in the PL/SQL block.
E. The PL/SQL block can continue to use the cursor variable after this line is executed.

Show Suggested Answer

Suggested Answer: BC 🗳️

by orakell at Dec. 1, 2019, 9:55 p.m.

Comments

Submit Cancel

orakell

Highly Voted 5 years, 6 months ago

Seriously? How on earth are the correct answers chosen? B and C clearly contradict each other. The correct answers are C and D. I greatly appreciate the help this site provides but maybe it'd be better if it didn't provide answers at all.

upvoted 10 times

szefco

4 years, 11 months ago

https://livesql.oracle.com/apex/livesql/file/content_C1W23DSC9K441CR5RULGGBVW4.html DBMS_SQL.to_cursor_number Description: This function takes an OPENED STRONGLY OR WEAKLY-TYPED ref cursor and transforms it into a DBMS_SQL cursor number. Primary use case: dynamic SQL scenario in which you have a fixed number of bind variables (handled neatly with cursor variables) and a variable number of expressions in the SELECT list (handled best with DBMS_SQL). Doc: http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_sql.htm#CHDJDGDG

upvoted 1 times

...