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

How to put more than 1000 values into an oracle in clause?

766


Give the various exception types.

737


How to use "if" statements on multiple conditions?

919


Whether any commands are used for months calculation? If so, what are they?

823


Can objects of the same schema reside in different tablespace?

786


What are the parameters that we can pass through a stored procedure?

804


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1763


What is the difference between 10g OEM and 11g OEM?

732


What is the difference between online and offline backups?

741


What is oracle and what are its different editions?

783


What is a package in oracle?

760


How to download oracle database 10g xe?

773


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1681


Explain what are synonyms used for?

794


What are the oracle built-in data types?

752