Home » Other » General » Question about dependent objects
Question about dependent objects [message #121453] Sun, 29 May 2005 23:05 Go to next message
erik_swe
Messages: 1
Registered: May 2005
Junior Member
Hi all,

I'm not sure if this is the right thread to post this questions but I give it a try.

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 clarify this for me.

Many thanks
erik
Re: Question about dependent objects [message #168346 is a reply to message #121453] Wed, 19 April 2006 22:54 Go to previous message
kokichi34
Messages: 6
Registered: May 2005
Junior Member

A is wrong.
When I select invalid object from User_objects view, I choose a invalid object and command Desc object, I still see the description of it.

So the correct answer for this question is : C,D,F.
Previous Topic: What is meaning of " i " In Oralce8i
Next Topic: Everyday Oracle DBA by April Wells
Goto Forum:
  


Current Time: Sat Nov 23 02:35:07 CST 2024