what is the difference between primary key & foreign key?

Answer Posted / raji

foregin key reference a primary key in another table

and primary key is used to identify a row.

Is This Answer Correct ?    30 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give the different types of rollback segments.

583


How to calculate date and time differences in oracle?

535


What is a relational database management system?

679


What is a proxy object?

581


Does facebook use oracle?

581






How to call a stored function in oracle?

574


what are the advantages of running a database in archive log mode?

1735


What is concurrency in oracle?

547


What is meant by a deadlock situation?

577


How can I get column names from a table in oracle?

538


What is oracle host variable?

538


what is difference between sql plus and sql*plus? (not sql and sql plus).

3351


What are the differences between number and binary_float in oracle?

571


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1460


What is meant by joins? List out the types of joins.

528