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?