Oracle
1Z0-144 · Question #18
1Z0-144 Question #18: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-144 to reveal the answer and full explanation for question #18. The question stem and answer options stay visible for context.
Question
Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)
Options
- AWhen a query returns multiple rows
- BWhen a column name in a where clause is unknown at compile time.
- CWhen the number of columns selected in a query is not known until run time
- DWhen a table needs to be created based on an existing table structure at run time
- EWhen privileges need to be granted to a new user to access an existing schema at run time
Unlock 1Z0-144 to see the answer
You've previewed enough free 1Z0-144 questions. Unlock 1Z0-144 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.