dependent objects in pl/sql

[Erikxxx]

Hi all,

I'm preparing for the 1Z0-147 exam and have encountered the following question.

Which three are true statements about dependent objects? (Choose three)
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.
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.
F. You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.

The answers I've been provided with are : A, C, F

I would also say that D is correct since I thought all objects had a status (invalid/valid) that is tracked in the data dictionary but I might be wrong here. Could anyone please give me some hints here.

Many thanks
Erik

 

[sem]

No, tables has no such status though are still listed in USER_OBJECTS.

Regards, Dima

http://seminihin.narod.ru

 

[Erikxxx]

Hi Sem,

thanks for this and that's true. Table's are always valid therefore no such status

Regards
Erik

 

[SantaMufasa]

Erik/Dima,

I have a problem with the notion that "A. Invalid objects cannot be described." Note the following:

select object_name, status, object_type
from user_objects
where status <> 'VALID';

OBJECT_NAM STATUS  OBJECT_TYPE
---------- ------- ------------
MREPLICATE INVALID TRIGGER
VAC        INVALID PACKAGE BODY

SQL> desc vac
FUNCTION CALC RETURNS NUMBER
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERS_CODE                      NUMBER                  IN
 DCN_CODE                       VARCHAR2                IN

So, if "VAC" is "INVALID", then way can I successfully "desc vac"? I believe the response, "A. Invalid objects cannot be described." is incorrect.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[SantaMufasa]

My belief is that the third correct response is: "B. An object with status of invalid cannot be a referenced object." Although Oracle will automatically attempt to recompile an INVALID object, if the re-compile is unsuccessful, leaving the object in an INVALID status, then the reference will throw an error. Thus, "An object with status of invalid cannot be a referenced object."

Erik, who provided answers "A, C, and F" and why do you believe that the person is a reliable source?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[sem]

Dave, you describe package specification and it's valid.

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

Good catch, Dima.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[Erikxxx]

Hi all,

SantaMufasa: I'm going through many of all "braindumps" that exist on the internet. I truley don't rely on the sources providing all these dumps, but the questions itself are great for practise. Most of the time it's been easy for me to confirm that an answer is correct or incorrect (checking against Oracle manuals etc) but there are a few vague once like this one where I need to get help from you guys. Thanks to all of you!!

I believe you are totally right here saying that
the answers should be B,C,F.

Thanks
Erik