Oracle
1Z0-144 · Question #18
Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)
The correct answer is B. When a column name in a where clause is unknown at compile time. C. When the number of columns selected in a query is not known until run time. See the full explanation below for the reasoning.
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
How the community answered
(24 responses)- A4% (1)
- B75% (18)
- D13% (3)
- E8% (2)
Community Discussion
No community discussion yet for this question.