1Z0-147 무료 덤프문제 온라인 액세스

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

• A.USER_DEPENDS
• B.USER_DEPTREE
• C.USER_IDEPTREE
• D.IDEPTREE
• E.USER_DEPENDENCIES

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

• A.USER_PLSQL_UNITS
• B.USER_OBJECTS
• C.USER_PROCEDURES
• D.USER_PROCS

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

• A.An exception cannot propagate across remote procedure calls.
• B.The use of the RAISE; statement in an exception handler reraises the current exception.
• C.An exception raised inside a declaration immediately propagates to the current block.
• D.An exception raised inside an exception handler immediately propagates to the enclosing block.

The creation of which database objects will cause a DDL trigger to fire? (Choose all that apply)

• A.Package
• B.Index
• C.Database links
• D.Function
• E.Dimensions
• F.Synonyms
• G.Cluster

When creating stored procedures and functions, which construct allows you to transfer values to and from the calling environment?

• A.local variables
• B.arguments
• C.Substitution variables
• D.Boolean variables