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

Answer Posted / raveendran

Primary key is unique across entire table.In primary key
not null constraint is activated.Only one primary key in
one table.

foreign key points to primary key of another table

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we delete duplicate rows in a table?

568


What is tns service name?

625


How to assign a tablespace to a users in oracle?

591


What to do if the binary spfile is wrong for the default instance?

565


What are the uses of Database Trigger ?

1105






Why do we use coalesce function in oracle?

632


What exactly do quotation marks around the table name do?

546


How to connect the oracle server as sysdba?

633


What are joins, explain all types of joins?

1724


How to create a new tablespace in oracle?

560


How many categories of data types in oracle?

606


What's dateware house and what's clustor with practicle example

1643


What is flashback in Oracle?

581


What would you do with an in-doubt distributed transaction?

1470


What is a select query statement in oracle?

545