To establish a relationship between 2 tables. pk=(unique+not null) fk=uni

what is primary key and foreign key when and where have to use

Question Posted / csprusty

Answer Posted / csprusty

To establish a relationship between 2 tables.
pk=(unique+not null)
fk=unique

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Which is faster join or subquery in oracle?

948

How to execute the package in oracle?

1056

How to retrieve the count of updated rows?

1076

How to create a new user account in oracle?

977

What is integrity and what is constraint??Explain with example

2233

How to check the oracle tns settings?

1006

How would you change old and new values in an insert, delete and update triggers?

971

What do you mean by redo log file mirroring?

992

Give the different types of rollback segments.

992

What is a nested table and how is it different from a normal table?

1005

What is private procedure oracle?

968

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5366

How to assign query results to variables?

1026

what is the difference between substr and instr function in oracle?

1056

How to assign a table row to a record variable?

988