Quiz 1Z0-147

Quiz 1Z0-147, Program with PL/SQL

Where should you declare this variable?

What happens when the user updates rows on the EMP table?

Under which condition does this trigger fire?

Which two tables or views track object dependencies? (Choose two)

Which three are true regarding error propagation? (Choose three)

A dependent procedure or function directly or indirectly references one or more of which four objects? (Choose four)

When creating a function, in which section will you typically find the RETURN keyword?

Which two actions must you take? (Choose two)

Which two statements about the overloading feature of packages are true? (Choose two)

For the timing information, which are valid with a DML trigger?