Quiz 1Z0-147

Quiz 1Z0-147, Program with PL/SQL

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

What type of trigger is it?

Which statement is true?

How many rows are inserted into the AUDIT_TABLE?

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

Which statement is true?

Which command can you issue to see the actual error message?

Which four triggering events can cause a trigger to fire?

Which statement, when added to the above procedure will successfully invoke the UPD_BAT_STAT procedure?

Which statement about triggers is true?