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

Answer Posted / ysailajasantosh

Primary key means a unique key which is constant.

A foreign key (FK) is a column or combination of columns
that is used to establish and enforce a link between the
data in two tables. You can create a foreign key by
defining a FOREIGN KEY constraint when you create or modify
a table.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain enable novalidate constraint.

599


Can we connect to ORACLE db using Windows Authentication?

723


How to commit the current transaction in oracle?

578


What are the types of trigger in oracle?

577


11. Display the client number and name and the client number and name of the person who referred that client.

1922






What is clustered table in Oracle?

645


What is hash cluster in oracle?

596


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1744


What is the difference between sharding and partitioning?

504


How to use subqueries with the exists operator in oracle?

608


how to join query for one source type is oracle another source type is sql server ?

1993


Can you assign multiple query result rows to a variable?

552


Why do you use stored procedures and state some of its disadvantages?

567


Explain the use of rows option in imp command.

604


How to sort output in descending order in oracle?

580