what is mean by prmary key and foreign key and how can we
diffrentiate that?
Please answer me.
Advance thanks.

Answer Posted / nimmi

PRIMARY KEY : IS THE UNIQUE KEY OF A SINGLE TABLE THAT IS
THE UNIQUE IDENTIFICATION OF THE SAME TABLE.

FOREIGN KEY: MEANS A UNIQUE KEY IDENTIFICATION COMMON TO TWO
TABLES .

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out the types of joins.

595


What are set operators?

648


Are truncate and delete commands same? If so why?

657


How can we find out the duplicate values in an oracle table?

613


does the query needs a hint to access a materialized view?

1468






what is dynamic SGA and static SGA

3845


How do you tell what your machine name is and what is its IP address?

1517


What happens to the current transaction if the session is ended?

529


What is oracle database 10g express edition?

602


How to shutdown your 10g xe server from command line?

556


Why we use bulk collect in oracle?

538


How to execute a stored program unit?

583


how to do daily transactions with out sql* loader control file regesterd in apps?

1224


Explain oracle’s system global area (sga).

628


What is a subquery in oracle?

580