Technical - For referential integrity to be maintained.A. Every foreign key value must have a corresponding prim

GeekInterview.com > Placement Papers > Oracle > Technical

Go To First | Previous Question | Next Question

Technical | Question 22 of 126

For referential integrity to be maintained.

A. Every foreign key value must have a corresponding primary/unique key value
B. No foreign key should have a corresponding primary key value.
C. There should be an index on the tables.
D. The tables should be in different schemas of the database.

Total Answers and Comments: 3

Last Update: January 06, 2007

Sponsored Links

Best Rated Answer

—

Submitted by: sithusithu

Each Foreign Key must exist as a Primary Key.
Foreign Keys can change values over time.

Cheers.

Sithu

Above answer was rated as good by the following members:
adeshgupta

August 11, 2005 05:52:11

Rohit

RE: For referential integrity to be maintained.A. Every foreign key value must have a corresponding prim...

Choice A is correct

Is this answer useful? Yes | No

January 17, 2006 00:50:31

sithusithu

Member Since: December 2005 Contribution: 161

RE: For referential integrity to be maintained....

Each Foreign Key must exist as a Primary Key.
Foreign Keys can change values over time.

Cheers.

Sithu

Is this answer useful? Yes | No

1 0

Overall Rating: +1

January 06, 2007 06:25:44

RE: For referential integrity to be maintained....

Ans A) is correct

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank