Quiz 1Z0-147

Quiz 1Z0-147, Program with PL/SQL

Which two statements about packages are true? (Choose two)

Which statement is true?

Which statement will successfully assign $75,000,000 to the V_MAX_TEAM_SALARY variable from within a stand-alone procedure?

How many rows are inserted into the AUDIT_TABLE?

Which statement is true?

What type of trigger is it?

Which table should you query to determine when your procedure was last compiled?

What part of a database trigger determines the number of times the trigger body executes?

What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?