Study tips 1Z0-146

(Choose all that apply.)

Which two statements are true about BFILES?

What should you correct in the above code to ensure that it executes successfully?

Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is used to create a temporary LOB?

Which two queries’ results cannot be cached?

What is the outcome?

Which two are major approaches that can be used to reduce the SQL injection by limiting user input?

Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection?

Which guidelines should be considered when designing and using cursors in a PL/SQL block? ?

Which statement would be true in this scenario?