Quiz 1Z0-147

Quiz 1Z0-147, Program with PL/SQL

To be callable from a SQL expression, a user-defined function must do what?

Which types of trigger do you create?

Which statement will successfully invoke this function in SQL *Plus?

Which three are true statements about dependent objects?

When user A executes the DELETE_TEMP_TABLE procedure, under whose privileges are the operations performed by default?

Which three are valid calls to the add_dep procedure?

Which two statements about packages are true?

Which two programming constructs can be grouped within a package?

which it is declared?

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?