1Z0-147 Exam Questions

Your company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the actual modification. If you do not want to store...

In which section of a PL/SQL block is a user-defined exception raised?

Within a PL/SQL loop, you need to test if the current fetch was successful. Which SQL cursor attribute would you use to accomplish this task?

Which two conditions in a PL/SQL block cause an exception to occur? (Choose two.)

Which two dictionary views track dependencies? (Choose two.)

When creating a function, in which section will you typically find the RETURN keyword?