An OCP question (2)

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 16 Nov 1999 20:47:48 GMT
Message-ID: <80sftk$agj$4@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 - 14:47:48 CST