Re: An OCP question (2)

A)
You'll need to use dba_constraints 2 times to retrieve 1) the foreign key
2) the table it refers to
And I would definitely want to know the affected columns so IMO a is the correct answer

Regards,

--
Sybrand Bakker, Oracle DBA
fumi <fumi_at_tpts5.seed.net.tw> wrote in message news:80sftk$agj$4_at_news.seed.net.tw...
> Hi,
>
> Here is another OCP exam question.
> I lost one point in "Maintain Data Integrity" section.
> I think the following question is the one:
>
> Question: Some user encountered an "ORA-xxxxx: foreign key violated".
> How do you identify the relational integrity between the two tables?
> A. Write a script to query DBA_CONSTRAINTS and DBA_CONS_COLUMNS.
> B. Write a script to query DBA_CONSTRAINTS.
> C. Write a script to query DBA_CONS_COLUMNS.
> D. There is no way to know the information of relational integerity.
>
> I chose A first, then change to B,
> since it asked only the "relational integrity" (I am sure),
> but not columns of the foreign key.
>
> Can someone tell me which one would you choose? A or B?
>
>
>
Received on Tue Nov 16 1999 - 15:15:40 CST