Exam Code: 1Z0-149
Exam Questions: 389
Oracle Database 19c: Program with PL/SQL
Updated: 26 Nov, 2025
Viewing Page : 1 - 39
Practicing : 1 - 5 of 389 Questions
Question 1

Subprograms and anonymous blocks can be called by other applications. True or False?

Options :
Answer: B

Question 2

If left out, which of the following would cause an infinite loop to occur in a simple loop?

Options :
Answer: B

Question 3

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.SCOTT creates the following trigger:3SCOTT does not grant the execute privilege on this trigger to any other users.For which user(s) would this trigger fire by default when they drop an object in the hr schema?

Options :
Answer: A

Question 4

Which is true about EXIT and CONTINUE statements?

Options :
Answer: A

Question 5

When modifying procedure code, the procedure must be re-executed to validate and store it in the database. True or False?

Options :
Answer: A

Viewing Page : 1 - 39
Practicing : 1 - 5 of 389 Questions

© Copyrights FreePDFQuestions 2025. All Rights Reserved

We use cookies to ensure that we give you the best experience on our website (FreePDFQuestions). If you continue without changing your settings, we'll assume that you are happy to receive all cookies on the FreePDFQuestions.