Quiz 1Z0-147

Quiz 1Z0-147, Program with PL/SQL

If you want to run the above function from the SQL *Plus prompt, which statement is true?

Which two dictionary views track dependencies? (Choose two)

Which statements are true? (Choose all that apply)

What type of trigger do you create?

What happens if the stand alone procedure VALIDATE_PLAYER_STAT references this package?

Which statement is valid when removing procedures?

Which statement is true?

Which code can you use to ensure that the salary is not increased by more than 10% at a time nor is it ever decreased?

Which two statements describe the state of a package variable after executing the package in which it is declared? (Choose two)

Which two programming constructs can be grouped within a package? (Choose two)