Prpgram With Pl/sql - Oracle 9I Exam 1Z0-147 - Help

[YousifinOoOo]

Dear forum members i need a help in answering these questions

Which three are true statements about dependent objects? Choose 2
A. Invalid objects cannot be described
B. An object with status of invalid cannot be a referenced object
C. The Oracle server automatically records dependencies among objects/You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view
D. All schema objects have a status that is recorded in the data dictionary
E. You can view whether an object is valid or invalid in the USER_STATUS data dictionary view

[YousifinOoOo]

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

A. Be stored only in the database
B. Have both IN and OUT parameters
C. Use the positional notation for parameters
D. Return a BOOLEAN or VARCHAR2 data type