Oracle
1Z0-146 · Question #49
View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the procedure. Which three statements are appropriate for protecting the code in the procedure…
The correct answer is A. Explicitly validate the identifier length limit. D. Filter out control characters in user-supplied identifier names. E. Use the object ID of the table from the data dictionary to build the trigger name. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the procedure. Which three statements are appropriate for protecting the code in the procedure from SQL injection? (Choose three.)
Exhibit
Options
- AExplicitly validate the identifier length limit.
- BAdd AUTHID DEFINER to the definition of the procedure.
- CUse PRAGMA RESTRICT_REFERENCES in the procedure.
- DFilter out control characters in user-supplied identifier names.
- EUse the object ID of the table from the data dictionary to build the trigger name.
How the community answered
(37 responses)- A81% (30)
- B5% (2)
- C14% (5)
Community Discussion
No community discussion yet for this question.