Oracle Exam 1Z0-144 Topic 2 Question 1 Discussion

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

Question #: 1
Topic #: 2

Identify two situations where the DBMS_SQL package should be used. (Choose two.)

AThe SELECT list is not known until run time.

BThe dynamic SQL statement retrieves rows into records.

CYou do not know how many columns a select statement will return, or what their data types will.

DYou must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.

Show Suggested Answer

Suggested Answer: A, C

by Andra at May 05, 2022, 02:10 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!